Skip to Content
avatar image
Former Member

SUP2.1 - MSSQL MBO error

Hi All,

I wonder to create a project by connecting using MSSQL database connection, I successfully created the MSSQL database connection in SUP2.1 and then manually create a MBO with JDBC connection, after insert the SQL Query and it show the error on following:

Error executing on back-end server: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

p/s : I'm using sqljdbc_4.0 driver for the MSSQL database connection.

Please help.

Regards,

Choong

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 11, 2012 at 12:04 PM

    anyone can help ?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2012 at 12:17 PM

    Choong

    Can you confirm that you can connect to the MS SQl DB and see the tables within the SUP WorkSpace Explorer?

    Have you the correct format connection URL such as...

    jdbc:sqlserver://localhost:1433;databaseName=pubs

    Ian

    Add comment
    10|10000 characters needed characters exceeded