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