What connection string do I use for Classic ASP and Oracle 10g?

asp-classic oracle10g dsn
johnny picture johnny · Apr 25, 2011 · Viewed 10.8k times · Source

I have Oracle 10g and have installed ODBC via the instant client. I am able to use the ODBC administrator and set up a DSN and test successfully, and whenever I use Microsoft Access I can connect to my database no problem. I can also use Visual Web Developer to traverse the data.

But, when I try and use Classic ASP with:

myConn.Open "DSN=oracle10g;" & _ "Uid=myOracleUsername;" & "Pwd=myOraclePassword"

I get:

-2147467259Specified driver could not be loaded due to system error 5 (Oracle in instantclient10_2). An error occurred while trying to create Server Object.

I have searched various places but nothing seems to work. All ORACLE_HOME, TNSnames, IUSR_X security, all is correct. I am thinking it is a DSN connection string problem.

Anyone know?

Answer

Shadow The Vaccinated Wizard picture Shadow The Vaccinated Wizard · Apr 26, 2011

Try using the following DSN-less connection string:

myConn.Open "Provider=MSDAORA;Data Source=instance_name;User ID=myOracleUsername;Password=myOraclePassword"

I've used this exact connection string for older version of Oracle client, but can't see any reason why it won't work for your version as well.

Related questions

Detailed 500 error message, ASP + IIS 7.5

IIS 7.5 , 2008rc2, classic asp, 500 error msg: The page cannot be displayed because an internal server error has occurred. I need to know how to configure IIS to get a more detailed error. I've tried setting to true all of debugging …

Read More
Update div with jQuery ajax response html

I am trying to update a div with the content from an ajax html response. I beleive I have the syntax correct, however the div content gets replaced with the entire HTML page response, instead of just the div selected …

Read More
File URL "Not allowed to load local resource" in the Internet Browser

I've got a major brainteaser. I want to open a file in classic ASP. I'm using various variables because things can change but the outcome is correct. I know this because I've tested the outcome by copying the linkadress and …

Read More