Run Time Error 3151 ODBC Connection (1 Viewer)

purceld2

Registered User.
Local time
Today, 02:39
Joined
Dec 4, 2008
Messages
79
I have sent a colleagee a copy of a Access database application I have which has 4 linked tables to an Oracle database. I told to him to place the TNSNAMES.DSN in the same location I have it on my PC.

When a query is run it invites to to enter the user id and password once entered the following message is displayed

Run time Error 3151 ODBC connection error

Any ideas what the problem could be

Thank you in advance
 

DCrake

Remembered
Local time
Today, 02:39
Joined
Jun 8, 2005
Messages
8,632
I suspect that the file dsn has not been registered in the registry. Get him to create it through admin tools to see if it works then. The other alternative is to use DNSless connections.
 

Users who are viewing this thread

Top Bottom