JDBC Receiver Adapter.

[Former Member]

Hi All,

I have closed my previous threadS.

I added my Oracle and Microsoft SQL Server Drivers JARs to aii_af_jmsproviderlib.sda and deployed back to J2EE server.

Oracle 9i and Oracle 10g:ojdbc14.jar

Microsoft SQL Server:msbase.jar, mssqlserver.jar, msutil.jar

I need tp connect to 2 database Oracle and Microsoft SQL Server using JDBC Receiver Adapter:

1. For Oracle pls tell does below data is ok ?

JDBC Driver oracle.jdbc.driver.OracleDriver

Connection jdbc:oracle:thin:@62.234.221.192:1521:AAA

where AAA -- Oracle global database name

2. For Microsoft SQL Server pls tell does below data is ok ?

JDBC Driver com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection jdbc:microsoft:sqlserver://127.0.0.1:3333;DatabaseName=Northwind

3. Does username and password means Database User Name and Database password?

4. If Orcale version is less than 9i can I still use ojdbc14.jar for Driver?

Regards

[Former Member]

hi rick,

1 and 2nd whatever u have done is right and for your

third question the user name and password refers to the database

user name and password..

not sure of the 4th

[Former Member]

Hi Rick,

For 1 and 2:

The Driver and Connection are correct.

For 3.

Yes, it is certainly the Database Username and Password.

For 4.

ojdbc14.jar is to be used when you are using the driver for JDK 1.4 or above. For Lessaer versions classes12.jar is available. You can find this information from [here.|http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_readme101020.html]

Regards,

Alka.