Hello
Where do I get the right driver to put into a Sybase database connection and where does ORQA find these drivers?
I have used the one given in the example here Accessing MSSQL DB (net.sourceforge.jtds.jdbc.Driver) and it works but I’m not clear on where it is picking that driver up from.
I already use jTDS as the driver for Squirrel SQL on this PC - is it using that?
Thanks!
Hi,
The drivers are all in the ./drivers directory (ie in the folder where you extracted your ORQA and where you have the ORQA.exe file) We bundle several drivers with the product namely:
com.springsource.jcifs-1.2.15.jar com.springsource.net.sourceforge.jtds-1.2.2.jar h2-1.3.158.jar hsqldb-2.2.8.jar
So your jTDS is already there by default.
If you wanted to use Sybase native driver, you’d just need to copy the jar into the ./drivers directory and use the appropriate classpath, connectionString etc to make it work.