Re: Stopped working

Shawn Ferguson wrote:
>> I've been using a development server forever using the same ole
>> connection string (below):
>>
>> cs = "provider=SQLOLEDB; network=DBMSSOCN; server=myserver, 1433;"
>> cs = cs & "database=mydb; uid=username; pwd=password;"
>> set ADODBConn = Server.CreateObject("ADODB.Connection")
>> ADODBConn.open cs
>>
>> Suddenly, I started getting these errors.
>>
>> [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not
>> found.
>>
>> The sql server is on it's own box and the webserver is on another.
>> All 50 application developed don't work anymore resulting in the
>> same error. The only thing that has changed, I tried to install SQL
>> Server 2005 on the local machine and It couldn't configure itself
>> correctly so it didn't install right.
>>
>>
>>
>> Does anyone have a clue why I could be getting an error all of a
>> sudden?
>>

I don't understand the scenario fully. Are you saying the attempt to install
SQL2005 on "the local machine" (which machine is that? The web server?)
broke the ability to connect to remote sql servers? Can those servers be
pinged from the web server? What sql versions are you attempting to connect
to?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"