>64-bit applications cannot see or use 32-bit OLEDB/ODBC drivers. Period.
>
>
>
>>Does the same limitation exist in using odbc/oledb for Excel or Access data on 64-bit operating systems?
>>
>>>Not all MS products are going 64 bit. Office 2007 will still be 32-bit.
>>>
Doug's problem was the use of 32 bit ODBC drivers on x64 servers, right? He found out that 32-bit ODBC drivers do not appear in the ODBC Data Source Administrator. He can use %SYSTEMROOT%\SysWOW64\odbcad32.exe instead of the default program in system32.
This will show all installed 32-bit ODBC drivers. At this point he can use his DSN as he would with any other system.
José