Oracle connection string

31 Oct 2006 5:17 PM

adodotnet20

Hi,

I'm trying to connect to Oracle. I'm using the Microsoft OLE DB
provider with this connection string:
"Provider=msdaora;Data Source=MyOracleDB;User
Id=myUsername;Password=myPassword;"

How do I specify a server name and a port (I don't have Oracle on my
localhost)?

Thank-you.

31 Oct 2006 9:19 PM

Turkbear

On 31 Oct 2006 09:17:31 -0800, adodotne***@gmail.com wrote:

>Hi,
>
>I'm trying to connect to Oracle. I'm using the Microsoft OLE DB
>provider with this connection string:
> "Provider=msdaora;Data Source=MyOracleDB;User
>Id=myUsername;Password=myPassword;"
>
>How do I specify a server name and a port (I don't have Oracle on my
>localhost)?
>
>Thank-you.

If there is no Oracle client on the web server, no connection will work..
Here is a 'sortof' standard string to use:

"Provider=MSDAORA;Data Source=whsd;Persist Security Info=True;User ID=<someusername>;Password=<passwordforthatuser>;" />

The Data Source needs to specify some entry in your tnsnames.ora file..