Please help me figure out my SQL Connection string

[kmcq]

I've contacted my host and they have no idea what connection string I need to use to access the MS SQL database we have running on their equipment.

I'm trying to connection from ASP using OLE.

Important info:
Host Name: mssql1.3zhostin g.com
Database name: hopstec_members hip
Database login: hopstec_hopsvb
Database users hopstec_access

password: xxxx (okay, not really gonna put that here, but its the same for everything)


I want to find a connection string that will let me connect to the database from a remote computer. I assume it will look something like this:

Provider=SQLOLE DB; Data Source=mssql1.3 zhosting.com; user id=hopstec_acce ss;password=xxx x

I've browsed forums for hours and tested a wide variety of connection strings similar to this one, but I just can't guess what it should be. Thanks in advance if you can put it together for me!

[kmcq]

Ok now...

Tech support at my host finally got tired of me pestering them and cheated by looking at the connection string in another client's application :)

Turns out I needed to specify a specific (not the default) port in the connect string.