File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes jdbc with SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc with SQL Server" Watch "jdbc with SQL Server" New topic

jdbc with SQL Server

sumit malik

Joined: Oct 31, 2001
Posts: 21
hi folks....
can u ppl tell me the procedure to connect sql server with jdbc.
thanx in advance
Philip Shanks
Ranch Hand

Joined: Oct 15, 2002
Posts: 189
This is pretty well documented, so I won't go into details. Basically you have a couple of choices, depending on the platform that your application is hosted on.
If you are running on a Windows platform:
1) Create a system DSN pointed at the SQL Server instance and target database.
2) Use the jdbcdbc bridge that comes with your J2SDK.
Or, download a JDBC driver for SQL Server (you can get this from a variety of sources -- I got one from Microsoft), and use that to access the SQL Server via TCP/IP. This is a relatively platform-independent method (preferred).
I don't know about the relative performance of these two approaches, but I would guess that the latter is more efficient.
I agree. Here's the link:
subject: jdbc with SQL Server
jQuery in Action, 3rd edition