jTDS and SQLEditor

• Can I use SQLEditor with the jTDS driver?
• What limitations are there?
• Where can I get the jTDS JDBC driver from?
• How do I configure this driver?

Can I use SQLEditor with the jTDS driver?

Yes, you can, but with limitations.

We hope to improve this support in future revisions.

What limitations are there?

SQLEditor cannot currently auto-detect the driver.
It also doesn't know which dialect to use so it uses the generic one.

Where can I get the jTDS JDBC driver from?

The driver is available from the jTDS website

Then decompress if necessary and copy the jar file to the
/Library/Java/Extensions/ directory.

How do I configure this driver?

Go to the Database panel of the preferences window.

Add a new database driver by clicking the plus button below the list.

You should see the add driver panel:

Enter these details:

Driver Name: jtds driver
ClassPath: net.sourceforge.jtds.jdbc.Driver
subprotocol: jtds

Then click the Add Driver button.

The new driver should now be available in the Import from database and
Export to Database panels.