SQL Server Connection Help

Classic Servoy
1

I am trying to connect to a SQL 2000 server through JDBC and keep getting the following error:

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

I have a CLASSPATH variable set to CLASSPATH=C:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;c:\program files\Microsoft SQL Serve
ver for JDBC\lib\msutil.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar

I know it is simple. What am I missing?

Jay

getRemainingChars.servoy (4.35 KB)

2

For all the java newbies like me…

I placed the MS JDBC msbase.jar, mssqlserver.jar, and msutil.jar files into the C:\Program Files\Servoy\drivers directory and now it works.