Hello ,
The problem here is You have an APP that is connecting to the SQL Server
automatically everytime
the Box is started..Now, the connection string to the SQL Box seems to be
with DSN
e.g. something like this,
Set MSCSDataSource = Server.CreateObject("ADODB.Connection")
MSCSDataSource.Open "DRIVER={SQL
Server};DSN=merchdln;UID=headline_admin;PWD=hdln;DATABASE=merchdln"
In your case , the connection string has wrong attribute values, e.g.
Server name or DSN name etc and thats
why the connection is failing giving you this error.
Make sure that the connection string is right and then I am sure the Error
will go away.
Thanks,
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.? 2002 Microsoft Corporation. All rights
reserved.
Additional support can be obtained at http://support.microsoft.com
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
>Newsgroups: microsoft.public.sqlserver.programming
>Subject: SQL Upgrade Wizard 6.5 to 2000 fails -- HELP!!
>Date: Thu, 16 May 2002 10:04:10 -0700
>Organization: Epoch Internet
>Lines: 17
>NNTP-Posting-Host: charon.aerovironment.com
>Mime-Version: 1.0
>Content-Type: text/plain; charset=us-ascii; format=flowed
>Content-Transfer-Encoding: 7bit
>X-Trace: nntp1-cm.news.eni.net 1021568819 10962 206.135.123.2 (16 May 2002
17:06:59 GMT)
>NNTP-Posting-Date: Thu, 16 May 2002 17:06:59 +0000 (UTC)
>User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.9)
Gecko/20020311
>X-Accept-Language: en-us, en
>Path:
cpmsftngxa07!cpmsftngxa10!tkmsftngp01!newsfeed00.sul.t-online.de!t-online.d
e
!nntp-relay.ihug.net!ihug.co.nz!providing.news.eni.net!accepting.news.eni.ne
t!not-for-mail
>Xref: cpmsftngxa07 microsoft.public.sqlserver.programming:258464
>X-Tomcat-NG: microsoft.public.sqlserver.programming
>I get an error stating on an NT server box:
>"Neither DSN nor SERVER keyword supplied. Invalid connection string
>attribute"
>And this msg comes up next:
>Please make sure this value is not NULL."
>computer is identical.
>The error seems to come up after providing the 'sa' passwords and
>selecting the export server. The status box says "Restarting
>MSSQLserver service" when the error occurs.
>I have tried to reinstall 2000.
>I cannot figure this out or find any information on it.
>PLEASE HELP!!!
by