Unable to connect to Oracle Database

[phanikumar_akella]

I am trying file to Oracle scenario.I am not able to connect to the database.i guss my configuration details of communication channel(Receiver) are not fine.

Java Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection : jdbc:odbc:DEMO

here DEMO is a DSN Name (Microsoft ODBC Connections).

Somebody please suggest me proper Connection Parameters for Oracle...

[moorthy · Accepted solution]

HI,

Just go thru following links- migh tbe useful-

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Hope this helps.

Regards,

Moorthy

[phanikumar_akella]

Thank you

[Former Member]

Is there a specific reason why you want to use JDBC ODBC Bridge to Oracle? Oracle does have pure JDBC drivers, which work very well and don't require ODBC. (not to mention that they are generally more performant than JDBC ODBC Bridging)

The pure JDBC driver can be downloaded from Oracle according to your database version, the driver class is oracle.jdbc.driver.OracleDriver and the connection string looks like jdbc:oracle:thin:@server:port:SID.

If you want to stick to the ODBC Bridging, you should go into more detail about your problem. Do you get any detailed error message?

Regards

Christine

[Former Member]

Hi,

Check the demo for JDBC on following location.

https://www.sdn.sap.com/irj/sdn/docs?rid=/webcontent/uuid/110ff05d-0501-0010-a19d-958247c9f798#xi [original link is broken]

Thanks,

Prateek