Re: Mail Merge using SQL Server 2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The problem is that Word 2000 can only se ODBC to connect to SQL Server, and
ODBC does not pass the Unicode data in your NVARCHAR fields along. FWIW
later versions of Word can use OLE DB which does that properly, but for the
moment you either have to:
a. change your NVARCHAR fiels to VARCHAR fields (which means you may lose
data if you are actuall using the Unicode features provided by NVARCHAR) or
b. create a SQL Server View that converts each NVARCHAR field into a
VARCHAR field (there are SQL Server Transact-SQL functions called CAST and
CONVERT that do that - you probably need CONVERT). Again, you will lose
data, but only when you are doing your merge.

Peter Jamieson


On 01/10/2008 13:43, in article e7RLfN8IJHA.3936@xxxxxxxxxxxxxxxxxxxx,
"David Clifford" <someone@microso> wrote:

Hello all.

I am using SQL server 2005 and Word 2000. Previously, I have used Access
2000 to create a query to merge names and addresses on a Word 200 document.
No porblems.

It is a simple query..."Select ID, Forename, Surname, Address1...etc"

I am now using SQL Server 2005, and I want to Mail Merge the same addresses
etc. I set up the query, no problem. I select my datasource (SQL Server
database), no problems, I select the fields, no problems, I run the
merge...no data, just blank lines for nvarchar fields, and strange numbers
for integer fields.

Obviously something is wrong. I re-run the same query from Access 2000, Mail
Merge, no problems.

Any suggestions? I ahve tried this Merge now about 10 times, same result.

Thank you for any help that you may offer.

Regards

David





.

Relevant Pages

  • Re: Mail Merge using SQL Server 2005
    ... Thank you very much Peter, that was a vey concise and helpful answer. ... ODBC does not pass the Unicode data in your NVARCHAR fields along. ... VARCHAR field (there are SQL Server Transact-SQL functions called CAST and ... I set up the query, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Problem importing excle file with unicode character
    ... Are you importing from Excel into a SQL Server table? ... > When I use the DTS and ask to create the chart (all the nvarchar fields ... > When I see the chart, a lot of question marks appear in the field with the ...
    (microsoft.public.sqlserver.dts)
  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... the ODBC source using named pipe, but I don't know how to enable named pipes ... If it is not working I am going to use ado to connect to sql server. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)