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

As part of our drive towards making the software simpler to use, Zetadocs Expenses now supports single sign-on using Microsoft work or school accounts. This makes it easier for Office 365 ...

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