JDBC Sender Adpater communicatio issue

[Former Member]

Hi all,

I have deployed drivers for microsoft sql server successfully. But while connecting to database it throws an erro.

Details :

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

Connection : jdbc:sqlserver://IP:1433;databaseName=Test

When I gave admin user : SA

Following error has come :

Error while providing user as SA :

Database-level error reported by JDBC driver while executing statement 'SELECT Itemcode,Qty from demo1 where Poref = ' ''. The JDBC driver returned the following error message: 'com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'demo1'.'. For details, contact your database server vendor.

Error while providing user as USER1 :

Error during database connection to the database URL 'jdbc:sqlserver://IP;databaseName=Test' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://IP;databaseName=Test': com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'user1'.'

Please reply to resolve this issue.

Regards,

K shah

[former_member192892]

Check the database "Test" has a table named demo1 inside it. This doesnt look like a driver issue

[Former Member]

Yes Chief. Table demo1 exists in the database.

[Former Member]

Hi

Seems to be driver is not compatible.Check list of drivers (It should support jdk 1.4 as PI runs on it)

Deployment step must be followed in SDM by changing provider.xml.

rgds

srini

[Former Member]

I have deployed drivers successfully.

Problem is something else.

Regards,

K Shah

[Former Member]

Hi,

Check these links they may help you out.

To install oracle drive in XI server, just check these links,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

http://msdn2.microsoft.com/en-us/library/ms177523.aspx

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=jdbc%20with%20multiple%20tables&cat=sdn_all

Regards,

Phani