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

From: idt news <dovidf_at_net2phone.com>
Date: Wed, 26 May 1999 19:22:32 -0400
Message-ID: <7ihvop$etk@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.

> Brad
>
>
>
Received on Wed May 26 1999 - 18:22:32 CDT