Wednesday, March 21, 2012

how to connect jsp file with Microsoft SQL Server

Can anyone please teach me how to make a connection between jsp file and Microsoft SQL Server database steps by steps?

I'm using Windows XP and I found that my computer do not have JDBC (I already have ODBC). Is this mean that I have to install some JDBC or SQL driver in order to make the connection? Which driver should I install and where can I get the driver?

If possible, please show me some example so that I can understand better..Thanks a lot.

Regards,
san sanYes, you need to download a jdbc driver and include its jar in your classpath.

Below is a URL that demonstrates what you need to do.

http://www.akadia.com/services/sqlsrv_jdbc.html

No comments:

Post a Comment