Specified driver could not be loaded due to system error 5 (Oracle in

[dminich]

I have an asp script set to pull records from a database and display a table to the end user but I receive the following error.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Oracle in OraHome92).
/bbreg/BBCreateCourseList.asp, line 10

My code to connect to an Oracle 9 database looks like this.

set conn = server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Data Source=MCAPPS;User ID=musicman;Password=kompozer"
conn.open

set rs = server.CreateObject("ADODB.Recordset")

rs.Cursorlocation = 3 'adUseClient
rs.CursorType = 3 'adOpenStatic
rs.ActiveConnection = conn

' Open the recordset.
strSQL = "select * from test_courses where instid = '433351';"
rs.Open strSQL

intRecCount = rs.RecordCount

Line 10 is conn.open

I've check the access rights on the Oracle_home directory and EVERYONE and Authenticated users have read and execute (I even restarted the server after setting these rights) and my ODBC subdirectory is under my Oracle_home directory

Any assistance that is offered would be greatly appreciated.

 

[Sheco]

Is that a user DSN?

Or maybe a file DSN in a directory that IUSR_xxxx can't open?

The reason I ask is that I think system error 5 is access denied.

 

[Turkbear]

Hi,
Try a DSN-less connection:

Set objDC = Server.CreateObject("ADODB.Connection")
objDC.ConnectionTimeout = 15
objDC.CommandTimeout = 30

'Code to connect to Oracle Warehouse
objDC.Open "Provider=MSDAORA.1;Password=secret;User ID=username;Data Source=your_tnsnames_entry"

Sometimes these work better....

 

[dminich]

Sheco and Turkbear,

Thank you for your responses. I was using a DSN, I switched the the DSN-less connection code above and receive a different error.

I'll keep working with it, thank you for getting me pointed in the right direction.