How do I setup a Sybase JDBC connection?

Question

I'm trying to setup a Sybase connection but having trouble. I received a driver file "jtds-1.3.1.jar" from http://jtds.sourceforge.net/index.html that I added to our library folder and added the external library in System Configuration with Update. The system has been restarted also. In database connections I used the "Driver" "Custom" and tried to specify the Driver Class as net.sourceforge.jtds.jdbc.Driver (as suggested here: http://jtds.sourceforge.net/faq.html), but I get this error:

org.h2.message.DbException: Class "net.sourceforge.jtds.jdbc.Driver" not found [90086-175]

Am I missing a step? Am I specifying the Driver Class wrong?

Answer 1

I tested this on my instance. Here is the setup of the db connection:

I am getting an error that "sybasedbserver is not found". So the driver class does appear to be correct. Verify the jar is really loaded into qie:

 

Comments

I do see that jar listed in the Manage External Libraries. I think I know where I went wrong... I hit "Update" and it asked to restart, however I wasn't ready for the service to restart so I clicked no and expected it take effect after the service automatically reboots each night. Sounds like I need to explicitly tell it to restart to update, yeah?

---

the service does not restart by default at night. DO you have a process that restarts it. If not then that has not been loaded.

---

That's my understanding, but maybe I have that wrong. I'll manually restart during off hours and see if that does the trick. Thanks!

---

Restarting manually did the trick. Thanks!