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

From: Brad Pybus <Brad_pybus_nospam_at_hotmail.com>
Date: Thu, 27 May 1999 14:46:54 GMT
Message-ID: <yVc33.18$lJ2.26161@client.news.psi.net>

>idt news wrote in message <7ihvop$etk_at_nnrp4.farm.idt.net>...
>
>Brad Pybus <Brad_pybus_nospam_at_hotmail.com> wrote in message
>news:AvZ23.163$Co2.125321_at_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.
>>
>
>You are missing the keyword CONNECTSTRING.

Oh sorry... That is what I meant... I tried adding CONNECTSTRING=ServiceName. Does not work.

Brad Received on Thu May 27 1999 - 09:46:54 CDT