PRB: ODBC SQL error 3700 when importing data with Zetafax.
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)