ODBC x64 oracle problem

I have a workstation with Windows 2008 x64, MS Access 2007 and Oracle 11g x64 I use Access to connect to Oracle via ODBC. I am the administrator (in the administrator group) on the workstation. I run Access as administrator but when I want to make an ODBC call to Oracle it does not work.

How do I do it: I start MS Access and creates a direct query. In the properties dialog I go to add new and the Select datasource dialog appears. I then use machine datasource and click New, System datasource - but the driver for Oracle is not there.

Regards Robert :-)

From stackoverflow Robert Vabo

• If you want to use the Oracle supplied ODBC driver, you need to install the oracle client. The default client install does not include the driver, so you either need to add it when you do the install or re-run the universal installer to add it later.

  From Leigh Riffel

• To get the Oracle ODBC driver for 10g (don't know about 11):

  • run the client install. You will be given 4 options for installation type: InstantClient, Administrator, Runtime, and Custom.
  • select "InstantClient" (it's not in the Runtime install)
  • You must install this in a new oracle home.

  Once the installation is complete, you should see the Oracle driver in your ODBC control.

  From DCookie

• I can se the Oracle driver in the standard ODBC administration but when I start this from within MSAccess the driver does noe appear. This means that the x64 driver is not present. if I look in the registry the Oracle driver is noe existing under the HKLM\Software\Wow6432Node\ODBC\ODBCINST.INI key like the ones for SQLServer

  From Robert Vabo

• Solved! Create a Virtual PC (Hyper-V) and install the 32 bit version of OS and client - it works!

  From Robert Vabo

• ODBC x86 en vista o cualquier x64 La solucion es la siguiente creen una nueva clave apartir de aca HKLM\Software\Wow6432Node\ODBC con el nombre de ODBC.INI y dentro de esta clave creen como se llama su odbcconexion por ejemplo myodbc y luego crean los key como son
  database = mydatabe driver = C:\Program Files (x86)\MySQL\Connector ODBC 5.1\myodbc5.dll (si manejas la 3.51 colocas esa yo manejo la 5.1) UID = root u otro usuario PWD = al password SERVER = direccion ip o localhost

  Y listo asi le queda la solcuion para el guevito de x86 en vista x64

  espero que les sirva de mucho

  att Papitrillos

  From $pageUsers[$post.author].name