|
-
Feb 7th, 2000, 01:19 AM
#1
Hi all,
I have used ADO method to get connected to Oracle database. On one of the machines I have installed my program, I am getting a error saying, 'SQL Alloc Handle on SQL_HANDLE_ENV failed'. I just know that I am getting this error while getting connected to database(probably with some ODBC drivers).
Anyone has any ideas, what is the exact problem and why am I getting this error? Any help is appriciated.
Thanks..
-
Feb 7th, 2000, 02:29 AM
#2
Lively Member
Are you sure the ODBC drivers are loaded on the machine you are getting the error on? You might need to install MDAC on the machine to install the drivers.
-
Feb 7th, 2000, 03:05 AM
#3
I did run the mdac_typ.exe(manually also), but still it doesn't work.
I have done the 'Oracle ODBC test', that Oracle provides, using a DSN I got connected and could query the data. So I know that the ODBC drivers from Oracle side are fine, but I think there is problem with ODBC drivers that VB provides.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|