| Connection between ASP program to Oracle 9i [message #76731] |
Tue, 03 June 2003 08:33  |
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  |
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 |
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)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
