Hi Patricia,
Thanks for your assistance.
I disabled UAC, and then it allowed me to reinstall Crystal Reports per your instructions. However I still get exactly the same error message when I try to run a report in Adagio.

I disabled the UAC, reinstalled Crystal per your instructions successfully. However the reports still will not run and I get the same error message.

I think it must be the ODBC connection. I tried some diagnostics and I get am message that the specified driver cannot be loaded due to system error 126, although the driver (AdagioODBCv264.dll) is in the folder expected. I googled it (ODBC error 126) and found plenty of entries from application vendors, but absolutely no advice from Microsoft (typical). I found nothing helpful at all on the internet and I have spent several hours on it.

Hi John,

I just emailed you a troubleshooting document. It is a couple of years old but the error messages are still relevant.

Both the error 160 and the system error code 127 could be related to installing Adagio without proper rights. The \Softrak\ODBCv2\AdagioODBCv2.DLL file isn't being located properly - it gets located in the Windows Registry on installing an Adagio program.

I presume that you have not installed the Adagio ODBCv2 program - it is not required to do this to print reports from Adagio; I was just curious.

ODBC connections must be 32-bit for Adagio reporting, not 64-bit.

Since you had issues with installing CR Runtime, perhaps you should do a Workstation setup with the UAC disabled.

I wrote another response and it was lost. Check the ODBCV2 folder. See if you are missing any of the long named .dlls. I had an issue before that ODBC and other .exe files were renamed because the computer didn't accept long names when installing including Adagio .exes.

The Adagio ODBC driver seems to be linked to the 64 bit DLL on my PC, and not the 32 bit one. Your email has not arrived yet. Do you think my best option would be to uninstall all the Adagio modules then install them again (as a system administrator, even though I am already that on my own PC)?

Before uninstalling everything I thought I would try to solve it as follows:
I checked my ODBC data source as follows:

Control Panel
Administrative Tools
Data Sources (ODBC)
System DSN tab - I can see Adagio Data Source is linked to Adagio Data Source Driver

If I change to the Drivers tab I can see the Adagio Data Source Driver is version 2.01.08.189 with file ADAGIOODBCV264.DLL dated 2/22/2016

This looks like a 64 bit driver. From an earlier post it appears that I should be using the 32 bit driver ADAGIOODBCV2.DLL
Is this correct, and if so how do I remove the existing driver and install the 32 bit one? The Data Sources (ODBC) help says that I must use an installation program provided by the vendor.

BTW FYI my laptop is 64 bit Win 7 Professional with Service Pack 1

Perhaps I can fix it by just changing the following keys in the Windows registry to point to the full path for ADAGIOODBCV2.DLL instead of the path for ADAGIOODBCV264.DLL

HKEY_LOCAL_MACHINE
SOFTWARE
ODBC
ODBC.ini
Adagio Data Source
Driver

and

HKEY_LOCAL_MACHINE
SOFTWARE
ODBC
ODBCINST.ini
Adagio Data Source Driver
Driver

and

HKEY_LOCAL_MACHINE
SOFTWARE
ODBC
ODBCINST.ini
Adagio Data Source Driver
Setup

Tech support - please confirm if this might work before I make any changes to my registry!

Do not edit the registry...

use

C:\Windows\system32\odbcad32.exe for 64 bit ODBC Administrator
or
C:\Windows\SysWOW64\odbcad32.exe for 32 bit ODBC Administrator
as needed.

Hi, John,

Please run Softrak\System\ChkSys.exe and, after Proceed, select the System Snapshot button in the upper left corner of the Status of System window. Continue and create the snapshot After, create an email to support@softrak.com, attach the snapshot zip in your Softrak\System folder to the email and send it.

We'll take a look and get back to you.

Thanks.

Hi John,

As a follow-on to Michael's post, it is very difficult to determine whether Windows has launched the 32-bit or 64-bit version of the ODBC Administrator. If you are using the 64-bit Administrator, it will show you the 64-bit registry entries and 64-bit ODBC Driver. If you launch the 32-bit Administrator, then the 32-bit ODBC driver will be shown.

Adagio installs both 32 and 64 bit ODBC connections. Adagio modules use the 32-bit driver to power the SAP Crystal Reports 2013 Connection. If you launch 64-bit Excel and ask it to connect to an Adagio database (if you have installed the Adagio ODBC module), it will automatically pick up the 64 bit driver.

OCSTEST.EXE in Softrak\System will be using the 32-bit driver (the one used by Crystal). All the ODBC connections require that the module has been run against the database being reported on.

So - can you print a report out of the Sample Data? Have you copied ANY of the files to/from the Softrak\Dict Folder?