ODBC Connection to 8i - MS Access 2000 1

[sants]

I am trying to connect to an Oracle d/b (8.1.6) using ODBC through Access 2000. I created a system DSN with the right parameters. The "Microsoft ODBC for Oracle" driver version i am using is 2.573.5303.00 on W-NT SP5. Through access when i try to connect the following error pops up:

ODBC--call failed.
[Microsoft][ODBC driver for Oracle][Oracle](#0)[Microsoft][ODBC Driver Manager] Connection not open (#0)

What could be the reason?

 

[cspeig]

Sir,
you may want to check filename used and or path if
designated. I've run accross that problem before and
for the most part, I found that I had mistyped or left
off some of the path structure. Examine filename and
path.

 

[bookouri]

Do you have the oracle client installed on your machine. Microsoft's ODBC driver REQUIRES the oracle client components (net8 or sqlnet) to be installed and configured on the workstation.

 

[sants]

OK. I got it to work. I used a Machine DSN instead of a System DSN and it worked fine.

Thanks for all your responses.

 

[Guest_imported]

I need the ODBC driver for connect Ms-access with oracle 8i