Re: Connect string using MS Oracle ODBC driver. help.

From: Brad Pybus <Brad_pybus_nospam_at_hotmail.com>
Date: Wed, 26 May 1999 21:15:12 GMT
Message-ID: <AvZ23.163$Co2.125321@client.news.psi.net>

>> The string I am trying to use to connect to my Oracle database using the
>> Microsoft ODBC driver is as follows:
>>
>>
>"ODBC;DSN=MyMSDSN;SERVER=ServiceName.world;DBA=W;UID=UserName;PWD=Password;
"
>>
>You need to identify the tnsnames reference to the instance with the
>connectstring keyword.
>
>UIDUserName;PWD=Password;CONNECTSTRING=<left side of tnsnames
>entry>;DRIVER={Microsoft ODBC for Oracle};

Well, in my example's case then the left side of the TNSNAMES entry would be "ServiceName".

I tried this and it does not work.

Brad Received on Wed May 26 1999 - 16:15:12 CDT