How to connect to oracle db in VC7.1.1?

[Former Member]

Hi, all.

I tried to connect to an oracle db in VC7.1.1.

I created a jdbc connecter in portal, but I don`t know how to fulfill theos fields.

Such as URL, driver class name. Can any one provide some info? Thx

Best Regards.

Louis Huang.

[Former Member · Accepted solution]

Hi Louis,

Assuming you already have the Oracle JDBC jar and that resource is already created via NWA and you only require the information asked:

Here:

What is the form of a URL?

The general form of a URL is

jdbc:oracle:<drivertype>:<username/password>@<database>

The <drivertype> is one of

thin

oci

kprb

The <username/password> is either empty or of the form

<username>/<password>

Note that a URL like

has an empty username and password whereas this URL

jdbc:oracle:thin:@mydatabase

does not specify a username and password. When using this form the username and password must be provided some other way.

More [info on|http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#05_01].

Let me know if it helped.

Good Luck,

Dharmi

[Former Member · Accepted solution]

Hi, Dharmi. I tell you what I did.

In NWA:

1. I deployed a .jar as a jdbc driver in my portal( named "oraclejdbc").

2. I added "library:oraclejdbc" into jdbcconnecter and restart.

In Portal:

3. I navigated to system landscape and created a system with jdbc template.

4. Then I config those fields:

URL:jdbc:oracle:thin:@twtpenw02:1521:TST

Class:oracle.jdbc.driver.OracleDriver

5. I also created an alias.

6. Then I made user mapping for the alias.

7. Finally I failed in connection test......>.<

I had no idea how could I correct this failure. plz help me. THX^^