64 bit driver for DSN for MS access database

Anonymous
2010-01-21T16:03:27+00:00

I have windows 7 professional 64 version on my laptop.  I tried locating DSN (data source name) for MS access data. 

It is giving me an option for only SQL server database.

Defining connectivity to MS access database through DSN is very critical to my ASP applications working through IIS (internet information services)  After reviewing the solutions on the web I concluded currently there is no 64 bit driver.

Should I downgrade my windows 7 professional to 32 version

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2010-01-22T17:42:45+00:00

Hi smantha11,

Currently Microsoft does not have any 64 bit ODBC drivers available for the Office products.

However, as long as the application that you want to connect to is 32 bit, you can use the 32 bit ODBC drivers to create the DSN. To get to the 32 bit ODBC drivers, the 32 bit Data Source administrator must be used. The 32 bit Data Source administrator must be launched directly if you are using a 64 bit OS. The file should be located at the following path:

c:\windows\sysWOW64\odbcad32.exe

Hope this helps!

Kathy

Was this answer helpful?

60+ people found this answer helpful.
0 comments
Answer accepted by question author
ScottGem 68,840 Reputation points Volunteer Moderator
2010-01-22T22:50:50+00:00

You can download the drivers here:

http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=e

This file will add Access to the list of file types in the ODBC administrator.

Not sure if its 32 or 64 bit. But it worked on a machine running 64bit Win 7

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Was this answer helpful?

10+ people found this answer helpful.
0 comments

50 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-09-19T18:43:54+00:00

    Kathy,

    Can you help decipher the error message I get when I try running my Application?

    ProjectId - 0

    ProjectName -

    Date - 9/8/2011 2:26:33 PM

    Error -System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

    at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

    at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)

    at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

    at System.Data.Odbc.OdbcConnection.Open()

    at WDDataAccess.DataLayer.GetDBConnection()

    at WDDataAccess.SiteContent.GetAllProjects()

    at WebdiscPublisher.frmSelectProject.frmSelectProject_Load(Object sender, EventArgs e)

    Thanks for any help you can provide.

    Allen

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-09-19T18:25:03+00:00

    I am having difficulty with using an Application that uses MS Access in Win7 64-bit.

    There is no problem when I use the App on a Win XP machine.

    I have installed the Access engine from:

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255.

    However when I look under Drivers I do not see the MS Access Driver. -- I only see the SQL Server driver.

    Is there some specific detail that I am missing?

    Thanks for any suggestions.

    Allen

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-08-15T18:27:26+00:00

    Thank you Kathy, you resolved one problem for me.

    Was this answer helpful?

    0 comments