ODBC is the industry standard way to connect to SQL databases like Oracle, SQL server, Teradata etc. Net8 is an Oracle proprietary database connection protocol only works with Oracle databases. As Net8 is oracle proprietary connection protocol, it would faster in terms of access and better integrated with oracle compared to the ODBC drivers. Even the ODBC to oracle way of implementation runs over the Oracle Net8 software stack.

We need to have Net8 installed for oracle ODBC drivers. Some Multi tier applications don’t need Net8 for its’ ODBC drivers, Ex: Open link software provides Oracle ODBC drivers for multi tier applications.

We can test our ODBC connection by running the ODBCTST.EXE that comes along with your ODBC driver. Providing encryption in your ODBC increases the level of security in the method of accessing and modifying your database through the ODBC drivers.

We can also use a statement called ODBC SQLPASSTHROUGH to pass the SQL statements from the client to the database as it is without any intermediate massaging or local processing. This method increases the performance of the data processing significantly, but the resulting dynaset is not updatable via this method.

Oracle ODBC drivers are officially downloadable from the location here.

Oracle ODBC drivers are supplied by various other vendors like
• Easy soft
• Open link software - Open link software provides ODBC drivers for Oracle single tier applications and multi tier applications.
• Data direct
• Samba engine
• InterBase Software Corp

You could choose the processor type and OS type of your client specific type ODBC drivers from these vendors to download.

Related posts:

1. Get MySQL ODBC Driver MySQL provides standards based ODBC drivers for all programmers to...
2. Where can i get ODBC driver ODBC is the Open Database Connectivity software component which requires...
3. What is ODBC What is ODBC ? ODBC abbreviation for Open Database Connectivity...
4. What is JDBC JDBC is the Java owned java developed API alternative to...
5. Oracle Buys Sun Microsystems Oracle has bought Sun Microsystems for USD $5.6 Billion. The...