Solved

ODBC IBM 7.1

Posted on 2013-01-11
6
697 Views
Last Modified: 2013-01-21
I just recently upgraded our IBM operating system from an earlier version to now version 7.1.  Everyone in the office has a Windows 7 64bit desktop and we use an ODBC connection to access iseries tables to run queries in Microsoft Access.  Since the upgrade to 7.1 it takes an extremely long time for the query to produce the information we need.  Before the upgrade when running a query it would take 2 to 3 seconds for a results, but now it takes 2 to 3 minutes.  Any ideas or suggestions?
0
Comment
Question by:RCL_Burco
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:Norm Dickinson
ID: 38769872
I would first suspect that perhaps your hardware requirements have changed signficantly with the newer OS. Perhaps more physical RAM is needed or you have run shorter on hard drive space on an array or some other system overhead is now present that was not before. Secondarily it may be a glitch in the OS that can be resolved by contacting the vendor and working with their tech support - in many cases there would already be a patch available for an issue like this, and at the worst case scenario they could probably develop one to address it or at the least provide guidance as to hardware that could be updated to speed things back up.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 38773412
what version of Access are you running?

Is the new ODBC driver 32 bit or 64 bit?
0
 

Author Comment

by:RCL_Burco
ID: 38774240
Access 2007 and the ODBC is a 64bit.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 45

Expert Comment

by:aikimark
ID: 38774538
Is your Access 64 bit?
0
 

Accepted Solution

by:
RCL_Burco earned 0 total points
ID: 38782617
I found the solution, after upgrading and installing the new Iseries Access for windows I had to delete my current ODBC connections and then recreate them.  Works much faster now.
0
 

Author Closing Comment

by:RCL_Burco
ID: 38800478
Through trail and error and looking at the IBM website this seemed to be solution to the problem.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
hit enter key to run macro 13 23
FrontEnd tools to create web database application 7 54
Inaccessible Boot Device after restore from backup image 19 63
PerfMon Report Time Out 6 22
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.

786 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