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:

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.