Printable View
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