Results 1 to 3 of 3

Thread: SQL_HANDLE_ENV

  1. #1
    Guest

    Post

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

  2. #2
    Lively Member
    Join Date
    Jan 2000
    Location
    Springfield, IL
    Posts
    124

    Post

    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.

  3. #3
    Guest

    Post

    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
  •  



Click Here to Expand Forum to Full Width