GeeCON Prague 2014*
The moose likes JDBC and the fly likes JDBC connection to MS SQL Server .. HELP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC connection to MS SQL Server .. HELP" Watch "JDBC connection to MS SQL Server .. HELP" New topic
Author

JDBC connection to MS SQL Server .. HELP

Nishant
Greenhorn

Joined: Sep 17, 2002
Posts: 6
Hello JAVA Whizs...
I am new to working together with JAVA and MS SQL Server.
Can anyone tell me how well JAVA goes with
MS SQL server?
What I need to do is to setup a JDBC connection from my JAVA servlet to
access MS SQL Server database.
Can anyone tell me the sample code required for
achieving my goal.
Thanks a lot,
Nishant
Graham Thorpe
Ranch Hand

Joined: Mar 25, 2002
Posts: 265
Its simple and easy too.How u connect to oracle to java same like this u can connect sql too.But u need to download ms sql driver then u can try it ..
Piyush Daiya
Ranch Hand

Joined: Jun 13, 2002
Posts: 67
Hi,

You can find the list of jdbc drivers for MS SQL server available on http://industry.java.sun.com/products/jdbc/drivers
or you can download jdbc driver from microsoft
http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xml
and for sample code
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q313100&

Hope, this helps out.
Piyush


"A scientist is not person who gives right answers but a person who asks right questions"
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"Nishant",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave
 
GeeCON Prague 2014
 
subject: JDBC connection to MS SQL Server .. HELP