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
anorita

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
anorita

windows 7 ultimate 64bit
 
 

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

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
anorita

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
WindowsStar

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
anorita

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
WindowsStar

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
Irene

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
WindowsStar

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
Sdavio

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
Thread Forum
Uninstalling VB6.0 and ODBC-32bit.
Hello! Some time ago I installed VisualBasic 6.0 to work on a school project and after finishing It I decided to uninstall VB6.0, but I still have ODBC 32bit in Control Panel and it's not on the "Add/Remove" program list. I also uninstalled the ODBC data registry keys but to no avail. Any tips?...
Software
ODBC Configuration
Background: We run this program at work called "Surgisource", it is a medical billing program of sorts. Most of our computers here run Windows XP 32bit and the software runs without fail. We have aproximately 10 Windows 7 machines of which only a few are running Surgisource. Of these few only 2 are...
General Discussion
ODBC connection problem
I'm running 2005 SQL server on Windows 2008 server. I have both Windows 7 and XP ODBC connections to the server. Everything was working fine but the server was running slow so I tried a windows update. The update made my ODBC connection go flakey, but only on Windows 7. Testing the connection would...
Network & Sharing
odbc
could the odbc be used to tell windows how to surf the internet safely? to look for scripts in media/images/controls that could be malicious or cause unwanted or unintended behavior of hardware?
Software
ODBC Setup Problem
I am sorry if this has been asked previously. I have Win 7 Ultimate 64 bit, which is an upgrade from Vista Business 64 bit. I have the following problem when trying to install an ODBC connection (*mdb). When I run odbcad32.exe, from the SysWOW64 directory, and try to install the 32 bit MS Access...
Network & Sharing
problem about postgresql ODBC driver installation on W7
Hi, all I installed postgresql odbc ver 8.3.5 on my windows 7 home premium. Installation looks successful. But on ODBC data source administrator, I can't see the installed odbc driver. Don't know why. And I found it's installed in program files(86) folder.
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 02:31.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App