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

.



Relevant Pages

  • Re: Microfocus Netexpress question : COBSQL vs openESQL
    ... >couldnt connect with the oracle database specified in the program. ... It may be missing an ODBC driver and/or data source. ... You also need an entry for the data source in tnsnames.ora. ... precompiler directives to the precompiler and compiler directives to ...
    (comp.lang.cobol)
  • Microsoft ODBC for Oracle Driver problem
    ... I think I have a resource issue with this driver. ... we are having an issue where suddenly the ODBC ... customer on that hosted machine. ... Microsoft ODBC Driver for Oracle. ...
    (microsoft.public.data.odbc)
  • dbi:oracle win2k ORA-1222 problems
    ... The database is Oracle 7 running on a totally different machine. ... I found a bit of code that would check all available DBI drivers and their data sources. ... Driver: Oracle ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)
  • RE: oracle win2k ORA-1222 problems
    ... I am having a real problem with that! ... The database is Oracle 7 running on a totally different machine. ... Driver: Oracle ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)
  • Re: odbcdriver for Mysql
    ... ODBC dirver is not a Data Source. ... Can you see MySQL driver on the "Drivers" tab in the ODBC Data Source ...
    (microsoft.public.data.odbc)