ODBC Setup Problem

[anorita]

I have Win 7 Ultimate 64 bit. I have the following problem..
when I try to install an ODBC connection (*mdb),
Data sources ODBC > SYSTEM DSN > ADD > (here only sql server is listd, not .mdb) and also
I get the following fault message:
"The Microsoft Access Driver (.mdb) ODBC driver could not be found. Please reinstall the driver". i have ms access 2003.
I need this for database connectivity with webpages. i need to solve this issue urgently...

 

[anorita]

please anyone help me ...

 

[WindowsStar]

I think this is what you are looking for:

Download details: Microsoft Access Database Engine 2010 Redistributable

Let me know -WS

 

[anorita]

I download the file AccessDatabaseEngine.exe. The installation was successfull, but the problem is still there. the instructions to use this file are : ;; can u guide me what to do next?

To use this download:
1.If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
2.If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
◦If you are connecting to Microsoft Office Excel data, add “Excel 14.0” to the Extended Properties of the OLEDB connection string.
3.If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
4.If you are application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”

 

[WindowsStar]

Shouldn't you have installed the "AccessDatabaseEngine_X64.exe" version?? I thought you were on 64bit??

Edit: Maybe that is for Office 64bit?? I am Unsure?

 

[anorita]

yes i tried to install "AccessDatabaseEngine_X64.exe" version but error came that cannot install becoz office application is in 32 bit..

 

[WindowsStar]

yes i tried to install "AccessDatabaseEngine_X64.exe" version but error came that cannot install becoz office application is in 32 bit..

I am not sure what to do from here. Let me see if I can get someone that knows more about this than me to help. -WS

 

[Irene]

Maybe some useful information here...
ODBC--Open Database Connectivity Overview

and here...
No ODBC Drivers available for Excel or Access in Windows 7 ?!

Hope this helps.

 

[WindowsStar]

Ok here is something strange. On my Windows 7 Ultimate machine(s) this acts as the OP states. However on my Windows 7 Enterprise machines the options to add Access connectors are there?? I have no idea why this is?

 

[Sdavio]

Problem while connecting MS Access Database with OLEDB

Hi i am facing the same problem as everybody is facing , my sir says dat its because of the OS those who r having Licensed version of windows 7 ultimate they get all the function of ms acces to connect n those who r using the pirated version have nly the SQL function so plz help me out smebody with this stuff plz gimme the link to install the driver for OLEDB ms access windows 7 ultimate 64 bit