Re: ODBC problem help needed...

I have the exact same problem with almost the same setup. However, I have gotten it to work on a machine with office 97 on it. But get this, Access97 can get to the data but MS Query gives the aforementioned error. What's going on here? Two apps from the same bundle won't work with the same DSN? There has got to be a better way!

Clay

Ali.Baskomurcu_at_datem.com.tr wrote in article <868348967.22902_at_dejanews.com>...
> Hi everybody,
> We have a problem in connecting to Oracle73 using ODBC. The version
> numbers of our tools are listed below. We receive the following two error
> messages.
>
> SQLSTATE : 08003
> Native Error code : 0
> Driver Message : [Oracle][ODBC Oracle Driver] Connection not open
>
> SQLSTATE : 01000
> Native Error code : 0
> Driver Message : [Microsoft][ODBC Driver Manager] The driver returned
> invalid (or failed to return) SQL_DRIVER_ODBC_VER: %s
>
> Tools and versions:
> Oracle Server 7.3 on Windows NT Server 4.0 (Service Pack 3)
Received on Tue Jul 08 1997 - 00:00:00 CDT