| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
