JDBC adapter problem

[Former Member]

hi,

I am using JDBC adapter at the recieving end. and I am gettting the following error. can someone help me pls..

2006-10-18 10:20:22 EDT: Error: Accessing database connection 'jdbc:microsoft:sqlserver://147.185.68.100:1433;databaseName=SAPPOC' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://147.185.68.100:1433;databaseName=SAPPOC': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

thank you

[former_member206604 · Accepted solution]

Hi,

Sure your JDBC driver is deployed? Check if it is deployed properly.

Regards,

Prakash

[Former Member · Accepted solution]

hi Prakash,

Can you guide me how to deploy or test.

thank you

[former_member206604 · Accepted solution]

Hi Kumar,

http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000591425&_OBJECT=011000358700001697502004E

check out the link and this config guide has stpes to deploy it. You need to hace Service market place user ID

Regards,

Prakash

[Former Member · Accepted solution]

Thank you Prakash,

I got that config guide. I need to deploy MSSQl Server 2005 driver for Xi 3.0. Should I just follow the steps from the guide?I am sry I never did this before.

thank you

[former_member206604 · Accepted solution]

Hi,

Yes you need to follow the guide. If you have technology consultant just ask them to do it. If you can do it you will learn something for sure..

Regards,

Prakash

[former_member187339]

Hi,

Check whether yoour DB is up and running .. also check the DB port and drivers.

Hope you have deployed these drivers correctly:

https://websmp202.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDrivers.zip

Regards

Suraj