Question about using sqljdbc.jar to connect MS SQL

[RYAN1214]

hello, I don't know how to config sqljdbc driver...i use netbeans IDE 5.5 to construct my JSP page, i want use this driver to make a login checking function in my website. So that I want to gather information for the verification. I don't know how to set the "database URL" and the port number is 1433? Beisdes that, do I need set "Environmen tal Variables"...if it is needed, how to set the path? And my MS SQL does not have a "Microsoft SQL Server 2005 JDBC Driver" folder...Do I need install something in order to get this folder?

please help me....thank you very much!

[acoder]

This will be better answered in the Java forum. I'll move this there.

[RYAN1214]

Can anyone help me?

[sicarie]

Can anyone help me?

You need to add the jdbc.jar to either the project or your classpath. Then create a connection, prepare a statement, and either get a resultset or do whatever you need to do - updateQuery() etc...