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)

EquisysLogo
 

Recent news

This article describes the new features and other improvements in the November 2019 release of the Zetadocs Expenses service. Zetadocs Expenses Release ...

This article describes the new features and other improvements in the October 2019 release of the Zetadocs Expenses service. Zetadocs Expenses Release date and version ...