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

  1. You can either download Windows or Unix versions, it's not really what you use.
  2. 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.
  3. Add the file Microsoft SQL Server 2005 JDBC driver \ sqljdbc_1.2 \ enu \ sqljdbc.jar to your classpath (either -cp option Java or, if you are using an application server by putting it in an appropriate server).
  4. 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]]

More information and / or help directory ( help / samples / Check the available resources in the connection / ConnectURL.java sample code).


Comments

Popular posts from this blog

c# - How to capture HTTP packet with SharpPcap -

php - Multiple Select with Explode: only returns the word "Array" -

php - jQuery AJAX Post not working -