ODBC Drivers Missing on Windows Sever 2003 64 bit OS

64-bitodbcwindows-server-2003

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:

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

  2. Installed MDAC 2.8

Any help on this would be greatly appreciated.

Best Answer

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.

Related Topic