I believe I am but I will verify.

I am using the 3rdParty parameter. I believe the error I get is the the license has expired if I am not licensed.

I used the Client NFR code to install the ODBC.

There is no additional Adagio logs.

Your log shows SQLEXPRESS not Excel?

That last log was through our DB Tool because it generates the error message. Excel just displays the table names without the columns.

So what is different between your setup and the setup at the client site?

I managed to get the sample working at the clients. I had installed into a new directory away from their C:\Softrak\ and I deleted and re-created the DSN. It occured to me that if I didn't delete and re-create the DSN it could be pointing to a different AdagioODBC driver.

So I can load the Sample data now. I am still having problems with the company data but I think I'm in the realm of talking with the client's Adagio Var and it might simple be a setup or pathing issue.

Ok, I got a company working.
Here are my steps.

Current setup: (not exactly but should work )

1. C:\Softrak\data\{ Companies }
2. Install ODBC in D:\Softrak\ODBCV2 ( this creates a system folder in D:\Softrak )
3. Copy C:\Softrak\data\Company1 to D:\Softrak\data\Company1
4. Create DSN to D:\Softrak\data\Company1
5. Try DSN - Failure
6. Modify ADSPROF for company1. Invalidate the Currency / Tasks directories
7. Try DSN
8. Prompted for Currency / Tasks
9. Point them to D:\Softrak\system
10. Success!

I determine that success was due to changing the tasks folder to the D:\Softrak\system folder. This folder was created during the installation of the ODBCv2.

If I left the tasks pointed at C:\Softrak\system as defined in ADSPROF then the failure is [DSI]: Error message not found: Connect Failed.

This success is not useful as the ADSPROF file cannot be modified. Have to figure out why the ODBC doesn't like the tasks in the original system folder.

Adagio ODBC should be installed with the rest of the Adagio software.
Is this a local install of Adagio to drive C: or is C: the main drive on a Server that you are RDP'd into?

Well the setup is different.

The server I am on is not the server Adagio is used from. Each user uses Adagio from their own computer and the adagio files all sit on a single server.

At one point Adagio was installed on the server but is not being used. I did try to install ODBC in the folder that is shared by everyone but since the files were being used it would not let me install it.

That is the last thing I would need to do is to get ODBC installed in the same location that is being shared.