Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How To Configure and Test ODBC DSN Settings?

April 26, 2017configure DSN ODBC settings Test

0

Posted

How To Configure and Test ODBC DSN Settings?

1 Answer

0

Posted

Continue from the previous tutorial. Click Next after you have finished changing the port number. The ODBC Data Source Administrator will try to connect to the SQL server through the specified port number and login information. If the connection is successful, you will see the next screen asking for selecting default database. 1. Check “Change the default database to:” check box, and select “FyiCenterData” as the default database for this DSN setting. See picture bellow: 2. Click Next to see the last screen of the “Create a New Data Source to SQL Server” wizard. 3. Change nothing on the last screen and click Finish button. The confirmation screen shows up. 4. Click “Test Data Source…” button.