Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-18 : 08:18:11
|
| George writes "My site www.polyadvertising.com/webapp/index.html use to work fine. I edited a stored procedure, afterwhich the site would no longer connect to the database which sits on a different server. I get the following error.Microsoft OLE DB Provider for SQL Server error '80004005' [DBNMPNTW]Specified SQL server not found. What is very odd, is that when the site is copied to another server, the database connection works fine. I've set up test queries which work on other servers, but not the one they need to.Connection String: Set Connection = Server.CreateObject("ADODB.Connection") Connection.ConnectionString = "Provider=SQLOLEDB;Data Source=XXX.XXX.XXXX.XXX;uid=MyDB;pwd=MyPW;database=MyDBName;"Connection.Openso, database works fine, code works fine, except when code sits on one particular server. Code did work fine until I used MS Enterprise Manager to edit a stored procedure. Same server houses several other sites that utilize Access databases and all work fine.Using OS = W2k, SQL 2000 7.0 sp3, code is asp" |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-11-18 : 09:23:11
|
| How about posting the code in question? I suspect the answer lies in that stored proc.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-18 : 12:29:14
|
| Does the edited stored procedure contain a linked server? Maybe the linked server hasn't been setup on the database server yet.Tara |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-18 : 20:05:12
|
| For some reason, the server is now trying to connect using the Named Pipes library, and it's not finding it via that route (and you appear to be connecting by IP address) You may need to add a Network property to your connection string to use TCP/IP instead:Connection.ConnectionString = "Provider=SQLOLEDB;Data Source=XXX.XXX.XXXX.XXX;uid=MyDB;pwd=MyPW;database=MyDBName;Network=DBMSSOCN" |
|
|
|
|
|
|
SQL selective connectivity