Saturday, 3 November 2012


11:10 pm


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

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


  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

  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

  3. Wonderful bloggers like yourself who would positively reply encouraged me to be more open and engaging in commenting.So know it's helpful.
    best GMAT coaching classes in chennai

  4. I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be subscribing to your feed and I hope you post again soon.

    Digital Marketing Company in Chennai