all groups > sql server connect > march 2007 >
You're in the

sql server connect

group:

how-to use ODBC C API to connect through named PIPE


how-to use ODBC C API to connect through named PIPE Dmitry Chumack
3/21/2007 9:07:09 AM
sql server connect:
hi *

I have some program, written in C, that uses ODBC API to connect to
MSSQL Server 2000/2005. To create a connection with server I use
SQLDriverConnect function with such connection string:

"DRIVER={SQL
Server};SERVER=MY_SERVER;Trusted_Connection={Yes};DATABASE=MY_DB;"

How can I create connection to server through named pipe using ODBC C
API? How should I change my connection string? My server's pipe name
is \\.\pipe\sql

thanks in advavce
Re: how-to use ODBC C API to connect through named PIPE Sue Hoegemeier
3/21/2007 6:46:19 PM
Use the address keyword to set the connection to the pipe.
See the following reference for more information on the
connection string keywords for SQLDriverConnect:
http://msdn2.microsoft.com/en-us/library/aa177865(SQL.80).aspx

-Sue

On 21 Mar 2007 09:07:09 -0700, "Dmitry Chumack"
[quoted text, click to view]
AddThis Social Bookmark Button