Product specifications

3.
Add the required .jar file details to the ClassPath area. Include the fully qualified path names
when specifying these files, for example:
<Path>C:\\JDBC Drivers\\MSSQLSERVER2000\\msutil.jar</Path>
Note:
These files need to be installed on the machine running the application.
4.
Locate the Driver Capabilities parameter, and check that it is set to either Procedure,
Queries, or both.
Note:
In the last case, settings are separated by a comma.
Caution:
If it is not set to one of these values, the JDBC driver is unavailable from the connection wizard.
5.
Save and close the SBO file.
6.
Run the connection wizard.
The JDBC driver that you have configured appears in the list of available connections.
7.
Select the JDBC driver and use the wizard to configure the connection.
When you complete this task, the connection is available for use.
Related Topics
• Connection requirements
• Data access configuration files
5.3.2 JDBC SBO example file structure
This shows an example of the section of the sqlsrv.sbo file that you need to modify. This SBO file
is for Microsoft SQL Server 2000.
<DataBase Active="Yes" Name="MS SQL Server 2000">
...
<JDBCDriver>
<ClassPath>
<Path>C:\\JDBC Drivers\\MSSQLSERVER2000\\msbase.jar</Path>
<Path>C:\JDBC Drivers\MSSQLSERVER2000\\msutil.jar</Path>
<Path>C:\\JDBC Drivers\\MSSQLSERVER2000\\mssqlserver.jar</Path>
</ClassPath>
...
</JDBCDriver>
...
</DataBase>
2012-03-1551
Creating a connection