Has anyone created a linked server to DB2 on AS/400 from SQL Server 2005 IA64 BIT?
We were hoping to use the new Microsoft OLEDB Provider for DB2...The problem is the driver looks like it will only work on x64 computers."The single setup program will install the provider and tools on both x86 and x64 computers"
We were able to install the driver on the IA64 computer and were able to successfully create a data source from the Data Access Tool. Oddly enough when we attempted to create a linked server in SSMS we received an error, we also noticed that the DB2OLEDB provider is not listed in SSMS.
This is becoming a real problem so any ideas on how we can get this driver to work or suggestions on an alternative would be greatly appreciated.
View Complete Post