Home |
Search |
Today's Posts |
#1
|
|||
|
|||
directly connecting the MailMerge object to MS SQL server
Hello @ll,
I'm trying to directly connect an MS Word MailMerge object to an SQL server table (Word XP German) code e,g, ActiveDocument.MailMerge.OpenDataSource _ Name:="", _ Connection:="Provider=SQLOLEDB.1;Persist Security Info=False;UserID=[UID];Initial Catalog=[database];Data Source=[server]", _ SQLStatement:="SELECT * FROM ""table""" When executing OpenDataSource Word always opens a file dialog "select data source" If I select a (former created for test purposes) ODC-file, the command is passed. If I cancel the dialog, the code runs against runtime error 4198 'command failed'. But I don't like to have the user select the data source, I would like to connect per only (so the user does not know - and is not interested - where the data are from) Can anyone help ? How must the parameter 'Name' be filled, so that there is no file data source required ? Appendix : connection string and sql command are prooved and are working properly, so this is not the reason ... Thanks for any help ! |
#2
|
|||
|
|||
The only way to avoid using a file name is to use an ODBC User or System
DSN. In that case you need to use an ODBC connection string rather than an OLEDB one, and specify an additional parameter, i.e. Subtype:=wdMergeSubTypeWord2000 One thing you can do is to use an empty .odc file (e.g. create an empty file in Notepad and save it as "leer.odc") - as long as you pass everything else you need in the Connection and SQLStatement parameters you should be OK. Peter Jamieson "Gerhard Kiessling" wrote in message ... Hello @ll, I'm trying to directly connect an MS Word MailMerge object to an SQL server table (Word XP German) code e,g, ActiveDocument.MailMerge.OpenDataSource _ Name:="", _ Connection:="Provider=SQLOLEDB.1;Persist Security Info=False;UserID=[UID];Initial Catalog=[database];Data Source=[server]", _ SQLStatement:="SELECT * FROM ""table""" When executing OpenDataSource Word always opens a file dialog "select data source" If I select a (former created for test purposes) ODC-file, the command is passed. If I cancel the dialog, the code runs against runtime error 4198 'command failed'. But I don't like to have the user select the data source, I would like to connect per only (so the user does not know - and is not interested - where the data are from) Can anyone help ? How must the parameter 'Name' be filled, so that there is no file data source required ? Appendix : connection string and sql command are prooved and are working properly, so this is not the reason ... Thanks for any help ! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Border to an object moves the caption!?? | Microsoft Word Help | |||
Conditional inclusion of WordArt? | Mailmerge | |||
MS Word Picture Object | Microsoft Word Help | |||
Inserted Object......advice please.... | Microsoft Word Help | |||
Included Property in Word 2003 MailMerge | Mailmerge |