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.
_________________________
Chris Bishop
---------------
Senior Developer
Dynac Inc.