Skip to Content
avatar image
Former Member

DricverMangerException - Issue with JDBC and MS SQL

Hi All,

we try reach our MS SQL server but we still get the error :

DriverManagerException: Cannot establish connection to URL

'JDBC:microsoft:sqlserver://XXX.X.XX.XXX:XXXX;DataseName=AAAA;': ClassNotFoundException:

com.microsoft.jdbc.sqlserver.SQLServerDirver

What have we done:

1. We have deployed the MS SQL JDBC driver for 2000 based on the JDBC configuration how to guide

2. When we are going to the VA we can see the deployed files:

2.1. base.jar

2.2. resource.jar

2.3. sqlserver.jar

2.4. util.jar

My questions:

1. Do we have to make any entry in the IR? As far as I know the Adapter objects are deliverd with the SAP Basis 7.0 which is deployed in the IR (SPS:12)

2. Can anybody of you tell me how we can solve this problem???

Regards

Markus

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 12, 2008 at 07:27 AM

    Do we have to make any entry in the IR?

    No

    Try redeployin

    Regards,

    Prateek

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      we have depoyed the driver 2 times and also we changed the driver and deployes a driver fom a different sources.. always the same error....

      Regards

      Markus

  • avatar image
    Former Member
    May 12, 2008 at 08:02 AM

    Markus,

    It looks like there is a typo in driver's classname:

    com.microsoft.jdbc.sqlserver.SQLServerDirver

    should be

    com.microsoft.jdbc.sqlserver.SQLServerDriver (instead of Dirver)

    Depending on MSSQL release (2K or 2K5), classname is not exactly the same

    Chris

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Markus,

      My deployed JDBC MS SQL driver set contains :

      msbase.jar

      mssqlserver.jar

      msutil.jar

      Do you see them in their deployed SDA standard location /usr/sap/<SID>/DVEBMGS<SYSNO>

      /j2ee/cluster/server0/bin/ext/com.sap

      .aii.af.jmsproviderlib ?

      Chris