Profile picture for user tina.li

We have a problem about the jdbc driver to access SQL Server 2000 from mashzone.  We tried both sqljdbc4.jar and sqljdbc.jar.  With sqljdbc.jar, the error message indicates that we need to put sqljdbc4.jar.  With sqljdbc4.jar, the error is "SQL Server version 8 is not supported by this driver".  The driver name is "com.microsoft.sqlserver.jdbc.SQLServerDriver".

Your support and time is appreciated.

by Stephan Freudl
Posted on Fri, 12/09/2011 - 11:11

Hi,

please refer to the JDBC driver and its documentation which shipped with your database. This post might help, too.

Regards

Stephan

0
by Marko Gudelj
Posted on Fri, 12/09/2011 - 13:00

Hello Tina,

Please find the link below where you can find jdbc drivers for SQL 2000.

There you will find two package of SQL drivers...

1) sqljdbc4.jar -  just copy this driver into the folder "\installationa of MashZone\jadcdrivers" and after that please restart MashZonz servise. After this sql driver should be visible in the configuration window... Please configure it like this:

 

2) Secound package is consist of three drivers "Msbase.jar", "mssqlserver.jar" and "msutil.jar" you need to add all of these drivers into the folder  "\installationa of MashZone\jadcdrivers" and take the same procedure as the first driver, just be careful  with Database URL which is different, please take a look on the picture:

 

I tested personally both ways and I can certify that it works! :-) 

 

I get warning that redistribution of MS JDBC Drivers could be prohibited in some way, so I need to remove uploaded drivers and point you to some official microsoft pages:

http://support.microsoft.com/kb/313100

I think that you can find those drivers on page:

http://www.microsoft.com/download/en/details.aspx?id=1511

 

Link for the jdbc drivers: Sorry :-)

 

Good Luck!

Marko Gudelj

0
by Tina Li Author
Posted on Wed, 01/04/2012 - 15:55

Thank you!

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock