Problems printing non-datapiped reports in Accpac Advantage Series 5.2
The following error is returned:
Description: Cannot open SQL server
All databases in 5.2 use DSNs. The problem occurs when multiple database types are used and the same database IDs' exist.
Example. A Saminc and a Samsys DSN already exist on a machine from a DB2 install. When the client accesses a Saminc database for Pervasive, a Saminc and a Samsys DSN will be created for Pervasive on the same machine. This creates duplicate DSNs on that machine and the above error will occur.
Remove the duplicate DSNs from Datasource (ODBC) setup. If the database does exist with the same name for both types of databases, ie. Pervasive and DB2, then use DBDump and DBLoad for one of them to a different database ID.