I downloaded Eclipse SQL Explorer v3.5.0 for Windows (Win7) and then the "sqlexplorer_plugin-3.6.1_SR6.zip" plugins, exported the plugins to the plugins sub folder, but I cannot get the MS SQL driver to be enabled.
All I have enabled is JDBC ODBC Bridge.
Can someone tell me how to enable the MS SQL driver?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
SQL Explorer is delivered without any JDBC Drivers. So the first you have to do is to configure your drivers in the Drivers Preferences (Preferences/SQL Expolorer/JDBC Drivers). This is described shortly here: http://eclipsesql.sourceforge.net/drivers.php
1) Download the MSSql JDBC driver (http://www.microsoft.com/en-us/download/details.aspx?id=11774) or as an alternative you can use the jTDS driver (https://sourceforge.net/projects/jtds/files/)
2) Go to SQL Explorer JDBC Drivers settings and select the preconfigure Microsoft or jTDS driver. Click Edit
3) Select 'Extra ClassPath' and add the downloaded JDBC driver jar
4) Click List Drivers, In the Driver Class Name box select the correct driver class. For jTDS it is net.sourceforge.jtds.jdbc.Driver.
5) Click Ok. The driver should now be marked green in the list and is now available in the Create New Connection Profile dialog
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I downloaded Eclipse SQL Explorer v3.5.0 for Windows (Win7) and then the "sqlexplorer_plugin-3.6.1_SR6.zip" plugins, exported the plugins to the plugins sub folder, but I cannot get the MS SQL driver to be enabled.
All I have enabled is JDBC ODBC Bridge.
Can someone tell me how to enable the MS SQL driver?
SQL Explorer is delivered without any JDBC Drivers. So the first you have to do is to configure your drivers in the Drivers Preferences (Preferences/SQL Expolorer/JDBC Drivers). This is described shortly here:
http://eclipsesql.sourceforge.net/drivers.php
1) Download the MSSql JDBC driver (http://www.microsoft.com/en-us/download/details.aspx?id=11774) or as an alternative you can use the jTDS driver (https://sourceforge.net/projects/jtds/files/)
2) Go to SQL Explorer JDBC Drivers settings and select the preconfigure Microsoft or jTDS driver. Click Edit
3) Select 'Extra ClassPath' and add the downloaded JDBC driver jar
4) Click List Drivers, In the Driver Class Name box select the correct driver class. For jTDS it is net.sourceforge.jtds.jdbc.Driver.
5) Click Ok. The driver should now be marked green in the list and is now available in the Create New Connection Profile dialog
By the way. The current version of SQL Explorer is 3.6.1.