on 09-19-2008 3:49 AM
Hi ,
Good morning,
Integrating File to Oracle system , I got connection parameters & JDBC drivers , i configured and checked the data is not going to the receiver database.how can i know the format of the oracle drivers.points will be appreciated.
regards,
stephen
Follow below blog
Connection parameter & jdbc drivers changes
connection string : jdbc:oracle:oci8:userid/password@server
Note that this connection string is only if you use the Oracle OCI driver. The OCI driver requires a shared library or DLL on the server.
The thin driver for Oracle is more commonly used as it doesn't require any additional libraries. The connection string is as already listed above:
jdbc.oracle.thin:@server:port:SID
Follow this link
For all type of Jdbc drivers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
[/thread/748572 [original link is broken];
chk it out.
Regards.
Siddhesh Naik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
user name: <Oracle database user>
password: <Password>
driver: oracle.jdbc.driver.OracleDriver
url:jdbc:oracle:thin:@<ServerHost(IP)>:1521:<SID>
where SID is Oracle database server's name
if any problem let me know.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.