Error deploy JDBC-Driver inside aii_af_jmsproviderlib.sda

[Former Member]

Hi guys, well i followed the 'how to install and configure external drivers for JDBC and JMS Adapters'.

I want to read and write from SQL-DB via MS Driver sqljdbc. Therefore i added infos inside the provider.xml.

I packed everything in a SDA an while trying to deploy i get following error/info:

<i>SDM has not calculated any deployment actions:Possible reasons: all selected archives have already been deployedbefore in the same or higher version</i>

My thought is to enter a higher version-number in the manifest or elsewhere manually. Can somebody help me?!

Info: i am on PI7.0 on Linux EP

br

[deviprasad_pothireddy]

Hi Carten

have you chosen the option?

"Select Update deployed SDAs/SCAs that have any version."

Regards,

Deviprasad Pothireddi.

[Former Member]

Hi Devi,

well i have no clue where to find this option in SDM! Can u give me a hand?!

br

OK found it, thx - i will report!

Message was edited by:

Carsten Heinrich

[Former Member]

Ok, deployed sucessfully but now i have problems with the CC.

I get the error in CC-Monitoring:

ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

The configuration is as follows on receiver side:

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:sqlserver://<host>:1433;databasename=COS

What might be wrong now?!

br

[prateek]

In Connection - Try DatabaseName instead of databasename

Regards,

Prateek

[Former Member]

Well ok this was my fault. But nevertheless i still get follwing error:

'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://<host>:1433;DatabaseName=COS': ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'

Stupid question: <host> should be the system which hosts the DB - right?!

Any ideas what might be wrong?! Am i using the right DB-Driver (sqljdbc)?

thx

[prateek]

<i>Stupid question: <host> should be the system which hosts the DB - right?!</i>

Yes

Have u added the Driver classes (jars - msbase.jar,mssqlserver.jar,msutil.jar) on the

JDBC Connector in Visual Administrator.

Regards,

Prateek

[Former Member]

Well actually NO. Thats because i read that they won't be needed due to the sqljdbc.jar.

But i will try but i have no Link where to find these jars!

Can u give me a hand?!

thx Prateek!!

[prateek]

See if it helps. Not sure it will

http://www.alphaworks.ibm.com/aw.nsf/reqs/jarclassfinder

Regards,

Prateek