Home » Infrastructure » Windows » Windows Server 2003 and Client 9i - IT WORKS !
Windows Server 2003 and Client 9i - IT WORKS ! [message #100841] Tue, 16 December 2003 06:18
Stefano Chiesa
Messages: 1
Registered: December 2003
Junior Member
To anybody who need it.
I tried to create a connection to an Oracle DB on a Windows 2003 server managing the db via ASP pages and keeping the worker process isolation mode on.
I had many errors such "SQLAllocHandle on SQL_HANDLE_ENV failed" or "Driver not loaded due to systen error 5".
I found out this solution:
* MDAC 2.8
* Oracle Client 9.2.0.1.0
* Oracle ODBC Driver 9.2.0.5.4
* In the ASP page must be used the DSN connected to the "Oracle in 'Oracle_installation_directory'" i.g. "Oracle in OraHome92"
The built-in web user IUSR_machine_name must have the "Full control" property over the Oracle Installation Directory (i.g. d:oracleorahome92) and in all subfolders.
This is the ASP code:

Set Conn = Server.CreateObject("ADODB.Connection")
ConnString="DSN=dsn_name;UID=user;PWD=password;"
Conn.Open ConnString
sSQL = " SELECT * from TABLE"
Set RS = Conn.Execute(sSQL)
While Not Rs.Eof
Response.Write Rs("Field1")&" - "& Rs("Field2") & "
"
Rs.MoveNext
WEnd
Conn.Close
Set Conn=Nothing
Set Rs=Nothing

Hope this help.
Stefano.
Previous Topic: TNS Listener
Next Topic: ORA-03127 - error message while selecting LONG RAW datas
Goto Forum:
  


Current Time: Fri Mar 29 06:34:02 CDT 2024