Help needed with using an IBM ODBC driver

[tommydkat]

Hi! We've switched from Developer Studio 6.0 to Visual Studio .net
2003. Our application compiles fine with Visual Studio .net 2003 but
when it runs, it uses the Microsoft ODBC driver as is shown in this
function sequence error we're getting when we issue an UPDATE SQL query
to our DB2 database:

State:S1010,Native:0,Origin:[Microsoft][ODBC Driver Manager]

The IBM ODBC driver is installed. When I go to "Start/Settings/Control
Panel/Administrative Tools/Data Sources (ODBC)" and look at my data
sources, I see the IBM ODBC driver listed as the driver for all of my
DB2 databases.

I've read in this help page:

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/his/db2odbc1_8jtu.htm

that Microsoft provides an IBM DB2 ODBC driver, so maybe that's the one
being used instead of the IBM supplied driver.

Any ideas on how to get the IBM supplied ODBC used instead of the
Microsoft ODBC driver, whether that's the Microsoft DB2 ODBC or not?

Thanks in advance for your time and assistance!

Peace...

Tom

 

[tommydkat]

Well, I found out what the problem actually was. It had nothing to do
with the IBM DB2 ODBC driver. CDatabase::ExecuteSQL() in Visual Studio
..net 2003 now throws a CDBException when the query returns an empty
result set due to no data being found. In DevStudio 6,
CDatabase::ExecuteSQL() didn't behave this way and this new behavior is
causing the problem for me.

This bug report identifies the area of code in question:

http://support.microsoft.com/kb/246165/en-us

Peace...