October 12, 2004 at 4:20 pm
Have never had any problems with SQL Server until this week when we've been getting the "SQL server does not exist or access denied" message.
The ONLY change has been the installation of Windows XP Service Pack 2. It caused some problems in other programs too so am assuming it has affected this one.
Not having any luck getting it sorted.
Using the connection string:
conn.open = "Provider=MSDASQL; Driver={SQL Server}; Server=localhost; Database=SalesResults; UID=userid; PWD=password;"
Has anybody else found a similar problem or able to help?
October 12, 2004 at 10:02 pm
October 13, 2004 at 3:14 am
Thanks Phil,
Found the answer a few hours ago.
Was using Server=localhost in the connection string.
It worked when I changed to Server=main (my computer name) and it also works now after creating an alias for localhost in TCP/IP.
Didn't have to do that before but obviously now you do if anybody else has the problem.
Thanks again for your help.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply