Solved

ODBC IBM 7.1

Posted on 2013-01-11
6
692 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
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problems with GPO Printer Deployment 19 25
Access MDB/PDF 21 32
Recording mileage on a form 2 11
Multiple queries for a form 14 22
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now