Re: Oracle 9i ODBC Driver for Windows XP 64 (XP 2003)

Hi,

One thing to try is to use the 32-bit ODBC Data Source Adminstrator. The location for this is: c:\WINDOWS\SysWOW64\odbcad32.exe. This should have the Oracle driver listed as this it the 32 version of the Data Source Administrator. You should be able to add your DSN here. If this doesn't work, you may want to check your registry under HKEY_LOCAL_MACHINE\Software\Wow6432Node\ODBC\ODBCINST.INI and make sure the Oracle driver is there.

My problem now is getting Access 2003 to use this rather than the 64 bit one! (I can connect via SQL but not Access! So if you or anybody have any ideas around that-let me know!)

Marci

Josh The Geek wrote:
> I just upgraded to a new 64-bit workstation with Windows XP Pro 64 (AKA
> Windows XP 2003) and after several attempts got the Oracle 9i client
> installed, or so it appears. The Oracle provided ODBC drivers also
> appeared to install. I created a TNS Net Service Name successfully.
> However, when I try to set up an ODBC connection, the Oracle ODBC
> drivers do not appear on the list of available ODBC drivers in the
> Windows control panel. Uninstalling and re-installing has no effect.
>
> Is there an ODBC driver available for the 64-bit edition of Windows XP
> Pro? I need this up and running ASAP, as a deadline looms in the not
> too distant future.
>
> Thanks in advance.
>
> ~ Josh The Geek
> ---
> http://www.thegeeksite.com
Received on Tue Jul 26 2005 - 12:19:43 CDT