on 04-09-2012 9:11 AM
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
anyone can help ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.