Use the New Database Connection wizard or pages that are embedded
in other wizards to create a JDBC connection to Microsoft® SQL Server.
The following JDBC drivers are supported for Microsoft SQL
Server:
- Microsoft SQL
Server 2000 Driver for JDBC
- Microsoft SQLServer
2005 Driver for JDBC
- IBM® WebSphere® SequeLink
JDBC Driver
- IBM WebSphere Connect
JDBC Driver
- Microsoft SQL
Server 2000 Driver for JDBC
The Microsoft SQL Server 2000 Driver for JDBC is included
with MS SQL Server 2000. This is licensed software that you must purchase
from Microsoft.
You
can download the JDBC driver Microsoft SQL Server 2000 Driver for
JDBC from www.microsoft.com/sql.
- Microsoft SQLServer
2005 Driver for JDBC
- You can download this JDBC driver from Microsoft.
The IBM WebSphere SequeLink
JDBC Driver and the IBM WebSphere Connect JDBC Driver are included with
this product. For more information about setup and restrictions for these
JDBC drivers, see the JDBC provider summary topic in the Websphere Application
Server information center.
To retrieve tables that you do not own, you
must have database role membership in the roles 'public' and 'db_datareader'.
To
change the database role membership:
- Start the Microsoft SQL Server Enterprise Manager.
- Under the Console Root, open the Users folder under
the database that you are working with. A list of users for this database
is shown in the right hand pane.
- Right-click on the user that you want to change, and click Properties.
- Select the appropriate database role memberships in the list:
- db_datareader
- Read access
- db_datawriter
- Insert, update, and delete access
- db_ddladmin
- Table and view delete access
- Click OK.