Classpath for MSSQLServer JDBC Driver
Classpath for MSSQLServer JDBC Driver
- Subject: Classpath for MSSQLServer JDBC Driver
- From: "Jonathan Fleming" <email@hidden>
- Date: Thu, 22 May 2003 20:40:36 +0100
I've installed MS SQL Server 2000 and have the JDBC .jar files that need to
be used in classpath, since I am using WO5.2 can I simply copy these into
the C:\Apple\Local\Library\WebObjects\Extensions directory?
The documentation says: Set your system CLASSPATH to include the following
entries,
where install_dir is the path to your SQL Server 2000 Driver for
JDBC installation directory:
install_dir/lib/msbase.jar
install_dir/lib/msutil.jar
install_dir/lib/mssqlserver.jar
I'm using Windows 2000, this is the Windows Example
CLASSPATH=.;c:\Microsoft SQL Server 2000 Driver for
JDBC\lib\msbase.jar;c:\Microsoft SQL Server 2000 Driver for
JDBC\lib\msutil.jar;c:\Microsoft SQL Server 2000 Driver for JDBC
\lib\mssqlserver.jar
Just conforming. Once this is done I should be able to connect using my
EOModel with something like this:
jdbc:microsoft:sqlserver://server_name:1433
For example, to specify a connection URL that includes the user
ID "username" and the password "secret":
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://server1:1433","username","secret");
Thanks for any help
Jonathan
_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today!
http://www.msn.co.uk/messenger
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.