# SQL Server on Solaris
**URL:** https://forum.cloverdx.com/t/sql-server-on-solaris/51
**Category:** CloverDX Platform
**Created:** [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/sql-server-on-solaris/51 "2007-07-16T00:00:00Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@oldforum](https://forum.cloverdx.com/u/oldforum)
#### Post date: [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/sql-server-on-solaris/51/1 "2007-07-16T00:00:00Z")
Has anyone used Clover to connect to SQL Server from a UNIX box? I am trying to use Microsoft’s JDBC driver but I keep getting errors.
Here is my config file:
dbDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver
dbURL=jdbc:microsoft:sqlserver://#######:1433
user= \*\*\*\*
password=\*\*\*\*
defaultRowPrefetch=10
I am just trying to analyze the metadata:
java -cp cloverETL.rel-1-1-5 org.jetel.database.AnalyzeDB -config cloverETL.rel-1-1-5/cloverExamples.rel-1-1-3/db/sqlserver.cfg -q “select \* from tbl#####”
Here is the error I am getting:
[Error] Can’t load DB driver :com.microsoft.jdbc.sqlserver.SQLServerDriver
Here is my CLASSPATH:
:/home/####/msSQLjdbc/lib/mssqlserver.jar:/home/####/msSQLjdbc/lib/msbase.jar::/home/####/msSQLjdbc/lib/msutil.jar:.
This is my first attempt at Clover, so bear with me.
Any help is appreciated.
Thanks!
---
### Author:  [@oldforum](https://forum.cloverdx.com/u/oldforum)
#### Post date: [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/sql-server-on-solaris/51/2 "2007-07-16T08:23:44Z")
The problem is your classpath settings are overriden by -cp argument (see manual page for java). Either add all jar files to CLASSPATH, or set them all on command line.
---
### Author:  [@oldforum](https://forum.cloverdx.com/u/oldforum)
#### Post date: [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/sql-server-on-solaris/51/3 "2007-07-16T08:23:45Z")
Hi !
I don’t have experience with MSSQL JDBC driver, but the error message leads me following speculation:
It looks like Java can’t find the class specified as dbDriver in your classpath. You may try to put the section you described as your classpath directly to “-cp” option of java command.
Also try to look inside the jars that the class is present somewhere.
One more question - are you sure that the Microsoft JDBC driver is pure Java ? It may depend on some Windows specific dll which is probably not present on Solaris.
There should be free implementation of the protocol MS SQL and Sybase DBs use to communicate between server and client.
Have a look at [http://jtds.sourceforge.net/](http://jtds.sourceforge.net/)