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 (,1433), that seems to work
with SQL Compare and Data Compare.


Brian Donahue
Red Gate Technical Support

"Ian Spence" <[email protected]> wrote in message
news:[email protected]
> 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.