Lumira-Java class not found

[moshe]

Hi,

When trying to connect a new dataset query from SQL from MSSQL2012 SAP B1 db

I get the following error:

Java class not found in classpath: com.microsoft.Jdbc.SQLServerDriver

Lumira version 1.21

Does anyone knows this error  ?

Thanks

Moshe

[shankarsgs · Accepted solution]

Hi Moshe,

You need to define the SQL drivers in the Lumira preferences. Download the latest SQL drivers from

http://www.microsoft.com/en-in/download/details.aspx?id=11774

Now go to Lumira preferences -> SQL Drivers and point to the SQL drivers you need ( 2008 or 2012 ) to the driver JAR. Restart Lumira and you would be able to connect to SQL.

Hope it helps

Shankar

[moshe · Accepted solution]

Thank you Shankar, works greate

[shankarsgs · Accepted solution]

Glad to help Moshe.

Regards

Shankar