We are moving our databases (Sybase 12.5.03 & SQL Server 2000 EE 32bit) as part of this we'll be upgrading SQL Server to 2005 EE, to a new host, running Windows Server 2003 R2 Enterprise 64bit.
The problem is on the new host I can't get the linked server to work because the Provider (Sybase.ASEOLEDBProvider) is not being registered with SQL Server. I have run the Sybase OLE Configuration Manager version 2.7 and it appears to work. I have rebooted to see if that helps but it doesn't want to work ?
The is a copy of the error message attached,