I get the following error when trying to print in Adagio. I tried rebooting, then re-installing Adagio and still get the same error. Any ideas what to do?

Logon failed.
Details: [Database vendor code 160]
Error in file .......
Unable to connect: incorrect log on parameters
Details: [Database vendor code 160]

Adagio module? Version? Report?

It's happening with all modules and all reports.
I'm using AP 9.2B, GL 9.2 B, etc.

Hi John,

The 'error 160' indicates that the Crystal Runtime is not able to make an ODBC connection. Adagio programs at version 9.2A or later use these components for reporting, rather than a different report table process in Adagio versions older than 9.2A.

One specific report - the User Preferences listing - does not use an ODBC connection, so if you can preview/print this report with no error, that means the Crystal Runtime install is OK, and the issue is with the ODBC part.

Some versions of Windows do not pre-install ODBC files MSVCR110.DLL and MSVCP110.DLL in the C:\Windows\SYSWOW64 directory. Recent versions of Adagio will install these, just in case Windows doesn't have them, and also save a copy to the \Softrak\System\Win32 and \sys64 directories in case you need to copy them in manually - say if the install user didn't have the correct rights.

In the \Softrak\System directory is also a utility OCSTEST.EXE to test the ODBC Connection String, with a help document ConnectionTesterInfo.PDF to describe how this works.

Sorry but I haven't been able to solve the problem yet.

The User Preferences listing runs OK
so that means the Crystal Runtime install is OK, and the issue is with the ODBC part.

I checked that the ODBC files MSVCR110.DLL and MSVCP110.DLL are in the C:\Windows\SYSWOW64 directory.

I ran OCSTEST.EXE to test the ODBC Connection String, using a sample string as described in the help document. I get the message: Unable to create connection!

FYI, here is the actual connection string that I tested it with:

DRIVER=AdagioDataSourceDriver;
DBQ=C:\SOFTRAK\Receivables\SAMDATA SAM;
DESCRIPTION=Adagio ODBC v2 Driver;
DBDIRECTORY=C:\SOFTRAK\Receivables\SAMDATA;
COLUMNS=COMMON;
DBFILTER=AR9*;
DBSELELECTOR=SAM;
NAMES=LONG;
TABLESALL=FALSE;
USERID=SYS;
PASSWORD=SYS;
RAWPASSWORD=1;

John

Workstation and server o/s?

I'm running it on my laptop only, using the NFR versions of Adagio. OS is Windows 7 Professional Service Pack 1

I would reinstall Crystal manually. Current version is 13.0.16.1954. Is that the one you have installed?
The installer is System\CR_InstallCommon

I found the msi file in the folder you mentioned. Tried to reinstall but it said it could not find something. The only option was to quit.

Do you have the User Account Control disabled (bar at the bottom)? Disable it, restart the computer and try again.