Solved

ODBC IBM 7.1

Posted on 2013-01-11
6
701 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
[X]
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
  • 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Industry Leaders: 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 you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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