>Hello Jojo,

>Honestly, I haven't messed with ODBC enough to know what your problem might >be. However, I may be able to help point you in the right direction.

>What I ended up doing to find out what kind of parameters needed to be used >with the OpenDataSource method was to manually (not programatically) create >a mail merge document in word. I opened the exact same data source to which >I was wanting to connect programatically. Once that was done, I saved the >document as an HTML file.

>By viewing the HTML source, I could see what Word had done in setting up >the ODBC connection, the SQL String, etc.

>You might want to give that a shot and compare their connection string to >your own.

>Hope that helps.

>Rodd

Hi Rod,

I manage to solved this but I'm not sure which one did it, I installed & VFPODBC & VFP7SP1. Now I'm working on a class I think contributed by Cetin here in UT. I want the user to fully control the mailmerge, select only customers who's birthday is tomorrow, or customers from countries.

I've got the same error with VFP's Mailmerege wizard last time. Even updated & VFPODBC is installed, still have the error, something wrong with the connection string..

I will try your tip also..


Thanks & Best Regards,

Jojo R. dela Cuesta
Dalplus Technologies
http://www.dalplus.com