Equisys technical notes

Technical guidance, explanations and fixes for our products

PRB: ODBC SQL error 3700 when importing data with Zetafax.

Print

ZTN1028

ID: ZTN1028

This Zetafax technical note applies to:

  • Zetafax 5.5 client and later

Symptoms

The Zetafax client displays the following error when importing fax addressee data from an ODBC compliant database:

  • ODBC SQL error 3700

Cause

This is an error code returned by the database when the Zetafax client attempts to retrieve the data.  The most common cause of error 3700 when using MS Access, is having a table name or column name with a space in it e.g. " Customer names and Addresses" rather than " Cust_names" - this is not currently supported by the Zetafax client.

Resolution

Ensure the table and column names have no spaces in them, and try importing the data again.

Status

Table and column names with spaces are not currently supported by Zetafax.

Last updated: 11 January 2000 (GC/GW)

Equisys Logo, Document Management and Expense Management for Business Central
 

Replaced by script