Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: ODBC Setup Problem


13 Dec 2010   #1

windows 7 ultimate 64bit
 
 
ODBC Setup Problem

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...


My System SpecsSystem Spec
.

13 Dec 2010   #2

windows 7 ultimate 64bit
 
 

please anyone help me ...
My System SpecsSystem Spec
13 Dec 2010   #3

Windows 7 Enterprise (x64); Windows Server 2008 R2 (x64)
 
 

I think this is what you are looking for:

Download details: Microsoft Access Database Engine 2010 Redistributable

Let me know -WS
My System SpecsSystem Spec
.


13 Dec 2010   #4

windows 7 ultimate 64bit
 
 

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”
My System SpecsSystem Spec
13 Dec 2010   #5

Windows 7 Enterprise (x64); Windows Server 2008 R2 (x64)
 
 

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?
My System SpecsSystem Spec
15 Dec 2010   #6

windows 7 ultimate 64bit
 
 

yes i tried to install "AccessDatabaseEngine_X64.exe" version but error came that cannot install becoz office application is in 32 bit..
My System SpecsSystem Spec
15 Dec 2010   #7

Windows 7 Enterprise (x64); Windows Server 2008 R2 (x64)
 
 

Quote   Quote: Originally Posted by anorita View Post
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
My System SpecsSystem Spec
16 Dec 2010   #8

Windows 7 Home Premium 64bit
 
 

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.
My System SpecsSystem Spec
16 Dec 2010   #9

Windows 7 Enterprise (x64); Windows Server 2008 R2 (x64)
 
 

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?


Attached Images
 
My System SpecsSystem Spec
06 Sep 2012   #10

Windows 7 Ultimate 64 bit
 
 
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
My System SpecsSystem Spec
Reply

 ODBC Setup Problem




Thread Tools



Similar help and support threads for2: ODBC Setup Problem
Thread Forum
ODBC Configuration General Discussion
ODBC connection problem Network & Sharing
odbc Software
ODBC Setup Problem Network & Sharing
problem about postgresql ODBC driver installation on W7 Drivers

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 04:34 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33