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

From: idt news <dovidf_at_net2phone.com>
Date: Wed, 26 May 1999 15:38:06 -0400
Message-ID: <7ihijt$c67@nnrp4.farm.idt.net>

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

This message: [ Message body ]
Next message: Jonathan Gennick: "Re: SID stored in DB???"
Previous message: Peter B. Nelson: "HELP ! P R E F E T C H -- Trick to using prefetch in JDBC with Oracle"
In reply to: Brad Pybus: "Connect string using MS Oracle ODBC driver. help."
Next in thread: Brad Pybus: "Re: Connect string using MS Oracle ODBC driver. help."
Reply: Brad Pybus: "Re: Connect string using MS Oracle ODBC driver. help."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US