Solved

ODBC Problem - Very Urgent

Posted on 2004-04-24
7
1,056 Views
Last Modified: 2010-05-18
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.
0
Comment
Question by:venkatraman_r
  • 4
  • 3
7 Comments
 
LVL 49

Expert Comment

by:Ryan Chong
ID: 10908269
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
0
 

Author Comment

by:venkatraman_r
ID: 10908292
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.

0
 
LVL 49

Accepted Solution

by:
Ryan Chong earned 250 total points
ID: 10908362
>>TNS: Listener could not resolve service_name given in connect descriptor
Is your Oracle Service Successfully Running on your Server? Make sure the Listener and Service is Running well..

See below PAQ to see whether you can get some clue why the Service won't run..:
http:Q_20949545.html
http:Q_20921439.html

regards
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:venkatraman_r
ID: 10908390
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.
0
 
LVL 49

Expert Comment

by:Ryan Chong
ID: 10908461
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
0
 

Author Comment

by:venkatraman_r
ID: 10908534
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.
0
 
LVL 49

Expert Comment

by:Ryan Chong
ID: 10908585
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
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
stringclean challenge 26 70
Turning python script into an applet 12 104
simplest php form 3 63
Beginner to Unreal Engine 4 5 61
I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now