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

5 comments:


  1. It is really very excellent,i find all articles was amazing.awesome way to get exert tips from everyone,not only i like that post all peoples like that post,because of all given information was wonderful and it's very helpful for me.
    Dotnet training in Chennai

    ReplyDelete
  2. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.

    Branding Services in Chennai

    ReplyDelete