Setting up connection to IBM DB2 Database

A linked server is used by GLT to access the M3 BE database. The required settings for a linked server depend on the type of database and the selected data provider.

  1. Open Microsoft SQL server Management Studio and connect to the server where the GLT databases are located.
  2. Expand Server Objects, right click Linked Servers and select New Linked Server.
  3. Select the General Page and enter a name for the linked server.
  4. In the server type, select other data sources.
  5. From the Provider drop down menu select IBM DB2 for I IBMSASQL OLE DB Provider i
    Note: The drivers for the IBM providers can be installed from the IBM i Access for Windows install package.
  6. Enter a Product name (any character string is allowed)
  7. Enter server name or IP address of the M3 BE database as Data source.
  8. Select the Security page.
  9. Click Be made using this security context and enter Remote login and password with read access to your M3 BE database.
  10. Click OK to complete the linked server setup.
  11. Go to Server Objects, right click Linked Servers and select Providers. Open properties for IBMDASQL and verify that Allow in process is enabled.