Skip to Content
0
Former Member
Aug 01, 2006 at 07:07 AM

XI Error in configuiring external JDBC drivers for Sql server

26 Views

Hi,

We tried configuring external JDBC driver as per the configuration guide

11.1.1.2 For the JDBC Driver and the JMS Driver Add the driver to archive aii_af_jmsproviderlib.sda with the help of a zip program.

Proceed as follows: ...

1. Modify the file provider.xml from aii_af_jmsproviderlib.sda. To do this, extract provider.xml using a zip program and edit it as follows:

a. Add the line <jar-name>driver-jar</jar-name> to each jar in the <jars> section.

If you want to install the SAP DB JDBC driver and the SonicMQ JMS driver,

this section looks like this:

<jars> <jar-name>sapdbc.jar</jar-name>

<jar-name>client.jar</jar-name> </jars>

b. Return the changed provider.xml to the archive. Make sure that the original directory server\ is retained under Path in the zip archive (check for the last Path entry).

2. Add all jars (without path information) that you have defined in provider.xml to aii_af_jmsproviderlib.sda.

3. Use the SDM to deploy aii_af_jmsproviderlib.sda in standalone (offline) mode. If the empty archive was already deployed during installation, then in step 1 of the deployment choose Update deployed SDAs/SCAs that have any version. Otherwise the subsequent deployment will be terminated with the message Already been deployed. (For more information about the deployment procedure, see the SDM documentation.)

4. Restart the J2EE Server. The drivers are now known to the JMS adapter or JDBC adapter, and can be used as described.

But it doesnt seems to be working, we are getting a error as shown in the screen shot...

In adapter monitor

the error is as follows

"

<b>NAME TEXT

CC_JDBC_SND Sender Adapter V0915 fro party '', service 'BSR_JDBC':

Configured at 13:04;25 2006-07-31

processing error: accessing database connection 'jdbc:microsoft:sqlserver://

additional information : JDBC driver 'com.microsoft.jdbc.sqlserver.SQLserverDr

Available JDBC drivers

No deployed JDBC drivers found "</b>

Also the status is in red color

Kindly help us

Thanks

Gopalakrishnan M