Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Configuring ODBC DSN with Different Port Numbers

By: FYIcenter.com

(Continued from previous topic...)

How To Configure ODBC DSN with Different Port Numbers?

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:
    ODBC DSN Port Number Setting

Click OK and continue with the next tutorial to finish up ODBC DSN creation.

(Continued on next topic...)

  1. What Is Open Database Communication (ODBC)?
  2. How To Add a New DSN with the ODBC Driver for SQL Server?
  3. How To Define the Name and Server for a new DSN?
  4. How To Provide Login Information for a New ODBC DSN?
  5. Why Are You Getting Errors When Creating a New ODBC DSN?
  6. What Are the Requirements on SQL Server Network Connections?
  7. How To Start SQL Server Browser Service?
  8. How To Enable TCP/IP Protocol on a SQL Server?
  9. How To Verify the Port Number of the SQL Server?
  10. How To Configure ODBC DSN with Different Port Numbers?
  11. How To Configure and Test ODBC DSN Settings?
  12. How To Connect MS Access to SQL Servers through ODBC?
  13. How Can Windows Applications Connect to SQL Servers via ODBC?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...