Testing Merge In word 2003 : A windows with an SQL Msg Appears !!

[Jaboeuf Thierry]

Hello All

I curently test Docs we used to merge under word97 with Word 2003...

Thoses docs get their info from a file called : Donnees.dat.
donnees.dat is the source file so called "recipient list".

First problem :
If i open one doc, a new window appears witch says :

-------------------------------------------------------------------------------------------------
Opening this document will run the following SQL command :
SELECT * FROM C:\xxxxxx\Donnees.dat
Data from your database will be placed in the Document. Do you want to
continue
--------------------------------------------------------------------------------------------------

That window is new and of course i'd like it to "autoreply" yes to
that question... Or even don't ask it and open the document wihout
question as it used to work ???

Second trouble : Word ask for an encoding when opening donnees.dat and
here again opens an window asking something :/
Is it possible to auto reply "Unicode" or "windows default" on this
window ??

An way of resolving that last isue was by saving donnees.dat under the
word format but it's no more possible as donnees.dat is now modified
and then rewrite by another program....

Any help apreciated ... Or we'll forget the shift to Word 2003 for
some time : The usual merge took 3 sec with w97 and now 15 sec with
w2003 (with 2 windows to answer :/ )

I search the options for security tabs that would talk about sql and
haven't found anything

 

[Cindy M -WordMVP-]

Hi Jaboeuf,

I curently test Docs we used to merge under word97 with Word 2003...

Thoses docs get their info from a file called : Donnees.dat.
donnees.dat is the source file so called "recipient list".

First problem :
If i open one doc, a new window appears witch says :

------------------------------------------------------------------------
-------------------------
Opening this document will run the following SQL command :
SELECT * FROM C:\xxxxxx\Donnees.dat
Data from your database will be placed in the Document. Do you want to
continue
------------------------------------------------------------------------
--------------------------

That window is new and of course i'd like it to "autoreply" yes to
that question... Or even don't ask it and open the document wihout
question as it used to work ???

This can be changed in the Registry. Here's what you need to set

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options]

"SQLSecurityCheck"=dword:00000000

You should be able to set up a POLICY to do this on all machines.
--

Second trouble : Word ask for an encoding when opening donnees.dat and
here again opens an window asking something :/
Is it possible to auto reply "Unicode" or "windows default" on this
window ??

An way of resolving that last isue was by saving donnees.dat under the
word format but it's no more possible as donnees.dat is now modified
and then rewrite by another program.

This behavior was actually "introduced" in Word 2002, and it has to do
with the introduction of the OLE DB default connection method. I'd like
to expand on this with a bit of background so that you understand what's
going on.

Word 97 had two basic ways to connect to delimited text files: ODBC and
its internal converter. If the ODBC driver did not recognize the file
extension, then the internal converter was used automatically. That's
why that other program is using the extension *.dat - to force the
internal text converter to kick in. You probably did this to be sure
accents would be recognized correctly.

Well, OLE DB recognizes the file type as being text, even with the *.dat
(or any other) extension. To put it more succinctly, there's no way
anymore to force the automatic use of the Internal Text converter as the
connection method.

If you activate "Confirm conversions on open" in Tools/Options/General,
then you get a list of connection methods when you select a data source
file. Click the "Show all" checkbox will bring "Text file *.txt" into
the list, and this is the one you want to get back to the "old way".
(Still have a dialog box, but the merge would run faster.)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail