Oracle connection string

  • Thread starter Thread starter adodotnet20
  • Start date Start date
A

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.
 
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.
Click to expand...

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