sql server connect: Can any assist on the following error.

I have developed an application, that access the SQL
server 2000.In this application I have coded the
connection string as follows.

"provider=sqloledb;data source=Sever Name;initial
catalog=database name;user id=sa;password=system;"

Then when I load the application on my machine the is
problem but on other machines it say "Specified SQL server
not found"

On Fri, 29 Aug 2003 06:11:46 -0700, "Derby" <Derby74sa@yahoo.com>
[quoted text, click to view]

You are saying that it works on your development machine but not
another? Assuming that your connection string is properly coded, and
you are using a real server netbios name and not "Server Name" --
perhaps you are having a name resolution issue from the second
machine?

Indeed I really appereciate your assistence.

On my development machine everything works well.It is just on other
machines,thats where I get the error:- 'Specified SQL Server not found'.





*** Sent via Developersdex http://www.developersdex.com ***

[quoted text, click to view]
To rule out the name resolution, does it work if you substitute the servers
IP address for the netbios name? Also, have you installed MDAC on the second
machine?

Steve