PHP SQL ODBC

This example illustrates how to create an ODBC Connection for php application.

PHP SQL ODBC

This example illustrates how to create an ODBC Connection for php
application.

Follow the given steps to create an ODBC connection to a MS Access Database:

Go Control Panel->Administrative Tools

Double-click on the Data Sources (ODBC) icon inside.

Select System DSN tab.

Click on Add.

Select the Microsoft Access Driver.

Click Finish.

Click Select to locate the database.

Give Data Source Name (DSN).

Click OK.

Now we can use the DSN when connecting to the database. In the given example
below, 'myodbc' is the DSN for the database. Connection from database is created
using
odbc_connect() and query "SELECT * FROM emp"
is executed using odbc_exec(). The
result is fetched using odbc_fetch_row().