Sunday, April 01, 2007

Cannot open SQL server

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.

2 comments:

Alan said...
This comment has been removed by a blog administrator.
Anonymous said...

Pretty component of content. I simply stumbled upon your web site and in accession
capital to assert that I acquire actually enjoyed account your blog posts.
Any way I'll be subscribing on your feeds or even I fulfillment you get entry to consistently fast.

My web site :: best diet