CODEWITHSUNDEEP
sql-serverconnectionodbc
user1342164
user1342164

Reputation: 1454

ODBC Connection on different subnets?

I am trying to establish a ODBC connection between 2 machines. When I go through the ODBC wizard for SQL Server, the server drop down does not populate. The IP address of my sql server say is 162.11.0.8 and the IP address of the machine I am trying to setup ODBC is 162.11.100.40. Is there any way to establish this connection?

Upvotes: 0

Views: 1406

Answers (1)

bohica
bohica

Reputation: 5992

I believe the protocol for searching for servers uses UDP so it won't cross networks. You can however connect across networks so long as you know the IP address and port (just enter them yourself).

Upvotes: 1

Related Questions