binqing

I am trying to use the OpenDataSource function and Connection argument
to access the SQL Server to get data for a MailMerge. The options I
found is using OLEDB, ODBC, DDE, and ODSO, but none from them is my
option - my application needs to be installed in the final user machine,
so set up ODBC connection for each every of them is really not a good
idea. So it is very much appreciated if any one here can provide some
advice on non-ODBC connection in this situation.

strCon = "DSN=myDSN;DATABASE=myDB;uid=myuser;pwd=mypass ;"

objDoc.MailMerge.OpenDataSource Name:="", Connection:=strCon,
SQLStatement:=strSQL, subtype:=wdMergeSubTypeWord2000

Thanks in advacne


--
Posted via http://dbforums.com