The Windows version that is running.
The release of LinkBook that is failing. Perhaps 05 or 06, or a patched version.
The country and version of QuickBooks used to create the database that LinkBook is trying to access.
The disk location of the database.
The network software that is running.
The front-end application that has exposed the problem.
A copy of the ODBC trace file.
The results of using Microsoft Access to interface with the same database via LinkBook.
A speedier response can usually be obtained if a cut-down version of the database can be forwarded that demonstrates the problem and has few tables, and few records in the tables, together with clear instructions about how the problem can be reproduced.
There are three particular types of problem that are commonly reported, and Hill Croft Information Technologies has provided diagnostic tools to deal with each one:
The first problem area is initially getting LinkBook to interface correctly to a front-end application. This is usually caused by a misunderstanding about how to install LinkBook and define a Data Source Name. In these circumstances, ODBCinfo.exe can be run to analyze the ODBC setup configuration and create a diagnostic file, ODBCinfo.txt, which should be forwarded to Hill Croft Information Technologies. ODBCinfo has one mandatory parameter, a DSN. e.g. ODBCinfo "LinkBook Sample Database".
Sometimes, LinkBook fails without an error message being passed on by an ODBC-compliant application. A LinkBook option can be set which forces any error message to be immediately displayed by running regedit to add the line, "Display Errors=True", to the [HKEY_LOCAL_MACHINE] [SOFTWARE] [ODBC] [ODBCINST.INI] [LinkBook ODBC Driver for QuickBooks] section of the Windows Registry.
Another problem area concerns the validity of the ODBC SQL submitted to LinkBook, which is often different from the SQL displayed by a front-end application. The ODBC trace option can be set to trace all ODBC API calls to LinkBook, including the SQLPrepare and SQLExecDirect functions which receive ODBC SQL statements. However, the ODBC trace files can get very large, and considerably slow down processing. Alternatively, a LinkBook option can be set that will create a debug file, SQL.dbg, in the root directory that only traces the SQL calls. The SQL trace file can be activated by running regedit to add the line, "SQL Debug=True", to the [HKEY_LOCAL_MACHINE] [SOFTWARE] [ODBC] [ODBCINST.INI] [LinkBook ODBC Driver for QuickBooks] section of the Windows Registry.