Searching...
Saturday, 3 November 2012

ODBC With PHP

11:10 pm

ODBC With PHP

ODBC (open database connectivity) is an application programming interface(API) that allows you to connect to a data source like msaccess , oracle etc…
ODBC is vendor dependent that means for each db there will be a specific ODBC driver.
ODBC driver is a .dll(dynamic link library) file. If the php application want to work with oracle db, we need to create a DSN for oracle.
DSN stands for Data Source Name, is the reference of the db to any front end application.

Create an ODBC/DSN for Oracle :

Start -> settings -> control panal -> administrative tools -> data sources
Click on “add” button.
Select a driver for which you want to setup a datasource.
Select Microsoft ODBC for oracle or oracle for Ora ***[MSORCL32.dll/SQORA32.dll] click on finish.
Data source name :  oracledsn
Username : scott
Ok----ok

Create an ODBC/DSN for Oracle,ODBC With PHP,odbc, odbc drivers, php with odbc.
Next
This is the most recent post.
Older Post

3 comments: