What Is Open Database Communication (ODBC)?
Submitted by: AdministratorODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management servers.
If you want to access a database server through an ODBC driver from an application program, you need to meet the following requirements:
* An ODBC driver specifically designed for the database server.
* An ODBC DSN (Data Source Name) - an ODBC configuration representing the ODBC driver and database server.
* An ODBC API (Application Programming Interface) for your application program to interact with database server through the ODBC driver.
For example, if you want to a SQL Server in a PHP script through an ODBC driver, you need to make sure that:
* An ODBC driver for MS SQL Server - The ODBC driver is installed as part of the Windows system.
* An ODBC DSN - You need to create one yourself using the ODBC configuration tool.
* An ODBC API in PHP language - The API is installed as part of the PHP engine.
Submitted by: Administrator
If you want to access a database server through an ODBC driver from an application program, you need to meet the following requirements:
* An ODBC driver specifically designed for the database server.
* An ODBC DSN (Data Source Name) - an ODBC configuration representing the ODBC driver and database server.
* An ODBC API (Application Programming Interface) for your application program to interact with database server through the ODBC driver.
For example, if you want to a SQL Server in a PHP script through an ODBC driver, you need to make sure that:
* An ODBC driver for MS SQL Server - The ODBC driver is installed as part of the Windows system.
* An ODBC DSN - You need to create one yourself using the ODBC configuration tool.
* An ODBC API in PHP language - The API is installed as part of the PHP engine.
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | How to download Microsoft SQL Server 2005 Express Edition? |
☺ | What Are Binary String Data Types in MS SQL Server? |
☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
☺ | How to Create a View using Data from Another View? |
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |