we have successfully installed 32-bit SQL 2005 (Std) side by side with 64-bit SQL on Win2008 64-bit.
We installed the 3rd pty ODBC driver using odbcad32.exe
I am new to SQL 2005 and was somewhat expecting to see the driver available in the import/export wizard data source (as per SQL2000) ...it doesnt...you have to use "New Framework Data Provider for ODBC" and then enter the DSN string.
from there, we encountered another issue..."copy tables and views" is greyed out !
This I think is do with the driver itself....here is a link to SQL 2008 BOL that refers to this
anyway...we can now construct a query to extract the data.
We have also created a linked server...and it works!
you can lead a user to data....but you cannot make them think
and remember....every day is a school day