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?
RCL_BurcoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RCL_BurcoConnect With a Mentor Author 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
 
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
RCL_BurcoAuthor Commented:
Access 2007 and the ODBC is a 64bit.
0
 
aikimarkCommented:
Is your Access 64 bit?
0
 
RCL_BurcoAuthor Commented:
Through trail and error and looking at the IBM website this seemed to be solution to the problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.