JDBC Tutorials - Herong's Tutorial Examples - Version 3.02, by Dr. Herong Yang
JDBC-ODBC - Configuring SQL Server for TCP/IP Connection
This section describes how to configure SQL Server for TCP/IP connections.
As the first test, I want to try JDBC-ODBC Bridge with the SQL Server 2005 Express Edition on my local machine. To prepare for ODBC connect, I need to make two changes to my SQL Server:
Starting SQL Server Browser Service can be easily done by using the "Services" program in the Control Panel.
Enabling the TCP/IP protocol support on my SQL Server can be done with SQL Server Configuration Manager. Go to the "Protocols for SQLEXPRESS" and enable "TCP/IP" with the context menu. Then look at the "TCP/IP" properties. You will find the port number, 1269, the SQL Server is using to listen ODBC connections.
Now my SQL Server is ready to receive ODBC connections.
Last update: 2007.
Table of Contents