ODBC x64 oracle problem

Question

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 :-)

Answer 1

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.

Answer 2

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.

Answer 3

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

Answer 4

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

Answer 5

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