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.Connection")
set rs= server.createobject("ADODB.Recordset")

conn.ConnectionString = "dsn=qmark;uid=user3;password=password"

'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.

Ryan Chong

Is your target DSN created on your win2k server? Try test the connection to see whether it's connected to Oracle database.

..
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

venkatraman_r

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.

ASKER CERTIFIED SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

venkatraman_r

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.

Ryan Chong

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

venkatraman_r

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.

Ryan Chong

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