Open up Databases Connectivity

ODBC or Open Database Connectivity is an open normal software programming interface applied for accessing hetrogenous datasources.

Imagine you have published various PHP plans which can make a connection to an Oracle databases. For some motive now you have decided to use MYSQL rather of Oracle. Supposing you have utilized a proprietary relationship to Oracle, then it would get a large amount of coding effort to modify every of the PHP courses to make it connect to MYSQL as it presently has connect strings to Oracle.

Now ODBC supplies seamless open up database connectivity using easy APIs to a selection of details sources this sort of as MYSQL, MS-Access, MSSQL, Oracle and so on.,Just one has to build a ODBC relationship for the specific datasource. This can be finished working with the ODBC dialog box which is available from the control panel. A person involves a ODBC driver to be put in by means of Dynamic Hyperlink Libraries. There are three types of DSNs (Info Resource Names), namely Person DSN, Method DSN and File DSN.

Soon after making certain that the driver required to hook up to a data resource is current a single wants to include the data resource by manually adding a info resource from the ODBC dialog box in the management panel. Right after including a database one particular has to configure it. The strategy to configure a database varies from a single database to a different. For instance it is different for Oracle than MS-Access as Oracle has a layer of TNS (Clear Network Substrate). In the situation of Oracle the TNS company name is required to build a ODBC connection in between client and server. In the situation of Microsoft Accessibility one particular has to just specify the community area of the entry databases and the title of the databases. The ODBC supervisor available from the management panel will get treatment of all these troubles while making an attempt to build a DSN name.

Listed here is an illustration of a PHP program connecting to a MYSQL databases by means of a DSN named as “TestDSN”.

$conn=odbc_hook up('TestDSN','','')
$sql="Decide on * FROM Worker"
$cursor =odbc_exec($conn,$sql)

1 may possibly also hook up a PHP application to a databases using a DSNLESS link. The drawback of utilizing a DSN dependent connect string in a server – customer process is that just one involves to configure the DSN or many DSNs getting utilised in the server facet scripts( these types of as PHP) on consumer pcs that or a number of shopper desktops. This is since when a shopper computer system encounters an ODBC string in a PHP system the DSN string has to be configured in the local customer. This could not be achievable to do when there are a whole lot of consumers employing these programs. In these types of scenarios one particular uses DSN Significantly less connections where the server’s IP handle /databases name, person id and password are directly mentioned in the link string.