Re: Oracle, ODBC, and VERY odd error message

check your VC++ code to make sure there are not strange characters embedded in it (even hidden in it). I've had this happen before and I found strange characters at the end of a line.

Liz

In article <7mg4js$sc9$1_at_nnrp1.deja.com>,   bauda_at_my-deja.com wrote:
> Hello, my name is Dan and I'm writing a Windows application in Visual
> C++ 6 that communicates with an Oracle database on a RS/6000 server.
I
> am connecting to the database via ODBC drivers. Unfortunately, we are
> using Oracle Client 8.0.3, which only supports ODBC 2.5 drivers. So,
I
> installed these drivers and everything appeared to be working fine.
>
> However, when I call my initial SQL statement, I receive a very
strange
> error. The error is "ORA-01013: user requested cancel of operation."
> I researched this error and I found the following documentation:
> "The user interrupted an Oracle operation by entering CTRL-C, CONTROL-
> C, or another canceling operation. This forces the current operation
> to end."
>
> I cannot do anything as a result of this error message. I have traced
> the problem down to a certain line in my SQL call. Here it is...
> SELECT * FROM [DAN].[COLINE], [DAN].[WHDEMAND] WHERE ([DAN].[COLINE].
> [LINE_NBR] = [DAN].[WHDEMAND].[LINE_NBR])
> By the way, my VC++ program replaces the brackets with single quotes.
>
> Anyway, I can telnet into the system and execute this SQL statement.
> It takes about 1 minute to run, but it does work!! However, when I
> access the database through my program, via the ODBC drivers, it does
> not work and I get that weird error message. So, does anyone know if
> my ODBC drivers are timing out or if there is another problem? I have
> checked the configuration of my ODBC driver and I did not see any
> timeout field.
>
> Please, if anyone can help, I would greatly appreciate it.
> Thanks
> Dan
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 13 1999 - 17:33:26 CDT