hi folks.... can u ppl tell me the procedure to connect sql server with jdbc. thanx in advance
posted 13 years ago
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.