2 Replies Latest reply on Mar 11, 2014 8:39 PM by 5e7bf382-f654-48fa-bdcf-b60faab59d04

    ODBC Driver for Windows 7 - 64 bit



      Hi All,


      I am having problems with using the Microsoft ODBC for Oracle Driver in Windows 7 - 64bit system. I am using the following code in my VB script


      Set myConnection = CreateObject("ADODB.Connection")

      myConnection.Open "Driver={Microsoft ODBC for Oracle};" & "Server=xxxxxx;" & "Uid=xxxxx;" & "Pwd=xxxxx"

      Set myRecord = CreateObject("ADODB.recordset")

      Sql = "Select * from employees where id= '01234'"

      myRecord.Open Sql, myConnection

      For Each r In myRecord.Fields

      MsgBox r.Name



      I get the following error message: "The Oracle (tm) client and networking components are not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation, You will be unable to use this driver until these components have been installed"


      "[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"


      Can you help me out on which version of Oracle client i need to install and what other settings I need to do on my Windows 7 system after the client installation.