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.
Brad Pybus <Brad_pybus_nospam_at_hotmail.com> wrote in message
news:nwX23.127$H95.95188_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};
David Received on Wed May 26 1999 - 14:38:06 CDT
![]() |
![]() |