Link to home
Start Free TrialLog in
Avatar of SpeedsterZ28
SpeedsterZ28Flag for United States of America

asked on

ISAM Error with Teradata SQL Assistant

When using Teradata SQL Assistant, I constantly receive an error message stating the following:

"Unable to open history database--Could not find installable ISAM."

This happens when I first start up SQL Assistant, and it occurs everytime I run a query.  The issue stems from the attempt by the application to create a record of my query history in a window within the application.  This History window is useful as it records all queries you run--for easy access to frequently run queries.  The history file is an Access DB (.mdb).

In an attempt to fix the error, I've tried uninstalling and re-installing versions of Office XP and Office 97, followed by uninstallation and re-installation of just Office XP.  I've also followed the steps described in Microsoft Knowledge Base Article #283881, which did not solve the issue.

This issue began with an older version of Teradata SQL Assistant, and when I uninstalled and re-installed, that did not fix the problem.  Today, my company upgraded to version 12, and I hoped that might fix the issue, but alas, the error is still popping up and I'm without the functionality of a history file.

Any ideas or solutions would be GREATLY appreciated as this is affecting other users of the software within my department.
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

The error normally means that your Driver/Provider is not installed, or is faulty or corrupt. Does this same error occur on other machines, or just one? I have no knowledge of TeraData SQL Assistant, but it might be wise to contact them for assistance with this.
Avatar of SpeedsterZ28

ASKER

LSMConsulting,

We have a total of 12 machines with Teradata SQL Assistant installed on them, and only two of them are generating the ISAM error.  The others all function normally.

Do you think the driver issue is with Teradata's drivers or with MS Access drivers?
Probably with the Jet driver, but I'm not sure how Teradata works. In most cases, something like this would simply use whatever drivers are available on the machine. When Teradata was installed originally, I would suspect it would have looked for and (if need be) installed/updated the drivers. I'd also assume that updates/upgrades would check this as well, but I have no way of knowing this. Contact Teradata to confirm this, or to determine exactly what driver is required for their program.

The two machines where you are having trouble - what's the OS and Office version installed (if you have Office on these machines)? Do you have any other machine with an identical setup (down to the Build number of both the OS and Office) that works as expected?

LMConsulting,

The two machines with issues have the same versions of Office--Office XP, and same OS--WinXP, as every other machine.  Build numbers should be identical to the other machines that work as the same software package is installed to every machine via a single network drive.

The Teradata documentation states that the history file uses a Access 2000 .mdb, so we tried installing older versions of Access on the machines, and that still did not remedy the problem.  We have since uninstalled the older versions and re-installed Office XP.  

Is there a way I can verify that my Jet drivers are correct and up-to-date?

I suppose I will try contacting Teradata for support--just wanted to avoid going through that if possible.
Just to provide an update...

Tried to install new Data Access drivers.  This did not solve the problem.

With Teradata, in order to receive support, you have to apply for access to it and I'm in the process of waiting for our system administrator to approve this, which will probably take a while--so if anyone else has any other ideas, they would be greatly appreciated!
LSMConsulting,

Appreciate the links!  That'll keep me busy! :)

I'll be sure to update how things work out.
ASKER CERTIFIED SOLUTION
Avatar of SpeedsterZ28
SpeedsterZ28
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial