Need help on Drivers

[Former Member]

Hello All,

My interface is File to Database. I want to interact with Oracle Database. What are drivers need to install on PI Server. How i can install the drives on PI 7.0. ? I want to know diffirence between JDBC and ODBC Drivers.

Thanks&Regards,

VenkatK

[Former Member · Accepted solution]

Hi,

please have a look here for drivers:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Difference JDBC & ODBC:

Regards

Patrick

Edited by: Patrick Koehnen on Jul 22, 2008 5:36 PM

[Former Member]

hi

JDBC = standard java interface to communicate with a database

ODBC = from Microsoft developed interface to communicate

with a database

JDBC-ODBC driver = an interface where the communication is translated from JDBC to ODBC and the communication after the driver to the database is via ODBC

ODBC is mostly used on Windows plattforms (if you want to connect with a database from C++,Delphi,etc.) , but there are also ODBC drivers for Linux available

With XI, normally we will be using pure JDBC T4 drivers only.

rgds,

Arun

[Former Member]

Hi,

For connecting the Oracle DB we need the drivers, we have 4 jdbc drivers are there in that mostly use this below driver.

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection : jdbc:odbc:Driver:<<Oracle_driver_name>>://<<host_name>>:<<port_number>>/DBname

In simple words the difference is

JDBC -

---

This is the standard java interface to communicate with a database, by using this java can connect to the database.

ODBC -

---

To communicate with a database from any language this is developed, this is for generalized thing, by using this it can connect to any database from any language.

Follow this link for more details

[former_member556603]

Hello Venkat,

Are you installed JDBC Drivers....

Go through this links,

http://searchsap.techtarget.com/tip/0,289483,sid21_gci1246926,00.html

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

Please check the driver path as mentioned below.

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//location of DB table.mdb;

No JDBC driver required.

Receiver JDBC scenario MS access -

follow this thread

SAP Note 850116 has details

Thanks,

Satya Kumar