Configuring access to Microsoft SQL Server databases
To configure access to Microsoft SQL Server, you must set the ODBCINI environment variable. You must also ensure that the Microsoft SQL Server database is accessible from the Microsoft SQL Server client and test connectivity between the Microsoft SQL Server client and the Microsoft SQL Server databases.
Before you begin
- Install client libraries.
About this task
When you are connecting to a remote database, ensure that the database server is configured to allow remote connections over the TCP/IP protocol.
The Microsoft SQL Server Client cannot be installed on UNIX. Because of this, the InfoSphere® DataStage® Dynamic RDBMS plug-in stage on UNIX cannot use the Bulk Insert mode operation when the stage is configured for Microsoft SQL Server database type. The DRS plug-in stage on Windows uses the Microsoft OLE DB API for Bulk Load operations and the API is not available on UNIX. When the DRS plug-in stage is configured for Microsoft SQL Server database on UNIX, the database type for the stage is automatically switched to ODBC.
For more information about configuring access to SQL Server InfoSphere DataStage, see ../../com.ibm.swg.im.iis.conn.msole.doc/topics/sqlserverandmsole.html.