home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,557 of 10,840   
   Allcomp to Allcomp   
   Re: Problem with VB6 and mailmerge in Wo   
   14 Jun 05 15:55:43   
   
   From: marc@nospam.allcomp.be   
      
   Hello,   
      
   I have seen the solution : the oledb method (odc file) only work with   
   office XP.   
   For Office 2000 and before, you must use the odbc method (FileDSN)   
      
   Thank you   
   Marc Allard   
   Allcomp   
      
   Allcomp wrote:   
   > Hello,   
   >   
   > I have a problem with a VB6 program that command a mailmerge with word   
   > object.   
   > The database is a MSDE Database.   
   > In the two cases, the server is the same   
   >   
   > The file c:\res.odc is empty (0 bytes), it is just here because Word   
   > want it to be there.   
   >   
   > str_Con has the connection string to the database server (the same as my   
   > application   
   >   
   > On WinXP and Office 2003 , I do a   
   > .OpenDataSource Name:= "c:\res.odc", SQLStatement:="SELECT * FROM   
   > ""tb_custcorrespPrj"" " , Connection:=str_Con   
   >   
   >   
   > and everything is fine.   
   > On Win98/Me and word 2000, there is an error connecting to the   
   > datasource (Word can not open the datas) number 5922   
   >   
   > Does someone know if the syntax must be different between the two   
   > Windows (or office) or if a specific module must be installed for the   
   > mailmerge to work?   
   >   
   > Thank you   
   > Marc Allard   
   > Allcomp   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca