Can someone help a new guy?

Classic Servoy
1

Hey all – this guy emailed me (and you all KNOW I’m not the most technical person on earth… ). I told him to sign up for the forum and that I would post this. If you reply, I’ll forward your answers to him.

THANKS FRIENDS!! Brenda Duncan, Marketing Manager

We have a MS 2005 SQL sever environment, where we have tables which are containing some millions of transactions.

I though, Ok let me see if I can access the data, via servoy, and build a test environment. I did do nothing on the server side and I put the MS JDBC driver on the right folder in the mac. Then I created the DB Server ( Preferences: DB Server), and when I want to finalise the datasource it displays it can not find the right JDBC data source ( on my local machine I assume here ). I also implemented it on another MAC to see if it has different behaviour, but also there it fails, It displays error:

java.sql.SQLException: JDBC Driver ‘com.microsoft.jdbc.sqlserver.SQLServerDriver’ not found in classpath or drivers directory : java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver com.microsoft.jdbc.sqlserver.SQLServerDriver

In the documentation I did not find any resolution yet, if the problem is on the server side ( which I think it is not) or on the client side, it is a fact that my 2 machines running leopard both have this problem.

Regards,

Ron

2

Hi Ron,

First of all welcome.

There are a couple of questions to ask here:

  1. Which driver do you use?
  2. Can you give a summary of your preference settings for the db server?
  3. From what you write I assume, but just double checking, that your driver is in ${servoy root}/drivers/

Maybe this thread will also help you: http://forum.servoy.com/viewtopic.php?t … sql+driver

You can also track more forum topics by searching for ‘mssql AND driver’

Hope this helps

3

Another one that could be interesting: http://forum.servoy.com/viewtopic.php?t … sql+driver

4

  1. Make sure the JDBC driver is in the {servoy_install}/drivers folder. You can verify it is the correct driver when on the DB Connections tab in the preferences area. When looking at the connection settings, you see a drop-down of available drivers. If the driver you want isn’t in there, then it isn’t installed correctly in the drivers folder.

  2. The Microsoft JDBC driver sucks :) Use the JTDS driver instead. http://jtds.sourceforge.net/