ODBC: Difference between revisions
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
ODBC is the abbreviation of Open DataBase Connectivity, which is a standard software interface to interact with different Databases. | ODBC is the abbreviation of Open DataBase Connectivity, which is a standard software interface to interact with different Databases. | ||
{{RadiMationLink}} is often using an [[ODBC]] connection to retrieve information from an external database. For example the [[customer database]] within {{RadiMation}} can be configured to use an [[ODBC]] connection. Most database management systems (like [[MySQL]]) provide an ODBC driver, which makes it possible to connect {{RadiMation}} through the [[ODBC]] layer with all of those databases. | {{RadiMationLink}} is often using an [[ODBC]] connection to retrieve information from an external database. For example the [[customer database]] within {{RadiMation}} can be configured to use an [[ODBC]] connection. Most database management systems (like [[MSSQL]], [[MySQL]] and others) provide an ODBC driver, which makes it possible to connect {{RadiMation}} through the [[ODBC]] layer with all of those databases. | ||
Each [[ODBC]] connection has some specific parameters for the database connection. These specific database connection parameters can be configured in the [[ODBC]] driver for that specific database. The configuration of the [[ODBC]] driver can then be stored as a Data Source, which is a configured [[ODBC]] database connection. | Each [[ODBC]] connection has some specific parameters for the database connection. These specific database connection parameters can be configured in the [[ODBC]] driver for that specific database. The configuration of the [[ODBC]] driver can then be stored as a Data Source, which is a configured [[ODBC]] database connection. | ||
| Line 13: | Line 13: | ||
An explanation of the [[MySQL]] [[ODBC]] driver is available on the: [[MySQL Connector/ODBC Data Source Configuration]] page. | An explanation of the [[MySQL]] [[ODBC]] driver is available on the: [[MySQL Connector/ODBC Data Source Configuration]] page. | ||
An explanation of the [[MSSQL]] [[ODBC]] driver is available on the: [[SQL Server ODBC Driver Configuration]] page. | |||
== Links == | == Links == | ||
Latest revision as of 08:39, 2 July 2013
ODBC is the abbreviation of Open DataBase Connectivity, which is a standard software interface to interact with different Databases.
RadiMation® is often using an ODBC connection to retrieve information from an external database. For example the customer database within RadiMation® can be configured to use an ODBC connection. Most database management systems (like MSSQL, MySQL and others) provide an ODBC driver, which makes it possible to connect RadiMation® through the ODBC layer with all of those databases.
Each ODBC connection has some specific parameters for the database connection. These specific database connection parameters can be configured in the ODBC driver for that specific database. The configuration of the ODBC driver can then be stored as a Data Source, which is a configured ODBC database connection.
Configuration
The configuration of the ODBC connection should be done within the Microsoft Windows operating system.
Select
-
Start
- Settings
- Control Panel
- ODBC Data Sources
-
-
-
-
Now the ODBC Data Source Administrator dialog will be shown, which can be used to manage the available ODBC Data Sources.
Then Select Add... to add a new ODBC Data Source.
Depending on the required Database connection, the correct driver should be selected. The selected driver will be used to create a new Data Source when the Finish button is pressed. Depending on the selected ODBC driver, a specific driver configuration window will appear. This driver specific configuration window has to be configured to further finalize the ODBC connection with the correct parameters.
Specific ODBC Drivers
An explanation of how to use the ODBC text-database driver is available on the ODBC text setup page.
An explanation of the MySQL ODBC driver is available on the: MySQL Connector/ODBC Data Source Configuration page.
An explanation of the MSSQL ODBC driver is available on the: SQL Server ODBC Driver Configuration page.
Links
- Wikipedia: Open Database Connectivity