Connection String from ASP to Oracle 9i.

[Dynapen]

I am having some problems figuring out how to write the connection string to tell my ASP pages to connect to the Oracle9i database that I built and want to convert to.

Here's a example of the current string I am using to connect to SQL Server 2k. But I don't know how to convert this to a Oracle string.

Help please.

myConnString = "Provider=SQLOLEDB.1;Password=;User ID=sa;Initial Catalog=Transactions;Data Source=HOCHIMIN"

 

[Turkbear]

Its very similar :

myConnString = "Provider=MSDAORA;Password=yourpasswordhere;User ID=yourusername;Data Source=yourtnsnamesentry;Persist Security Info=TRUE"

( This assumes that the Oracle Client is installed on the web server )
hth

 

[Dynapen]

That worked perfectly. Thanks. I figured it was close, but couldn't figure out where to get the provider name from?