Re: Oracle ODBC driver for Windows 2000

lorijo <member_at_dbforums.com> wrote in message news:<1865860.1033137743_at_dbforums.com>...
> I have tried using two different oracle odbc drivers. The first one is
> oracle odbc driver version 8.00.05.00 and the other is microsoft odbc
> for oracle version 2.573.4403.00.
>
> The machine is Windows 2000 and the version of Microsoft Access is 95.
> We are connecting to our oracle database which is version 7.34.
>
> Please help....i am not sure why this connection won't work. It
> worked fine on Windows 98. I am setting up the odbc connection as a
> system dsn.

First, I'm assuming you have the 8.0.5 Oracle client installed. You can grab the 8.0.5.10 Oracle ODBC driver from OTN-- that at least gets you closer to the Windows 2000 time frame. If it's an option, you may want to try upgrading to the 8.1.7 Oracle client and 8.1.7 Oracle ODBC driver, since that's the earliest version of the client that's still supported (may be to first version to officially support Windows 2000).

If you grab the latest ODBC driver, it should have a "test connection" option in the DSN setup screen. See whether that test will work.

Justin Received on Fri Sep 27 2002 - 19:06:56 CDT