The error message return states that the StrataFrame app framework is looking for SYSTABLES. Our DBA's indicate that SYSTABLES do not exist on Mainframe versions of DB2 databases but do exist on Linux\Unix\Windows versions of the DB2 database. However, we are working with the Mainframe version of the database.

I am not sure how to get a stack trace with your code. No exeception is being thrown. The format of the connection string being used is Database=Database;User ID=ID;Password=Pwd;Server=HOST1:5022;CLISchema=XXTEST01. One of the other developers here stated that he ran into the same problem and got around the issue by removing the CLISchema=XXTEST01 from the connection string. I tried the same workaround to the issue and then receive and object not set to an instance error.

A DBA here provided more information. The error reference

XXTEST01.SYSTABLES should be

SYSIBM.SYSTABLES

I am going attempt more permutations on the connect string to attempt to work around the problem.

While you do that, I'll try to use a packet sniffer and see if it's the GetSchema() method of the DB2Connection object that's causing the problem.  If it is, I would think it would be smarter than that :|