Solved

MSAccess ODBC to Mainframe / Datacom SQL Statistics causes Datacom to crash

Posted on 2014-09-03
6
462 Views
Last Modified: 2014-11-19
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
0
Comment
Question by:mruff
  • 4
  • 2
6 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40301664
Apparently some MSAccess SQL Statistics command, when querying the MainFrame DB via ODBC crashes the Datacom server.
I'm not sure what "SQL Statistics commands" are, so I really can't help with that, but Access doesn't issue commands unless you instruct it, so there's nothing to "disable". You just wouldn't run the queries that crash the server.

If you could give more details of what you mean by "SQL Statistic commands" we might be able to help further.
0
 

Author Comment

by:mruff
ID: 40301702
Dear Scott,
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
0
 
LVL 84
ID: 40301770
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?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:mruff
ID: 40302724
Yes a new DB has the same issue. Created empty DB with just one link table to the Mainframe DATACom table - does not work.
0
 

Author Comment

by:mruff
ID: 40302902
Dear Scott,
CA has provided us a potential fix. Once applied (next week) we can re test
0
 

Author Closing Comment

by:mruff
ID: 40452101
finally upgrading the server part on the main frame solved the issue
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question