Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Testing ODBC DSN Connection Settings

By: FYIcenter.com

(Continued from previous topic...)

How To Test ODBC DSN Connection Settings?

Assuming you have followed other FYIcenter.com tutorials and created an ODBC DSN called "FYI_SQL_SERVER", and planning to use it your PHP scripts, you should test this ODBC connection first as shown in this tutorial:

1. Go to Control Panel > Administrative Tools.

2. Run Data Sources (ODBC). The ODBC Data Source Administrator window shows up.

3. Click "System DSN" tab, select "FYI_SQL_SERVER", and click "Configure..." button. The Microsoft SQL Server DSN Configuration wizard window shows up.

4. Review the first screen and click Next.

5. Review the second screen, enter the password as "FYIcenter", and click Next.

6. Review the third screen and click Next.

7. Review the fourth screen and click Finish.

8. Review the confirmation screen and click "Test Data Source...". You should see the test result as:

Attempting connection
Connection established
Verifying option settings
Disconnecting from server


Your FYI_SQL_SERVER ODBC DSN is tested and ready to use.

(Continued on next topic...)

  1. What Are the Requirements to Use ODBC Connections in PHP Scripts?
  2. What Are Commonly Used ODBC Functions in PHP?
  3. How To Test ODBC DSN Connection Settings?
  4. How To Connect to a SQL Server using odbc_connect()?
  5. How To List All DSN Entries on Your Local Machine using odbc_data_source()?
  6. How To Execute a SQL Statement using odbc_exec()?
  7. How To Retrieve Error Messages using odbc_errormsg()?
  8. How To Turn Off Warning Messages during PHP Execution?
  9. How To Receive Returning Result from a Query?
  10. How To Loop through Result Set Objects using odbc_fetch_row()?
  11. How To Retrieve Field Values using odbc_result()?
  12. How To List All Tables in the Database using odbc_tables()?
  13. How To List All Columns in a Table using odbc_columns()?
  14. How To Create Prepared Statements using odbc_prepare()?

Related Articles:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: