Solved

Driver's SQLAllocHandle on SQL_HANDLE_ENV failed. URGENT !!!

Posted on 2004-10-14
3
12,148 Views
Last Modified: 2010-01-14
I'm trying to connect to oracle using the following syntax.

ConnStr = "driver={Microsoft ODBC for Oracle}; server=test.world; uid=dmsusr; pwd=dmspwd"
Set Conn   = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = ConnStr
Conn.Open

Its working in my dev server. The OS installed in this machine is, Windows XP Pro SP-1 and Oracle 9i Rel 2.

I moved the same code to my test server but its NOT working. Ths OS installed in this machine is Windows XP Pro SP-2 and Oracle 9i Rel 2. Im getting the following error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

I tried lot of different things but nothing worked. I need to resolve this issue imly. Thanks for all your help.
0
Comment
Question by:UU1
3 Comments
 
LVL 20

Accepted Solution

by:
jitganguly earned 125 total points
ID: 12319774
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

816 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

11 Experts available now in Live!

Get 1:1 Help Now