469,315 Members | 1,605 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,315 developers. It's quick & easy.

Please help me figure out my SQL Connection string

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.3zhosting.com
Database name: hopstec_membership
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=SQLOLEDB; Data Source=mssql1.3zhosting.com; user id=hopstec_access;password=xxxx

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!
Oct 10 '07 #1
1 1192
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.
Oct 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.