Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Developer's Guide

- Previous: Sun Java System JDBC Driver for Oracle 8.1.7 and 9.x Databases
- Next: Sun Java System JDBC Driver for Sybase Databases

## Sun Java System JDBC Driver for Microsoft SQL Server Databases

The JAR files for this driver are `smbase.jar`, `smsqlserver.jar`, and `smutil.jar`. Configure the connection pool using the following settings:

- Name: Use this name when you configure the JDBC resource later.

- Resource Type: Specify the appropriate value.

- Database Vendor: `mssql`

- DataSource Classname: `com.sun.sql.jdbcx.sqlserver.SQLServerDataSource`

- Properties:

  - `serverName` - Specify the host name or IP address and the port of the database server.

  - `portNumber` - Specify the port number of the database server.

  - `user` - Set as appropriate.

  - `password` - Set as appropriate.

  - `selectMethod` - Set to `cursor`.

- URL: `jdbc:sun:sqlserver://`serverName`[:`portNumber`]`

- Previous: Sun Java System JDBC Driver for Oracle 8.1.7 and 9.x Databases
- Next: Sun Java System JDBC Driver for Sybase Databases

- © 2010, Oracle Corporation and/or its affiliates