JBuilder JDBC Connectivity to Microsoft SQL Server(1)
1-First of all, you need to download Microsoft JDBC driver:
Then try to install the downloaded driver. After installing the driver you should declare the driver in JBuilder.
2)Select Enterprise Setup from JBuilder menu and the go to Database Drivers tab. Select Add and then New. Now select the path of your driver("C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC").
After adding your driver and selecting a name for library the Enterprise Setup should be look like this:
3)Now Select Tools->Database Pilot. Then choose View->Options and go to Drivers page. Now select Add to specify your driver. Enter following string in the Specify New Driver dialog:
Now close the dialog and select File->New from Database Pilot main menu. Your driver should be listed in New URL dialog and it should not be red. If it is red you may mad a mistake in one of the steps covered.
After selecting Microsoft Driver enter the following code as URL:
4)Now test your connectivity by selecting File->Open and entering username and password of your database.