cancel
Showing results for 
Search instead for 
Did you mean: 

SUP2.1 - MSSQL MBO error

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

anyone can help ?

Ian_Thain
Developer Advocate
Developer Advocate
0 Kudos

Choong

Check this out... http://dcx.sybase.com/sup0211/en/com.sybase.infocenter.dc01283.0211/doc/html/asc1229701207667.html

Though it suggests using the 3.0 driver

Ian

Former Member
0 Kudos

Ian,

Thanks for your reference, my problem is cause from the wrong directory of sqljdbc4.jar, problem solve after paste the jar file to com.sybase.uep.com.sqlserver directory.

Thank you.

Choong

Ian_Thain
Developer Advocate
Developer Advocate
0 Kudos

You're most welcome

Ian

Answers (1)

Answers (1)

Ian_Thain
Developer Advocate
Developer Advocate
0 Kudos

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