ODBC error

[fheyn]

hi,
this problem is really bothering me:
I do have a VC++ application connecting thru ODBC to
ORACLE. The app is constantly running, looking every now
and then if there have been new entries in a certain table.
Data found is processed correctly, but 5 - 10 times a day the program crashes with :
[Mircosoft][ODBC Driver Manager] the driver doesn't support
the version of ODBC behavior that the application requested
OK, if it's not working at all, I understand the message.
But it does and does and does and then ...
Connecting to SQL-Servers has it running for days.
Any suggestions welcome.
thanks in advance

 

[MaffewW]

I suppose you could try reinstalling/upgrading mdac on the client machine if you havent tried that already. Just a thought

 

[chintan]

Check the version of the ODBC driver with the ORACLE vendor and ask as to which ODBC specification is the driver compliant. This type of errors usually occur for eg: the ODBC libraries used by VC++ call an ODBC API which is not supported in a particular version of the ORACLE ODBC driver. You can more information if you can enable tracing through ODBC Administrator. Bring up ODBC Administrator->Go to Tracing Tab->specify the log file name and click on start tracing. Then run your VC++ application. Later stop the tracing as leaving it to ON slows down any applications using ODBC. Then check the log file for the ODBC API calls being made.
Hope this helps.

-Chintan.

 

[pkane]

Have you turned on trace?

You could also try setting the version.
The ODBC API call is...

SQLSetEnvAttr( ghEnv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0 );

where ghEnv is your environment handle.

Good luck!