Newbie Question re: ODBC

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris McKenzie - 03 Jun 2004 17:06 GMT

I want to mailmerge using VBA connecting to a SQL Server Database.

Do I have to specify a DSN Beforehand? Can I create a DSN File to use instead? Is there some way to use a standard connection string to connect to SQL Server?

I need to distribute this document to different client sites that have different local server names. It would be great if they didn't have to create the DSN first.

Thanks,
Chris

Reply to this Message

Cindy M -WordMVP- - 04 Jun 2004 11:00 GMT

Hi Chris,

Peter Jamieson may jump in here and correct me on this, but...

I believe you do need to have a DSN (User, System or file) in order to do an ODBC
connection to any data source.

> I want to mailmerge using VBA connecting to a SQL Server Database.
>
> Do I have to specify a DSN Beforehand? Can I create a DSN File to use instead? Is there some way to use a standard connection string to connect to SQL Server?
>
> I need to distribute this document to different client sites that have different local server names. It would be great if they didn't have to create the DSN first.

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

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

Reply to this Message

Chris McKenzie - 04 Jun 2004 14:02 GMT

Thanks Cindy!

Chris

> Hi Chris,
>
[quoted text clipped - 18 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply in the
> newsgroup and not by e-mail :-)

Reply to this Message