Whenever we run an A/P Aged Payables Report we get a "Connect failed because you attempted a DSN less connection". Everything was working until we lost Pervasive a few weeks back. We reinstalled it and now the DSN errors have been popping up. We are on AccPac v 5.3A using Pervasive Sql 8. Can anyone point me in the direction of what is missing and how to go about repairing it?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC Engine Interface in AccPac
- Thread starter sardont
- Start date
jayconverse
MIS
Is Accpac installed on the server where the data resides? If not, do it.
Then, on that server, delete any ODBC DSNs that relate to Accpac. Run Database Setup, select each database in turn, and point the folders to a UNC version. Database setup will create the proper DSN's.
Then on the workstations, delete any Accpac Pervasive ODBC DSN's that you find, and simply login.
Finally, on all the workstations, disable local caching in Pervasive, Accpac doesn't like it.
Jay Converse
IT Director
Systemlink, Inc.
Then, on that server, delete any ODBC DSNs that relate to Accpac. Run Database Setup, select each database in turn, and point the folders to a UNC version. Database setup will create the proper DSN's.
Then on the workstations, delete any Accpac Pervasive ODBC DSN's that you find, and simply login.
Finally, on all the workstations, disable local caching in Pervasive, Accpac doesn't like it.
Jay Converse
IT Director
Systemlink, Inc.
- Status
Similar threads
- Locked
- Question
- Locked
- Question