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.
Hi,
please refer to the JDBC driver and its documentation which shipped with your database. This post might help, too.
Regards
Stephan
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