ODBC Drivers Missing on Windows Sever 2003 64 bit OS

Question

I am working on a Windows Server 2003 x64 bit OS. Under ODBC connections, I am seeing only "SQL Server" and "SQL native Client". I wanted to make a datasource for xls.

I have already performed the following things and there is no solution:

Gone through the reply specified in JET and ODBC driver missing, can not get data from MDBs but there is no solution for me. I think the link solves the problem for a 32 bit OS.
Installed MDAC 2.8

Any help on this would be greatly appreciated.

There is no 64 bit JET ODBC driver. http://support.microsoft.com/kb/957570 — ta.speot.is, Feb 17 '10 at 21:53

score 1 · Answer 1 · answered Feb 18 '10 at 06:03

Thanks for the reply. Just to keep you updated, I already have Excel installed on my system. Even after that I was not able to create Excel ODBC driver from Administrative Tasks menu in Control Panel.

I just found a way to create the same and though of updating the forum. I have gone thorugh 64 Bit ODBC. It says that, we will need to use the following command to achieve the ODBC connection for Excel files : %windir%\syswow64\odbcad32.exe.

score 0 · Answer 2 · answered Feb 17 '10 at 14:36

0

You might check out the 2007 Office System Driver: Data Connectivity Components pack. It includes ODBC drivers for Access and Excel.

Or you might look at http://office.microsoft.com/en-us/excel/HP052009501033.aspx It explains that the excel 2003 drivers are installed when you install excel.

And, finally, check out this post about using the Excel ODBC driver in 64 bit windows.

answered Feb 17 '10 at 14:36

NotMe

3,772
7
31
43

As a last ditch step, just install Excel on the server. – NotMe Feb 17 '10 at 14:40

ODBC Drivers Missing on Windows Sever 2003 64 bit OS

2 Answers2