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

    ODBC Driver for Windows 7 - 64 bit

    5e7bf382-f654-48fa-bdcf-b60faab59d04

       

      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

      Next

       

      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.