Re: Error Message when using ODBC: " Record <n> had too few data f

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I was getting this same error using the Lotus SQL driver to do a mail merge
with Word 2002. I created the ODBC connection and all seemed well, except
it didn't work. Now for the odd part - using the *same* connection I was
able to access the Notes data in Access. So my first test was to create a
link in Access, then link to the Access DB in Word - voila. It's ugly, but
it worked. Seeing your comment about using MS Query (hadn't realized you
could use that in Word that way - thanks!) got me thinking - and, sure
enough, that worked - and is a LOT easier. Seeing how this works I can
imagine a lot of people where I work are going to be happy at being able to
create a mail merge using their Notes address book.

Mike

"Peter Jamieson" <pjj@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uxVxt9PRFHA.2384@xxxxxxxxxxxxxxxxxxxxxxx
> From what you describe, I'd guess you are probably actually using the
OLEDB
> provider, not the ODBC driver. Are you asked to save a .odc file at some
> point? If so, it's OLEDB.
>.....
>
> Once you have created your User/System DSN, there are two ways you can try
> to connect:
> - go through the Select Data Source dialog, and go via MS Query (it's in
> the Tools menu at the top right of the dialog). Follow the steps in there.
> Before you return the data to Word, I suggest you save the query as a .dqy
> file as that can also be opened in Notepad and give you information about
> what should be in the connection string. My guess is that if this works,
you
> will see the data when it is first returned, but after that you will see
> errors because the login security information has been discarded.


.

Quantcast