I'm trying the demo version of the software to load contacts from a SQL database to an Outlook contact folder and when I try the load, it fails with the following error.

ERROR:20060703 11:20:45 37000 [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'dbo'. (170)

Based on other similar posts I've checked to be sure there are no spaces in my SQL field names. Any other help you can offer?

Thanks...Ray

Are you using the example database or your own datamodel? What is you SQL Server version?

is the option "Use ANSI quoted identifiers" Checked?

We're using our own database. I did verify that the 'ANSII quoted identifiers' was checked.

Thanks...Ray

what is the SQL server version? Are you using a VIEW?

SQL 2000. I'm using a table.

Thanks...Ray

can you mail (info@geniusconnect.com)us your table creation script and mappings (export button in Assign Table Dialog)

Email is on it's way with the requested information.

Thanks...Ray

Please check your ODBC datasource, I think you have disabled the "Use ANSI quoted identifiers" in Microsoft SQL Server DSN config?