R: Oracle error message using ODBC

The problem was caused because the net8 driver was not loaded into memory or there was a mismatch of the version of the driver. A user program linked with an obsolete library may also cause this message. Relink the program with current versions of the Oracle libraries. This is the resolution by the Oracle8 Error message.

P.Selvi

Mark Harris <mark.harris_at_ukonline.co.uk> wrote in message KAmn6.85918$Dd3.1418771_at_monolith.news.easynet.net...
> Hello,
>
> I'm using the Oracle ODBC drivers in some scripting (Win NT 4, Oracle
> 8.1.6), with the following connection string:
>
> set conn = CreateObject("ADODB.Connection")
> conn.ConnectionString = "DSN=uniform;UID=<username>;pwd=<password>;"
> conn.Open
>
> When I try & run the script, I get the following error message:
>
> "[Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve
> text for error ORA-03121"
>
> Also when trying to set up a new ODBC connection, I get a message saying
> "The setup routines for the Oracle ODBC driver could not be loaded due to
> system error code 182"
>
> Can anyone suggest what the problem is?
>
> Thanks in advance,
>
> Mark
>
>
Received on Fri Mar 02 2001 - 09:53:47 CET