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!