[SOLVED] Cannot connect to MS SQL Server Database

Classic Servoy
1

Hi,

I run SQL Server 2000 (MSDE Development Edition). So far I’m not able to connect from Servoy. When I try, I get the following error:

"JDBC Driver ‘com.microsoft.jdbc.sqlserver.SQLServerDriver’ not found in classpath or drivers directory "

I’ve installed the MS JDBC driver, and I’ve created a CLASSPART variable in the Environment Variables. (Advanced Tab after right-clicking ‘My Computer’ and selecting ‘Properties’ in Windows 2000 Server.

I set the CLASSPATH to:

.;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar

Still I get the same error… I’m really at a loss now what could be wrong.

Cheers,
Han.

2

You don’t need anything else but to ‘throw’ the correct driver into the driver folder of your Servoy installation. That should do the trick…

3

Brilliant..!

Thanks loads!!! :D