File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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.
Don't get me started about those stupid light bulbs.
subject: jdbc with SQL Server
Similar Threads
Free JDBC driver for SQLServer 7?
I have a question for sql server2000 JDBC
This Weeks GiveAway: