Database connection with SQL Server

yubaraj · March 27th, 2007, 01:39 AM

I want to connect jsp page with database in MS SQL Server. Can anyone plz help me out with this?

I am a new to JSP.

kanoorani · May 4th, 2007, 11:20 PM

first u've 2 create a DSN of ur database in ODBC
for example the DSN name is "mydb"
now in ur JSP page, import the java.sql.* package, and then...
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:mydb");

bobit79 · May 28th, 2007, 02:19 AM

find more at
http://find more@<br /> <br /> htt.../jdbc_api.html

http://studyjava.org/forums/

iamrakesh22 · May 29th, 2007, 04:39 AM

Hi,

Quote:

quote:Originally posted by kanoorani
first u've 2 create a DSN of ur database in ODBC
for example the DSN name is "mydb"
now in ur JSP page, import the java.sql.* package, and then...
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:mydb");

You cann't use JDBC ODBC bridge at enterprise level.
Find information about how to connect to MS SQL Server using JDBC at the following URLs

http://www.akadia.com/services/sqlsrv_jdbc.html
http://www.java-tips.org/other-api-t...sing-jdbc.html
http://msdn2.microsoft.com/en-us/data/aa937724.aspx
http://support.microsoft.com/kb/313100

Regards,
Rakesh