error in deploying JDBC driver

[Former Member]

Hi All

while deploying JDBC driver i am following tthis guide

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

while i run the command C:>drivertool add aii_af_jmsproviderlib.sda msbase.jar mssqlserver.jar msutil.jar ojdbc14.jar

i am getting this error

ERROR: could not open SDA : INVALID SDA: error while parsing provider.xml: java.io.FileNotFoundException c:library.provider.dtd (system cannot find the file specified)

can anybody give me the solution where can i find this library.provider.dtd?

how can i remove this error

Thanks

sandeep

[Former Member · Accepted solution]

Hi,

keep drivertool.bat and drivertool.jar files in the same directory and keep all your SDA and jar files in the same directory and then run the above command.............

Regards,

Rajeev Gupta

[Former Member · Accepted solution]

Hi rajeev

thanks for reply

i am doing the same but still th error is coming

[Former Member · Accepted solution]

Hi,

extract all the files in drivertool.jar and keep them in your directory where all the SDA are there........then rerun your above command for JDBC driver.

Regards,

Rajeev Gupta

[Former Member · Accepted solution]

Hi rajeev

i have put driver tool files and also .sda file and sqljdbc.jar file in c:\drive but still i am getting this error

C:\>drivertool add aii_af_jmsproviderlib.sda msbase.jar \
mssqlserver.jar msutil.jar ojdbc14.jar
SAP XI 3.0 JDBC/JMS Driver Tool. Version 1.0.1615
Copyright (C) 2005 SAP AG. All rights reserved.
Adding driver JAR(s) to aii_af_jmsproviderlib.sda:
msbase.jar - Error: jar file not found
mssqlserver.jar -  Error: jar file not found
msutil.jar -  Error: jar file not found
ojdbc14.jar - OK
Writing changes to SDA. This may take a while, so please be patient.

any suggestion?

Thanks

sandeep

[Former Member]

hi All

my problem is solved

according to congiguration guide download the driver from vendors site and Then Unzip the driver files you will find msbase.jar,mssqlserver.jar and msutility.jar .

Then copy the three jar files and add into the aii_af_jmsproviderlib.zip file.

for windows version just download the driver and inside you will find a file sqljdbc.jar and sqljdbc4.jar files

add thes files to aii_af_jmsproviderlib.zip file

make entries to provider.xml

and then deploy aii_af_jmsproviderlib.zip file using SDM

Thanks all

sandeep sharma