I am trying to connect to an Oracle

[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?

 

[ETID]

Maybe network sercuity is blocking your path? check with your admin.

 

[sants]

I am running this on my machine locally. I am not sure if this is something to do with the ODBC driver.

 

[sants]

Hi,
I managed to resolve the issue by creating a file dsn instead of a system dsn. No idea how this worked.