mruff
asked on
MSAccess ODBC to Mainframe / Datacom SQL Statistics causes Datacom to crash
Dear experts.
I am connecting via a ODBC connection to a IBM Mainframe Datacom server.
Now the problem is, that the Datacom server is not the most recent version. Updating unfortunately is not an option.
Although a fix: RO40776 exists
Apparently some MSAccess SQL Statistics command, when querying the MainFrame DB via ODBC crashes the Datacom server.
ANY Idea how I can disable those MSAccess SQL Statistic commands?
Many thanks for your help
I am connecting via a ODBC connection to a IBM Mainframe Datacom server.
Now the problem is, that the Datacom server is not the most recent version. Updating unfortunately is not an option.
Although a fix: RO40776 exists
Apparently some MSAccess SQL Statistics command, when querying the MainFrame DB via ODBC crashes the Datacom server.
ANY Idea how I can disable those MSAccess SQL Statistic commands?
Many thanks for your help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I double clicked on a linked table to view the data this lead to an odbc error (the error code was wrong, indicating I do not have access to the server, which was wrong since I can access the same server/same Db/same table via the same odbc without problems with winsql and do a select * from this table, which crashes the server when done from MSAccss)May not be wrong, sincd WinSQL may be using a completely different driver.
If you create a NEW Access database, and create NEW links to the server, do you have the same issue?
ASKER
Yes a new DB has the same issue. Created empty DB with just one link table to the Mainframe DATACom table - does not work.
ASKER
Dear Scott,
CA has provided us a potential fix. Once applied (next week) we can re test
CA has provided us a potential fix. Once applied (next week) we can re test
ASKER
finally upgrading the server part on the main frame solved the issue
ASKER
no unfortunately not since I do not have access to this server and got the info from a colleague
What I did I double clicked on a linked table to view the data this lead to an odbc error (the error code was wrong, indicating I do not have access to the server, which was wrong since I can access the same server/same Db/same table via the same odbc without problems with winsql and do a select * from this table, which crashes the server when done from MSAccss)
probably the known DataCom Server fix RO40776 could help - did not have time to google it yet