ASP ODBC driver error '800a0e7a'
I have
-successfully installed Oracle 9i Enterprise on W2K,
-tnsping succesful,
-ODBC System DSN Test-Connection successful,
Problem:
When trying to connect from an asp-script using the syntaxt
Set conn = Server.CreateObject("ADODB.Connection")
conn.Provider = "OraOLEDB.Oracle"
conn.Open "INSTANCE", "USER", "PASSWORD"
it resolves in the error message
*********
Kompilierungsfehler in Microsoft VBScript- Fehler '800a03ea'
Syntaxfehler
/iisHelp/common/500-100.asp, line 129
elseIf (objASPError.Description > "") Then
^
ADODB.Connection- Fehler '800a0e7a'
Der Provider kann nicht gefunden werden. Mvglicherweise ist er nicht richtig installiert worden.
/path/dbzugriff.asp, line 5
*********
(means: can't find provider. maybe its not installed correctly)
There was the idea that its related to the 'IUSR_COMPUTER'-User under which IIS runs. I already tried to add permissions for this user to the concerned DLL's like OraOLEDB.DLL, but it didn't work.
Anyone an idea how it could be solved?
Thanks very much.