Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect string using MS Oracle ODBC driver. help.
>> 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