Connecting to an ODBC in PHP

[sajiv]

Connecting to an ODBC

The odbc_connect() function is used to connect to an ODBC data source. The function takes four parameters: the data source name, username, password, and an optional cursor type.
The odbc_exec() function is used to execute an SQL statement.

Example
The following example creates a connection to a DSN called northwind, with no username and no password. It then creates an SQL and executes it:

Code:
$conn=odbc_connect('northwind','','');
$sql="SELECT * FROM customers";
$rs=odbc_exec($conn,$sql);