Anyone used MS SQL Server with a DB2 database (mine is an ERP app called Infinium)
Hello there,
My company owns MS Reporting Services and I am trying to find out if anyone has had success connecting it to a DB2 system for reporting? My specific system is an HR/ERP called Infinium. I've had trouble getting ODBC connections into it from any other application except one called Strategy (a querying app), but I don't know if that is specific to my application or to DB2.
Thanks for any information you have.
My company owns MS Reporting Services and I am trying to find out if anyone has had success connecting it to a DB2 system for reporting? My specific system is an HR/ERP called Infinium. I've had trouble getting ODBC connections into it from any other application except one called Strategy (a querying app), but I don't know if that is specific to my application or to DB2.
Thanks for any information you have.
richard_crist
I have connected my PC applications to our DB2 database here at work. We have iSeries Navigator software which includes an ODBC driver for DB2. That driver is used to create system DSNs which can then be used for the ODBC connection. I also have a Java based database software that uses a Java ODBC driver. That application is also able to connect successfully to db2.
ASKER
Hi Richard! Thanks for this information.
I have found iSeries Navigator installed on my PC and I've spent a little time in it. it is strange, I am able to query against a file from inside the navigator (called hrdbfa.prpms) but cannot find it through the navigator browser anywhere - any tips on how to locate a file (search or find functions) so I can see its properties inside Navigator?
I created an iSeries ODBC system DSN odbc connection and attempted to link into the tables (through MS Access Linked Tables). I was able to connect to one file, but the other one gave me an error referencing "too many indexes" and failed to connect. Have you ever had that error before and if so were you able to resolve it? I'm not even sure where to see indexes or keys on the file structures (my sys admin refers to this as a "file" and not a "table" - when I look in the INDEXES section in iSeries Navigator nothing is displayed).
I have found iSeries Navigator installed on my PC and I've spent a little time in it. it is strange, I am able to query against a file from inside the navigator (called hrdbfa.prpms) but cannot find it through the navigator browser anywhere - any tips on how to locate a file (search or find functions) so I can see its properties inside Navigator?
I created an iSeries ODBC system DSN odbc connection and attempted to link into the tables (through MS Access Linked Tables). I was able to connect to one file, but the other one gave me an error referencing "too many indexes" and failed to connect. Have you ever had that error before and if so were you able to resolve it? I'm not even sure where to see indexes or keys on the file structures (my sys admin refers to this as a "file" and not a "table" - when I look in the INDEXES section in iSeries Navigator nothing is displayed).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Richard!!! the PRPMS is a physical file, we found with no keyed fields at all (so perhaps it thought it was a file with 200 indices!). I asked our admin about this and she told me to try PRLMS which is a logical view with two keyed fields. It linked into Access with no issue!!
Thanks so much.
Lin
Thanks so much.
Lin
ASKER
Much thanks, Richard!