Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Connection between ASP program to Oracle 9i
Connection between ASP program to Oracle 9i [message #76731] Tue, 03 June 2003 08:33 Go to next message
blanc xavier
Messages: 2
Registered: June 2003
Junior Member
Connection between ASP program to Oracle 9i

Environnement : Windows 2K server
DataBase : Oracle 9i

I need to build connection between ASP program to Oracle9i

I build the DSN in ODBC datasource. The test connection
of the DSN in ODBC was successful

Then I test the following code:
<%
Set myconn = Server.CreateObject("ADODB.Connection")
myconn.open "DSN=XXXX","UID=XXXX","PWD=XXXXX"
%>

Error message displayed :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Oracle in
Ora92).

I configure IIS : The user the IIS runs as has full controls permission to the oracle_home directory
The internet user accound IUSR_<sernver_name> and IWAM_<server_name> for this site has full permission for ORACLE_HOME directory.

Error message displayed :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[[Oracle]][[ODBC]][[Ora]]ORA-12638: Extraction des préférences utilisateur impossible

If i translate the oracle message in english it's done "users preferences extraction is unable"

Please give me instructions about how to set up ASP-Oracle database
connection correctly.

Thanks
xavier.blanc@criltechnology.com
Re: Connection between ASP program to Oracle 9i [message #76766 is a reply to message #76731] Wed, 23 July 2003 06:48 Go to previous messageGo to next message
Pandian.N
Messages: 2
Registered: July 2003
Junior Member
Hi

I having a same problem like

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Oracle ODBC Driver).

from ASP
I have upgraded from Oracle 8.1.6 to Oracle 8.1.7
I am facing this problem.

Please let me know, If anyone faced this problem
Thanks in Advance
Re: Connection between ASP program to Oracle 9i [message #76873 is a reply to message #76766] Tue, 03 February 2004 10:30 Go to previous message
Chris Melo
Messages: 1
Registered: February 2004
Junior Member
Comment line 6 of %oracle_home%networkadminsqlnet.ora

# SQLNET.ORA Network Configuration File: C:oracleora92networkadminsqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = Infoterra.com

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Previous Topic: HTTP Header manipulation?
Next Topic: find Oracle9i AS guide
Goto Forum:
  


Current Time: Thu Mar 28 13:33:03 CDT 2024