connection problem between web server and SQL server

[royyan]

I am writing ASP code which passes data to SQL 2000 server on another machine which hosted in another place. I got following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.

Not sure what causes this problem and how to resolve this.

The web server is on NT 4.0 platform and SQL 2k server is on win 2k platform. Both are behind different firewalls.

Thank you ahead for your advices.

 

[FengShui1998]

royyan,
How are you connecting to your SQL server? Can you post some code?

fengshui_1998

 

[jlgdeveloper]

Named pipes refers to a mapped network drive.

Have you established one to the c$ of the sql server? There ia also a SQL forum. Jonathan Galpin

http://www.keen.com/categories/categorylist_expand.asp?sid=5215353&gid=0&pmode=0