Connect to server by ip address and port

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
Hi Ian,

SQL Compare and data compare construct a plain old ODBC connection
string based on the information that you feed to the ConnectionProperties
object. There isn't a property for a port number, but I've found that if you
use the Named Pipes format for specifying a port, where the port number
follows the IP address after a comma (127.0.0.1,1433), that seems to work
with SQL Compare and Data Compare.

Regards,

Brian Donahue
Red Gate Technical Support

"Ian Spence" <ian.spence@ebooks.com> wrote in message
news:Aqs7hzjQEHA.3088@server53...
> Connect to server by ip address and port
>
> Is it possible to connect to a server by IP address and port?
>
> I am using the Synchronisation toolkit.
>
> Here is a piece of sample code, note the ip address and standard port 1433
> for SQL Server.
> Database db1=provider.GetDatabase(new
> SqlConnectionProperties("123.456.789.123:1433", "EBL", "ebluser",
> "ebluser"));
>
>
This discussion has been closed.