java - database connectivity? -
How to install SQL 2005 database connectivity with Java application I do not really know how to set the path for JDBC . Any help would be great. Download jdbc driver from
- You can either download Windows or Unix versions, it's not really what you use.
- If you select the Windows version, run the downloaded exe file; This will create a directory called Microsoft SQL Server 2005 JDBC Driver in that directory that you downloaded the file.
- Add the file
Microsoft SQL Server 2005 JDBC driver \ sqljdbc_1.2 \ enu \ sqljdbc.jar
to your classpath (either-cp
optionJava
or, if you are using an application server by putting it in an appropriate server). - Setting Your Connection In fact, the required information is as follows:
- Driver class name:
com.microsoft.sqlserver.jdbc.SQLServerDriver
< / Li> - Connection URL:
Jdbc: sqlserver: // [serverName [\ instanceName] [: portNumber]] [; Property = value [; Property = value]]
- Driver class name:
More information and / or help
directory ( help / samples / Check the available resources in the connection / ConnectURL.java
sample code).
Comments
Post a Comment