This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to configure DB2 Provider so that it gets loaded in Provider list in the synchronization editor?

I've installed DB2 driver on my job server for D1IM7, where i am supposed to configure DB2 synchronization. however provider is not being listed in the provider list in synchronization editor. Any help will be appreciated.

0 Markus Weiss-Ehlers over 7 years ago

Where do you run the Synchronization Editor, on the Job Server or on a different machine?
Cancel
Up 0 Down

Cancel
0 kavita.digari over 7 years ago

i'm running Synchronization Editor on Job server. It's the same server where i've installed the DB2 driver.
Cancel
Up 0 Down

Cancel
0 Markus Weiss-Ehlers over 7 years ago

So which DB2 driver have you installed? Only DB2 LUW is supported.
Did you restart Synchronization Editor after installing the driver?
Cancel
Up 0 Down

Cancel
0 kavita.digari over 7 years ago

DB2 ODBC driver for Windows. I can see it in ODBC Datasource Administrator. I've restarted Synchronization editor. still provider is not available in it.
Cancel
Up 0 Down

Cancel
0 George Cerbone over 7 years ago

One thought: make sure the processer architecture matches. I.E. Make sure you are installing 64-bit drivers.
Cancel
Up 0 Down

Cancel
0 kavita.digari over 7 years ago

yeah, my server is 64-bit and driver is also for 64-bit
Cancel
Up 0 Down

Cancel
0 Markus Weiss-Ehlers over 7 years ago

Wrong driver architecture. As .NET application OneIM is using the ADO.NET driver of course and not the ODBC one.
Cancel
Up 0 Down

Cancel
0 kavita.digari over 7 years ago

i've installed ADO.NET driver as well. still no luck.
Cancel
Up 0 Down

Cancel
0 Markus Weiss-Ehlers over 7 years ago

Which version did you install? Is your DB2 a LUW system or host based?
Cancel
Up 0 Down

Cancel
0 kavita.digari over 7 years ago

v11.1.2fp2_adonet_driver.zip. As far as i know, our DB2 is an LUW system. I am not sure if the driver version is correct or not.
Cancel
Up 0 Down

Cancel