Oracle connection string


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

Advertisements

T

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top