Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
connecting to SQL Server Using IP Address
- Thread starter ramsai
- Start date
ChrisCarroll
Programmer
- Oct 10, 2000
- 177
Hi ramsai,
Wrong forum there, this is Java not VB. However, the answer to your question has nothing to do with VB or Java:
To get to SQL server from any client program, you have to set up an Odbc data source from your control panel, on your client machine, based on the SQL Server driver.
You quote the name of the server when setting up Odbc.
BUT to get it working over IP, you have to have first run the SQL Server Client Network Utility on your machine, and specified there that you want to connect to SQL server over IP.
If you've done that, and the server is running, and you type the server name in the ODBC control panel, and you set up the parameters you should be able to get a test connection.
NOTE You never need to know the IP address of the server. You DO need to know the Port Number that SQL server is listening on.
Wrong forum there, this is Java not VB. However, the answer to your question has nothing to do with VB or Java:
To get to SQL server from any client program, you have to set up an Odbc data source from your control panel, on your client machine, based on the SQL Server driver.
You quote the name of the server when setting up Odbc.
BUT to get it working over IP, you have to have first run the SQL Server Client Network Utility on your machine, and specified there that you want to connect to SQL server over IP.
If you've done that, and the server is running, and you type the server name in the ODBC control panel, and you set up the parameters you should be able to get a test connection.
NOTE You never need to know the IP address of the server. You DO need to know the Port Number that SQL server is listening on.
- Status