SQL Native Client ODBC changing connection

[Scott Trick]

I am using SQL Native Client in ODBC to connect to our MS SQL Server 2005
server and once in a while I get this error:

Named Pipes Provider: Could not open a connection to SQL Server

Is there a way to change the connection on the client machine to connect via
TCP/IP rather than named pipes?

In the old odbc drivers there was this option but I cannot find it in the
new SQL Native Client ODBC driver.

Thanks!

Scott

[Sylvain Lafontaine]

You don't say with which type of client of you are accessing this
sql-server. Create and use an alias (works in all cases, see the SQL Server
Configuration Manager and looks for the tab Aliases) or try adding tcp:
before the server's address (np: for named pipes) but this isn't permitted
in all cases. If necessary, add the port at the end separated with a comma.

You can also chose to use the IP address (the group of four numbers
separated by dots) instead of a name.

There is also a setting in the registries for specifying the default network
protocol to use as a client but I don't remember where.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

"Scott Trick" <Scott...@discussions.microsoft.com> wrote in message
news:930EC985-66D3-4AEA...@microsoft.com...

[mycorrado]

With native client you can prefix the connection string

tcp:servername..

and that will force TCP over pipes.