Oracle connection string

[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.

 

[Turkbear]

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..