Re: Is anyone able to connect 64 bit to Access 2003 database using ODB

Tech-Archive recommends: Fix windows errors by optimizing your registry



DavidO wrote:

When I open ODBC to connect MS Access 2003 on my server using OS 2003 R2 X64
MS Access appears on the list but cannot find the Access driver in the 32
bit folder
Only drivers in the 64 bity folder appear - how do I direct ODBC to find the
32 bit folder.

Note: I am open to any other way to connect my database to the web.

32-bit applications get to use 32-bit ODBC drivers.
64-bit applications get to use 64-bit ODBC drivers.

There's a matching ODBC Administrator for each, which can only see the relevant drivers too. "Data Sources (ODBC)" from Administrative Tools on an x64 client runs the 64-bit Administrator - the 32-bit one is in the sysWOW64 folder.

AFAIK, there are currently no 64-bit Access drivers, so it'd need to be a 32-bit application.

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.
.



Relevant Pages

  • Re: InstantClient for x64
    ... drivers are not showing up under the 64-bit ODBC administrator. ... 32-bit installation to my new folder; and I've added the folder to the path ... I've run the ODBC install batch file. ...
    (comp.databases.oracle.server)
  • Re: InstantClient for x64
    ... drivers are not showing up under the 64-bit ODBC administrator. ... 32-bit installation to my new folder; and I've added the folder to the path ...
    (comp.databases.oracle.server)
  • Re: PC Gaming vs Aging eyes & reflexes
    ... C:\Windows has a Dell folder and in there are drivers. ... first thing you install before any other drivers. ... Stupid Dell. ...
    (comp.sys.ibm.pc.games.rpg)
  • Re: OSD and format for ExtraNICs folder
    ... I have included a listing of the contents of the ExtraNICs ... > drivers that both include the same file). ... If the failure occurs before the ... >> 1) I am having trouble with the Extranics folder. ...
    (microsoft.public.sms.tools)
  • Re: Toshiba S100 Problem With RAID Driver
    ... Add RAID drivers and Service Pack 2 to your original Windows CD! ... Windows XP setup CD ... Our next objective is to extract Service Pack 2 to a folder so we can ...
    (comp.sys.laptops)