Mail merge with SQL Anywhere 10 and Windows 2007 ?

[Former Member]

Hello,

is there a special trick to do mail merge in word 2007 against a sql anywhere 10 data source ? We seem to not be able to do this.

Either word crashes as soon as we specify the data source, or it then just simply tells us that word could not retrieve a list of objects.... Original message in german "Der Datenverbindungs-Assistent kann keine Datenbankliste in der angegebenen Datenquelle finden."

We did try via the ODBC connection and also via the OLEDB provider, both times with similar results.

We did connect as DBA, but that did also not help.... We use SQL Anywhere 10.0.1.4135

A trace on the server level shows up this:

=,<,62,PREPARE,EXECUTE sa_oledb_catalogs
+1,>,62,PREPARE,65540
=,<,62,DESC_OUT,65540
=,E,62,-265,Prozedur 'sa_oledb_catalogs' nicht gefunden
=,>,62,DESC_OUT
=,<,62,DROP_STMT,65540
=,>,62,DROP_STMT
=,<,62,PREPARE,begin  DECLARE inCatalogName CHAR(128) ;  DECLARE iter int ;  DECLARE local temporary ;  SET inCatalogName = '' ;  set iter = 0; while iter < 255 loop insert into oledb_catalog(catalog_name,description) values (db_name(iter), db_property( 'File',iter)); set iter = iter + 1; end loop; select catalog_name, description from oledb_catalog where catalog_name is not null and catalog_name = if inCatalogName = '' then catalog_name else inCatalogName endif order by catalog_name; end 
=,E,62,-131,Syntaxfehler bei ';' in Zeile 4
=,>,62,PREPARE,0
=,<,62,COMMIT
=,>.,62
+328,<,61,VALIDATE_STMT,65593
=,E,61,-130,Ungültige Anweisung
=,>,61

The database was initially created with 6.0.x and now upgraded via "dbunload -ar" to V10

HELP

André

[Former Member · Accepted solution]

I found a way to do it:

The trick is to create a data source with ms query and store that one as a .dqy file. You can then use that .dqy file in word to do the filtering and merge.

Here a step-by-step guide:

• Start the ms query tool "c:\\Program Files\\Microsoft Office\\Office12\\MSQRY32.EXE"
• Go to "New" and select a odbc connection
• You can now select tables, columns and filters to match your needs
• Now do a "Save as..." and store the query definition in a place you know C:\\myquery.dqy
• Now you can start MS word and select the C:\\myquery.dqy as the datasource

André

[MCMartin · Accepted solution]

See the answer of Karim to the question:

how to use sa database as a data source in excel 2010

So short answer: it is not supported by SQL Anywhere (or it's Microsofts intention to only allow SQL-Server)

[Former Member · Accepted solution]

Ouch... not what I wanted to hear...

So probably I will have to go via ASA->Excel->Word...

😞