Classic ASP site. My connection string (user and password edited out of course) is: "Provider=SQLOLEDB;Data Source=tcp:s07.Winhost.com;Initial Catalog=DB_75822_pictureshow;" _ & "User ID=user;Password=password;" _ & "Connect Timeout=15;Integrated Security=False;" It returns: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found. I've tried it with and without the tcp prefix for the Source parameter. Same issue every time. Were have I gone wrong?
Got the issue resolved by using the following example: Data Provider=SQLNCLI10;Data Source=myServerAddress; Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword