ODBC Connection

   Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

 

What is the ODBC connection?

 

The ODBC (Open Database Connectivity) is a technology by the help of which data can be accessed or can be relocated from a given type of database (data resource). For this, the ODBC drivers of the given database (to process the ODBC function calls, to issue SQL requests to the given data resource, and to return the results) should be installed.

 

How can I add an ODBC drive to the computer?

 

To open the ODBC data resource manager, click on the Windows Start button, click on Control Panel, then to Supervisory device, then click on ODBC data resources button. Here we  have the possibility to add a new ODBC connection and to manage ODBC connections.

 

clip0433

 

Where can the ODBC drivers be found?

 

Often its own driver is integrated into the database programs, and several ODBC drivers can be accessed from the ODBC database supervision driver list as well. You can search on internet or contact the manufacturer of the database program to be used.

What is the ODBC database?

 
To use the data resources, a Data source name should be created (DSN - Data Source Name). The DSN will include all the information needed to access the database manager system. The following data source name can be determined:

 

•User DSN: These data sources are considered local from point of view of the computer, and maybe they can be accessed by the user who created it. This information is stored by the system registry.

 

•System DSN: These data sources are considered local from point of view of the computer, but assigned not only for one user. The system or any of its users can use the data sources set as system DSN. This information is stored by the system registry.

 

•File DSN: These are such file based data sources which can be accessed by the users who have properly installed driver programs, so they can use the database. These data sources do not have to be selected by the user, and they do not have to be local from point of view of the computer.

 

You can find more information on ODBC in the web site of Microsoft.