IBM Support

The Microsoft Jet database engine cannot find the input table or query 'Agency'.

Troubleshooting


Problem

The Microsoft Jet database engine cannot find the input table or query 'Agency'.

Symptom

       
  • Gentran:Director for Windows, Release 5.4 
    •    
  • Windows XP SP2
    •    
  • Cannot create a new Application Integration map
    •    
  • Start > Programs > Commerce Connection32 > Gentran Director Application Integration > File > New   produces a Microsoft Jet database error.
    •    
  • The User DSN tab of the ODBC Data Source Administrator window does have a data source named "GENTRAN Standards" 
    •    
  • The GENTRAN Standards data source is using STANDARD.MDB as its database
    •    
  • The value of the LastODBCDSN register key contains a value other than GENTRAN Standards
Error Message

GENTRAN:Director - Application Integration:  The Microsoft Jet database engine cannot find the input table or query 'Agency'. Make sure it exists and that its name is spelled correctly.

Cause: The value of the LastODBCDSN register key contains a value other than GENTRAN Standards

[{"Product":{"code":"SS6UP7","label":"Sterling Gentran:Director"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

TRB1664

Document Information

More support for:
Sterling Gentran:Director

Software version:
All

Document number:
193275

Modified date:
11 February 2020

UID

swg21561497

Manage My Notification Subscriptions

Page Feedback