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
Recent news

The sudden rush towards remote working practices in 2020 led many organizations to implement changes to upgrade their document capture processes on Microsoft Dynamics 365 Business Central or ...

Company credit cards are often seen as the most convenient way to incur travel & entertainment expenses, however it can be a very different story when it comes to the administration of these ...

North America
 
Equisys Inc
30000 Mill Creek Avenue
Suite 335
Alpharetta, GA 30022
USA
(770) 772 7201
Europe
 
Equisys Ltd
91 Southwark Bridge Road
London
SE1 0AX
United Kingdom
+44 (0)20 7203 4000
 

© Equisys Ltd
All rights reserved

© Equisys Ltd    All rights reserved    Contact    Privacy policy    Cookies