Hi All,

I am installing Dynac for a client and I am experiencing problems with connecting to the data, including the sample data.

First thing to note is I have installed Dynac and used the ODBC at a number of other clients with minimal issues.

The details:
Ledger 9.1A
ODBC 9.1A (140922) - Latest off the website

In Excel using the Microsoft Query tool I can select AL90DGLO but I am unable to expand to see the columns.

Interesting note: The user gave us all the GL.* files and I have no problem connecting to their data on my computer.

Do you get an error?
Can you expand other files?
What version of Excel, 32 bit or 64 bit?

It is 32-bit excel and I cannot expand any tables ( random testing about 15 tables ).

No error in Excel but when I run a select * from AL90DGLO from the Dynac DB tool I am getting the error of "(8) Error attempting to open file: AL90DGLO". I would have posted that early but I swear the error was data file not found as in bad table name.

What are the usual suspects in this case?

Look at the files in ..\Softrak\ODBCv2 on your machine and see what is installed at the site.

What does "(8) Error attempting to open file: AL90DGLO" mean in your application?

Is it possible you are not looking at the correct data folder?

How is the "connection" being made in MSQuery from Excel. If the client has not purchased/registered Adagio ODBC then they will not be able to create a DSN or connect to the data.

(8) Error attempting to open file: AL90DGLO" is the error returned by ODBC.

If I copy the folder to my local environment I can access the data to problem.

Is there any kind of logging or debugging that can be turned on or looked at?

You may turn on Tracing for ODBC using the ODBC Data Source Administrator and set the destination folder for the log file.

What folder are you copying to your local environment? The data folder or ..\Softrak\ODBCv2?

Are the files in your local ..\Softrak\ODBCv2 the same as at the client site?

I copied the folder containing the GL.* files extracted them to C:\Temp and created a new DSN and pulled the data into Excel.

I'll try turning on the log file

Doesn't seem to give anything useful. Is there any Adagio debugging or logs to help figure out what went wrong?

here is the ODBC tracing:

RESS;Init 12e8-7c4 ENTER SQLExecDirectW
HSTMT 0x028707C8
WCHAR * 0x0273C8F8 [ 24] "select * from AL90DMST\ d\ a"
SDWORD 24

SQLEXPRESS;Init 12e8-7c4 EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 0x028707C8
WCHAR * 0x0273C8F8 [ 24] "select * from AL90DMST\ d\ a"
SDWORD 24

DIAG [S1000] [Softrak Systems][Adagio] (8) Error attempting to open file: AL90DMST. (8)

SQLEXPRESS;Init 12e8-7c4 ENTER SQLGetDiagRecW
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x028707C8
SQLSMALLINT 1
SQLWCHAR * 0x0018EBE8
SQLINTEGER * 0x0018E7D0
SQLWCHAR * 0x0018E7E8
SQLSMALLINT 512
SQLSMALLINT * 0x0018E7D4

SQLEXPRESS;Init 12e8-7c4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x028707C8
SQLSMALLINT 1
SQLWCHAR * 0x0018EBE8 [ 5] "S1000"
SQLINTEGER * 0x0018E7D0 (8)
SQLWCHAR * 0x0018E7E8 [ 70] "[Softrak Systems][Adagio] (8) Error attempting to open file: AL90DMST."
SQLSMALLINT 512
SQLSMALLINT * 0x0018E7D4 (70)

I believe Adagio ODBC is registered and licensed on your machine but that will not be the case at your client's site unless they purchased the product.

Further, the files in your ..\Softrak\System folder are probably not the same as the ones at the client site.

You need to use your 3rd Party OEM string when connection at the client site.