Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connection to MS SQL Server .. HELP

 
Nishant
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 265
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic