ODBC Problem - Very Urgent
Posted on 2004-04-24
Someone please help me with this. Last Wednesdaywas my deadline and I am still fire fighting with this.
I am having a small asp application that is connecting to oracle 9i DB (126.96.36.199.1) through odbc. This asp page is working fine in windows 2000 professional, but giving error in windows 2000 server.
This is my asp code:
set conn= server.createobject("ADODB.Connection")
set rs= server.createobject("ADODB.Recordset")
conn.ConnectionString = "dsn=qmark;uid=user3;password=password"
'Opening the connection
sql="select count(*) from A_QUESTION"
rs.open sql, conn, 1,2
response.write "Total Count : " & rs.recordcount
Here is my error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
/em/sample.asp, line 12
God Bless You, for any assistance.