We're stuck with the perennial problem of linking a 64-bit SQL Server to a 32-bit Pervasive SQL Application on another server. We know all about the 64-bit application and 32-bit driver/UDN/DNS problems. We can connect perfectly to the Sage-Peachtree Pervasive databases in question, but due to the architecture mis-match on bits, we cannot get our applications to match up so we can map the columns in the tables using OLE DB.
If I can get my 2005 64-Bit SQL Server to link up to the database in "Linked Servers", I should beat the problem and my application will connect with 'OLE DB for ODBC Drivers'. But, we're hit with the persistent problem, with the 32-bit database/DSN architecture, we can't get the link to connect appropriately in MS SQL 2005 64-bit.
If anyone has a cure, we have rewards to trade, first-born children etc...!! 😉
Terry