Error on ILMT Integration

[iammanzi]

Good day We are in the process of integrating ILMT at a customer and receive the attached error. Can you advise?

[mfranz]

Hi,

Have you successfully tested your connection string before? Here are some ideas on how to do that: https://stackoverflow.com/questions/3910364/quick-ways-to-test-ole-db-connection-string

Best regards,

Markward

[iammanzi]

@mfranz - Will this work for a DB2 connection as well

[mfranz]

It should.

• The tools you can use depend on the system/OS you are on.
• The connection itself is standardized, or there might be minor differences on what connection strings different systems will accept.
• The actual content (e.g. SQL query) will  definitely need to be specific to the type of system you connect to (DB2 vs. Oracle vs. MSSQL).

If these testing methods fail, it is likely that your connection string is the problem. In such cases you could try to google for specific system's connection string syntax, e.g.: https://www.c-sharpcorner.com/uploadfile/nipuntomar/connection-strings-for-ibm-db2/

Best regards,

Markward

[iammanzi]

@mfranz -Ok, i think the issue is IBM OLE  DB Provider for DB2 drivers issue. Do you know where we can download it from?

[ChrisG]

The What Is an Inventory Beacon? > Prerequisites for Inventory Beacons online help topic may help if you are unsure about OLE drivers for DB2. This topic suggests:

Depending on your environment and requirements, either of the following is appropriate:

• Microsoft OLE DB Provider for DB2 Version 2.0 or later. For example, you may already have version 3 of the Microsoft OLE DB Provider which is supplied as part of the Microsoft SQL Server 2008 RS Feature Pack, or you can download it from http://go.microsoft.com/fwlink/?LinkID=188403&clcid=0x409. Be aware that this driver may require that you license Microsoft SQL Server on the inventory beacon, so this option is useful only in particular circumstances.
• The OLE DB driver in the IBM Data Server Driver Package, which you can find thus:
  1. Start from http://www-01.ibm.com/support/docview.wss?uid=swg27007053, and in the DB2 Fix Packs section, click your preferred Fix Pack for the release of DB2 you have installed.
  2. Scroll down the Support page that appears, to the Download fix pack images per operating system section.
  3. As well as matching the operating system of your inventory beacon, be sure to match the platform: a 64-bit driver on a 64-bit platform, or a 32-bit driver on a 32-bit platform. Clicking the + above the appropriate headline expands additional links for that operating system and platform.

[iammanzi]

@ChrisG , @mfranz 

I have installed the Microsoft OLE DB Provider for DB2 to connect to the ILMT DB2 Database. But i still receive the same error.

This is the connection string:

Provider=DB2OLEDB;Password=32NpR&k^8-9M:nU*;Persist Security Info=True;User ID=ana\svc_flexera_ilmt;Data Source=TEMADB;Location=yyzilm1002:50000;Extended Properties=""

Am i missing anything?

[mfranz]

Hi,

Have you tried just saving the connection and then importing from it? The "test connection" function is somewhat problematic at times.

Also you could try to leave out unnecessary options from your connection string. For example, you don't seem to use any "Extended Properties", so why not leave that part out.

Best regards,

Markward

[ppuddick · Accepted solution]

https://www-945.ibm.com/support/fixcentral/swg/selectFixes?source=dbluesearch&product=ibm%2FInformation+Management%2FIBM+Data+Server+Client+Packages&release=11.1.*&platform=Windows+64-bit,+x86&searchtype=fix&fixids=*rtcl*FP003&function=fixId&parent=ibm/Information%20Management

Please make sure you select the top option (number1: IBM Data Server Runtime Client)