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
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:
This answer is marked "community wiki".
answered 09 Dec '10, 09:48
See the answer of Karim to the question:
So short answer: it is not supported by SQL Anywhere (or it's Microsofts intention to only allow SQL-Server)
answered 03 Dec '10, 11:50