problem connecting to remote server with SqlDataSource

[Guest]

I'm trying to use SqlDataSource to connect to a remote SQL Server 2005
(virtual shared hosting e.g. TCP/IP). I keep getting the following error:
provider: Named Pipes Provider, error: 40 - Could not open a connection

I don't know why my sql client is using named pipes, it should be using
TCP/IP?

Here is my connection string:
"Data source=mysqlserver;initial catalog=mydatabase;user
id=myuserid;password=mypassword"

Any help would be greatly appreciated.

 

[Juan T. Llibre]

To connect via an IP address to a SQL Server 2005:

"Data Source=111.111.111.111,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

Of course, substitute the real IP address for 111.111.111.111

Remember that DBMSSOCN=TCP/IP instead of Named Pipes,
and that the port to use (1433 is the default) goes at the end of the Data Source.

If the SQL Server 2005 is using a different port, make sure and use that one.

 

[Guest]

Thank you, thank you, thank you!

I've been tearing my hair out over this for two hours and am on a deadline
as per usual!!