Download ODBC Driver for SQL Server. Download the Microsoft ODBC Driver 13.1 for SQL Server on. (64-bit) - Download Microsoft ODBC Driver 11 for SQL. Oracle ODBC driver (32/64 bit) free download for Windows 7 - Connectivity solution for ODBC-based applications to access Oracle databases.
I want to add 32-bit data sources. There seems to be no obvious way to see existing instances of these or create new ones.
How can I open the 32-bit 'ODBC Data Source Administrator' window in Windows 7 64-bit?
Just a small note to Zorodache answer, if you use the search box from the start menu type the whole path to get the correct version c:WindowsSysWOW64odbcad32.exe.
Otherwise, you will get the 64-bit version, even if you enter odbcad32.exe in the search box.
A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):
The 32-bit version of the Odbcad32.exe file is located in the%systemdrive%WindowsSysWoW64 folder.
The 64-bit version of theOdbcad32.exe file is located in the %systemdrive%WindowsSystem32folder.
The Odbcad32.exe file displays the following types of data source names (DSNs):
System DSNs
User DSNs
BulentBulent
protected by Community♦Sep 2 '17 at 19:36
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count). Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged windows-764-bit32-bitodbc or ask your own question.
Active2 years, 9 months ago
I have an existing PHP script that needs to work with data from an Access db, and the machine it's on is migrating from Win2K to Windows 7. I looked around, and Microsoft seems to say that this is still available somewhere, but I can't find any solid information about how to actually get it.
It is not an option to migrate this to another db at the moment because of other dependencies.
Did you actually Google 'get jet odbc driver for windows 7'? I did and I found a number of possibilities, though only one of them looks like it will work.
First off, keep in mind that Jet itself has shipped as part of the OS starting with Windows 2000, so all you need are the ODBC drivers themselves.
The third Google link, Information about Jet 4.0 Service Pack 8, allows you to get the Jet ODBC DLLs (you'd need to get the version for NT4). I worried that this installer might check the OS and prevent you from installing the files, but it just runs transparently on WinXP (I'd assume the same on Vista/7, but maybe not). Since the Jet files are protected OS files, there's no danger installing an older version (a computer that's been kept up-to-date with Windows Update will already have something higher than Jet SP8, but the ODBC drivers are apparently not shipped with the OS in Win7, so this should work). If you can't get them, I can install it on my old Win95 box and send you the ODBC-specific files.
You may also have to install MDAC 2.8 to make them work (though you could register them manually, there are still non-Jet ODBC files that are needed that may or may not be installed on Windows 7). So far as I can tell the MDAC 2.8 download will be required.
One last caveat, if it's 64-bit Windows 7, you may be out of luck if you're using the Jet ODBC driver from contexts that cannot use 32-bit components. There is no 64-bit Jet yet (that's coming with Office 2010, and is in beta). A recent SO discussion has the link to the beta of the 64-bit Jet drivers. I don't know if that includes 64-bit ODBC support or not, though I'd tend to think it doesn't.
Loaded and installed 2007 Office System Driver: Data Connectivity Components from here.C: UsersHomerDownloadsODBCDownload 2007 Office System Driver Data Connectivity Components - Microsoft Download Center - Download Details_aspx.mht
To use Windows 7 32-bit subsystem. You need to use the ODBC control panel here. c:windowssysWOW64odbcad32.exe I used DSNLess so I did not need this. But it does work. The one in the system32 folder gives an errors if you try to use it.
My DSNLess Connection stringDSN = 'Provider=Microsoft.ACE.OLEDB.12.0;DataSource=c: inetpubwwwrootDatabasegdbhelp.mdb'
Gave the IIS_Iuser account READ and WRITE rights to edit and add on the gdbhelp.mdb database.