Thread: MSSQL DB conneciton problem
01-19-05, 00:41 #1Registered User
- Join Date
- Dec 2004
Unanswered: MSSQL DB conneciton problem
We currently have 2 servers with 2 different hosting companies, lets say Host A and Host B. Now host A has our old server and also the MS SQL DB.
We recently purchased a bigger server with HOST B. I moved some of the files over to that server and tried to see if the DB connected fine. But I got an error msg...
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Now we have a local testing server and the connection string I use works fine. So it should work with HOST B. What might be the problem?
The ASP connection string I use is below
set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=SQLOLEDB.1; Network Library=dbmssocn;Password=pass;User ID=dbname;Initial Catalog=catname;Data Source=site URL"
01-19-05, 01:47 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
Since network library is explicitly specified you need to check on the port assignments. 1433 is the default, but if your new hosting company has it blocked, or if your own firewall does not pass requests through it, - that will do it."The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."