Collections:
Configuring ODBC DSN with Different Port Numbers
How To Configure ODBC DSN with Different Port Numbers?
✍: Guest
If your SQL Server is not using the default port number, like 1269, you need to set the port number to the correct value during the ODBC DSN creation process, as show in this tutorial:
1. Start ODBC Data Source Administrator and click System DSN tab.
2. Click Add button, select SQL Server and click Finish button.
3. Enter the following and click Next:
Name: FYI_SQL_SERVER Description: FYIcenter.com SQL Server Server: LOCALHOST
4. Select the radio button on "With SQL Server authentication using a login ID and password entered by the user. Also enter in Login ID field: "sa" and in Password field: "FYIcenter".
5. Click "Client Configuration..." button. The "Edit Network Library Configuration" dialog box shows up.
Check and uncheck "Dynamically determine port" and enter "1269" as the Port Number. See picture bellow:
Click OK and continue with the next tutorial to finish up ODBC DSN creation.
⇒ Configuring and Testing ODBC DSN Settings
⇐ Verifying the Port Number of the SQL Server
2024-07-25, 3864🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Where to find answers to frequently asked questions in general areas of Microsoft SQL Server Transac...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...