After studying many of these strings I am more confused than ever.
dilettante has an excellent contribution on this thread, which of course is way above my head:

http://www.vbforums.com/showthread.p...ing+sql+server

I wish to connect with ADO and VB6 to a remote server on the web where I have set up a SQL server database and I have the names of the server, database, user and password.

Can someone please assist me to compile the correct connection string.
Thanks
PK