Connection string is Named Pipes should be TCP/IP

[DougP]

I am getting and error on my ASP page written in VB Script
here is the code
<%
Set Conn = server.CreateObject(&quot;ADODB.Connection&quot
Conn.Open &quot;driver=SQL Server;server=mysite.webplace.com;uid=xxxx;pwd=yyyy;database=mydb;&quot; <<<<<<< This is line 14 >>>>>>>
Set RS1 = Conn.Execute(&quot;SELECT * From Customers Where [WEBLogin] = '&quot; & login & &quot;' AND [WEBPassword] ='&quot; & pass & &quot;'&quot
%>

here is the error
---------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.
/asp/tableof.asp, line 14
------------------
The Host company says the error refers to me trying to connect using Named Pipes, I should be connecting using TCP/IP. Can some one help me with the syntax???

This does not work either
<%
Set Conn = server.CreateObject(&quot;ADODB.Connection&quot

Conn.Open &quot;Provider=SQLOLEDB;Data Source=000.00.000.000;Initial Catalog=mydb;User ID=xxxx; Password=yyyy&quot;

Set RS1 = Conn.Execute(&quot;SELECT * From Customers Where [WEBLogin] = '&quot; & login & &quot;' AND [WEBPassword] ='&quot; & pass & &quot;'&quot
%>
the error is different but still no access
--------------
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/asp/tableof.asp, line 14
-------------------

TIA DougP, MCP

 

[FengShui1998]

DougP,

Does the database reside on your web server or on another server? If on another server, do you have the IP address of that server and/or if you have DNS, is that name translating properly?


fengshui_1998

 

[DougP]

It resides on another server, our WEB host's.

This is a page from our WEB site. So the code has to work on any machine any where. DougP, MCP

 

[ISPrincess]

Why do you use DataSource?


sConnectionString = &quot;Provider=SQLOLEDB.1;server=SERVERNAME;database=DATABASENAME;uid=XXX;pwd=XXXXXX&quot;

 

[DougP]

If you un-check the Emotions/Smileys in the Step2 Options row below the smiley won't show up in the middle.

Can you do that and repaste the string DougP, MCP

 

[ISPrincess]

sConnectionString = &quot;Provider=SQEDB.1;server=SERVERNAME;database=DATABASENAME;uid=XXX;pwd=XXXXXX&quot;

 

[ISPrincess]

sConnectionString = &quot;Provider=SQLEDB.1;server=SERVERNAME;database=DATABASENAME;uid=XXX;pwd=XXXXXX&quot;

 

[DougP]

here is what I had to use

Conn.Open &quot;Provider=SQLOLEDB.1;Password=PASSWORD;Persist Security Info=True;User ID=USERID;Initial Catalog=universal1;Data Source=SERVERNAMEt;network=dbmssocn&quot;
the &quot;network=dbmssocn&quot; on the very end forces it to use TCP/IP

Thanks to all

DougP, MCP