![Avatar of venkatraman_r](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
venkatraman_r
asked on
ODBC Problem - Very Urgent
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 (9.2.1.0.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:
<%
dim conn
dim rs
dim sql
set conn= server.createobject("ADODB .Connectio n")
set rs= server.createobject("ADODB .Recordset ")
conn.ConnectionString = "dsn=qmark;uid=user3;passw ord=passwo rd"
'Opening the connection
conn.Open ConnectionString
sql="select count(*) from A_QUESTION"
rs.open sql, conn, 1,2
response.write "Total Count : " & rs.recordcount
%>
Here is my error:
Error Type:
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.
Regards,
Venkat.
I am having a small asp application that is connecting to oracle 9i DB (9.2.1.0.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:
<%
dim conn
dim rs
dim sql
set conn= server.createobject("ADODB
set rs= server.createobject("ADODB
conn.ConnectionString = "dsn=qmark;uid=user3;passw
'Opening the connection
conn.Open ConnectionString
sql="select count(*) from A_QUESTION"
rs.open sql, conn, 1,2
response.write "Total Count : " & rs.recordcount
%>
Here is my error:
Error Type:
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.
Regards,
Venkat.
![Avatar of venkatraman_r](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
ASKER
Hi,
I tried..it says "Connection failed"
I included the IUSR_MyMachineName in the administrator group and now i get this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver for Oracle][oracle]ORA-12514:
TNS: Listener could not resolve service_name given in connect descriptor
Any guess!
Thanks,
Venkat.
I tried..it says "Connection failed"
I included the IUSR_MyMachineName in the administrator group and now i get this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver for Oracle][oracle]ORA-12514:
TNS: Listener could not resolve service_name given in connect descriptor
Any guess!
Thanks,
Venkat.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
![Avatar of venkatraman_r](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
ASKER
Oracle DB and listener is running.
The oracleora92agent service is not running and i am unable to restart it.
Still, I feel it is the listener problem.
The link was not much relevant to my problem i guess.
Thanks,
Venkat.
The oracleora92agent service is not running and i am unable to restart it.
Still, I feel it is the listener problem.
The link was not much relevant to my problem i guess.
Thanks,
Venkat.
![Avatar of Ryan Chong](https://filedb.experts-exchange.com/files/public/2021/2/28/d39a9608-d1c4-436f-9ad6-5b7ce32e1884.png)
So, you need to find DBA the exact problem, try deliver it ASAP.
Sorry, i only experienced in Oracle 8.1.6 (and i think there is a lot difference between Oracle 8i and 9i ?), i might can't help you on this here.
regards
Sorry, i only experienced in Oracle 8.1.6 (and i think there is a lot difference between Oracle 8i and 9i ?), i might can't help you on this here.
regards
![Avatar of venkatraman_r](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
ASKER
Man
I tell you what. The IMUsr_CompName was the issue.
There was a mistake in the TNSName entry. I solved it and now i am in all smiles.
IT WORKED :-))))
Regards,
Venkat.
I tell you what. The IMUsr_CompName was the issue.
There was a mistake in the TNSName entry. I solved it and now i am in all smiles.
IT WORKED :-))))
Regards,
Venkat.
![Avatar of Ryan Chong](https://filedb.experts-exchange.com/files/public/2021/2/28/d39a9608-d1c4-436f-9ad6-5b7ce32e1884.png)
Glad you resolved the problem, did i lead you to solve your problem? If yes please award and close this question, otherwise post a Request at Community Support for refund.
cheers
cheers
..
if conn.state = 0 then
response.write "Conn Failed (closed)!"
else
response.write "Conn success (opened)!"
end if
response.end
..
ConnectionString Resources:
http://www.able-consulting.com/ADO_Conn.htm
http://www.connectionstrings.com