Oracle, ODBC, and VERY odd error message

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. Received on Tue Jul 13 1999 - 14:38:36 CDT