[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 711
  • Last Modified:

ODBC IBM 7.1

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
RCL_Burco
Asked:
RCL_Burco
  • 3
  • 2
1 Solution
 
Norm DickinsonGuruCommented:
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
 
aikimarkCommented:
what version of Access are you running?

Is the new ODBC driver 32 bit or 64 bit?
0
 
RCL_BurcoAuthor Commented:
Access 2007 and the ODBC is a 64bit.
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
aikimarkCommented:
Is your Access 64 bit?
0
 
RCL_BurcoAuthor Commented:
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
 
RCL_BurcoAuthor Commented:
Through trail and error and looking at the IBM website this seemed to be solution to the problem.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now