Problem : BOE-XI (R2) on AIX with DataDirect ODBC for MS-SQL

[MJRBIM]

BOE-XI (R2).
Single-Server installed on AIX.
ODBC connection to MS-SQL 2000 database using DataDirect 5.1 SQLServer Wire Protocol Driver.
CR-XI (R2) RPT content.

_________________

The CR-XI (R2) Reports run fine on the Windows desktop using the regular MS-SQL 2000 ODBC connection method.

They also run fine on a Windows BOE-XI (R2) DEVELOPMENT server using the regular MS-SQL 2000 ODBC connection method.

The TEST server for BOE-XI (R2) is running on AIX (not Windows).

We set-up the ODBC connection to the MS-SQL 2000 database using the "DataDirect 5.1 SQLServer Wire Protocol Driver" for AIX as advised by BOBJ techs.

Most of our RPTs run OK on the AIX server using that DataDirect ODBC, but about 25% run for a while then FAIL with the following error.

"The table could not be found".

All three (3) methods of running the reports - Desktop, DEV, and TEST are connecting to the same MS-SQL 2000 database using the same credentials. So it is not an account permissions problem...

I can also get the FAILING reports to run OK on the AIX server if I use JDBC connection to the DB instead of DataDirect ODBC.

My guess is that there is some setting missing on the DataDirect ODBC configuration on the AIX server, but I can't figure out what it is.

Anyone seen this before when using that DataDirect ODBC driver on AIX...?

Thanks in Advance!

 

[MJRBIM]

More details to add...

It looks like the same TABLE NAME exists in more that one schema on this database.

EXAMPLE - Table "User_Name" exists in both the "Current" and "Archive" schemas.

The Windows SQL and the JDBC drivers seem to be able to determine which schema to connect to to access the correct table, but the DataDirect driver can't figure-out which "User_Name" table to use.

Anyone seen this before...and know how to fix it?