Oracle 7.0 ODBC & MS Query

From: Chris Cummings <chrisc_at_netcom.com>
Date: Mon, 23 May 1994 19:16:34 GMT
Message-ID: <chriscCq9s7n.B99_at_netcom.com>

I have installed the Oracle 7.0 ODBC driver on my PC and am now trying to test it out using Microsoft Query. I followed the installation instructions and was told it completed successfully. I then checked the ODBC dialog box under the Control Panel and the Oracle driver was listed there.

When I run MS Query and tell it to use the Oracle driver as the data source I get the following error:

  'Driver specified by data source could not be loaded'

I checked the odbc.ini file and made sure that the path listed for the Oracle driver was correct. It was. I then turned the ODBC trace on and tried again with the same results. The output of the trace doesn't mean a thing to me. It follows:

SQLAllocEnv(phenv231F0000);
SQLAllocConnect(henv231F0000, phdbc2E270000);

SQLDataSources(henv231F0000, 2, szDSN, 33, pcbDSN, szDescription, 256, pcbDescription);
SQLDataSources(henv231F0000, 1, szDSN, 33, pcbDSN, szDescription, 256, pcbDescription);
SQLDataSources(henv231F0000, 1, szDSN, 33, pcbDSN, szDescription, 256, pcbDescription);
SQLDataSources(henv231F0000, 1, szDSN, 33, pcbDSN, szDescription, 256, pcbDescription);
SQLDataSources(henv231F0000, 1, szDSN, 33, pcbDSN, szDescription, 256, pcbDescription);
SQLDataSources(henv231F0000, 1, szDSN, 33, pcbDSN, szDescription, 256, pcbDescription);
SQLDataSources(henv231F0000, 1, szDSN, 33, pcbDSN, szDescription, 256, pcbDescription);

SQLError(henv231F0000, hdbc2E270000, hstmt00000000, szSqlState, pfNativeError, szErrorMsg, 512, pcbErrorMsg); SQLError(henv231F0000, hdbc2E270000, hstmt00000000, szSqlState, pfNativeError, szErrorMsg, 512, pcbErrorMsg); SQLFreeConnect(hdbc2E270000);
SQLFreeEnv(henv231F0000);

Does anyone know what is happening here?

Thanks,

Chris Cummings
Dallas Softworks, Inc. Received on Mon May 23 1994 - 21:16:34 CEST