I'm attempting to use an MS SQL database as a data source in Mango M2M2. Normally to connect to SQL using a database browser I only need the servername/IP, userid and password. Mango has a couple of other properties that I'm not certain as to what needs to be entered or if additional setup is required to use SQL as a data source.
For the driver class name, I'm using the standard com.microsoft.jdbc.sqlserver.SQLServerDriver. For the connection string I have Server=10.165.3.192;Database=ExternalLog;User Id=dcstats;Password=xxxxxx;
When I start the data source, I get this error: 10:35:30: 'VISU': java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
What does the classnotfound exception mean? Am I missing something in the java setup? Thanks,