Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2014-09-03
6
453 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

860 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