ODBC Connections

Top  Previous  Next

 

ODBC is a standard method of sharing data between databases and other programs. ODBC drivers use the standard Structured Query Language (SQL) to gain access to data.

 

You need the correct ODBC driver installed on your system to access specialized databases, including some from Microsoft.

 

Setting up your ODBC Connection:

 

1. Select ODBC Administrator from the Tools menu

 

2. Select the File DSN (data source name) tab and click the Add… button. This dialog appears:

 

  dlg_ODBC_New_DSN_001

 

3. Choose the appropriate option from the list (here we have chosen SQL Server) and click the Next > button. You will be prompted to enter a name for your new data source.

4. Click next again and you will be presented with the information of your configuration.  You will then be prompted to enter the information below:

 Note that these screen shots are for SQL server, the dialogs are specific to your database type and may vary.

  dlg_ODBC_New_DSN_002

 

5. Click on Next. You will be asked for your Connection information: If you are connecting to a specific database it is best to use the connection information for the database itself. Using the NT logon may work for you but not others.

 

dlg_ODBC_New_DSN_003

 

6. Clicking on Next > Here we enter the name of the server to which we're connecting and the actual database table if necessary.

 

dlg_ODBC_New_DSN_004

 

7. The next screen is for advanced technical settings, you may Skip this screen without making changes.

8. Click on Skip > And you will end up at the confirmation screen where you are asked if you want to test the  connection.

9.  Click on Test > And you should see at the bottom of the test panel.

 TESTS COMPLETED SUCCESSFULLY!

 

You can use this ODBC database connection for your project.

 

Note:  If your connection does not test successfully here, it will not work with dbQwikSite.  ODBC connections are a feature of MS Windows, not dbQwikSite.  If you are having troubles, you may find a lot of help from MS Support sites and discussion groups.  Yes, we can help too, but you may get better help from sources.

 


See Also:

ADO Connections

Database Tips