I install MS SQL Driver for JDBC in C:\Program Files\Microsoft SQL
Server 2000 Driver for JDBC folder.
Then I add the CLASSPATH variable in my system :C:\Program
Files\Microsoft SQL Server 2000 Driver for
JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver
for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000
Driver for JDBC\lib\msutil.jar
Then I succeeded to compile and run a program connecting to MS SQL using
command line.
When I use Sun One Studio, it seems that it cannot recognize the
CLASSPATH I have added, and although I have mapped C:\Program
Files\Microsoft SQL Server 2000 Driver for JDBC\ to System Folder, the
program still cannot run well.
Do anybody know how to set CLASSPATH in Sun One Studio, I suspect it
doesn't use the CLASSPATH in my system environment.