First, you determine if the JDBC you install is completely version, because there is a single version that can only connect to the SQL on the unit, standing about 2m, complete version 6.5m
Second, after installing JDBC, if the directory is in C: / Program Files / Microsoft SQL Server 2000 JDBC, open JBuilder, select Tools -> Configure Libraries, then select New in the list of the left, fill in: name: SQL, Location: User Home, then click Add, join the directory C: / Program Files / Microsoft SQL Server 2000 JDBC / LIB, confirm
Third, Project -> Prject Properties -> Paths -> Required Libraries -> Add
Join the User Home / SQL determination just added
Fourth, Tools -> Enterprise Setup -> Database Drivers -> Add, add USER HOME / SQL, then display SQL.config, determine, restart JBuilder in the list box after adding
V. Tools -> Database Pilot -> View -> Options -> Drivers -> Add
Fill in
Driver class: com.microsoft.jdbc.sqlserver.sqlserverdriver
SIMPLE
URL: Microsoft: SQL Server: // localhost: 1433; DatabaseName = MyBase
After confirming, Tools -> Database Pilot -> New Driver selection
com.microsoft.jdbc.sqlserver.sqlserverdriver
Fill in the URL:
Microsoft: SQLServer: // Server IP Address or Host Name: 1433; DatabaseName = Database Name, OK!
Double-click or click on the number to enter the username and password of the SQL database, complete the connection of JB and SQL!
Connection code can view Source!
