Error message: Ambiguous column (<column_name>). (-324)

If you encounter the Informix-specific "Ambiguous column" errors, take the following action:

1. Make sure the problem query executes successfully in the Informix native dbaccess program.
   
2. Place backslashes in front of any underscores that appear in the query, to escape those underscores.
   
3. Use pass-through queries with fully qualified field names when Microsoft Access is involved.
   
4. If using Multi-Tier, make the following change to the Broker Rulebook and test:
   
   1. Log in to the computer that hosts your OpenLink server components.
      
   2. Open the active Rulebook (e.g., oplrqb.ini) in a text editor.
      
   3. Locate the relevant [Environment ___] section that corresponds to the acgtive database agent, e.g., [Environment INFORMIX2000].
      
   4. Set the following parameter: DELIMIDENT = Y
      
   5. Save your changes and exit the file.
      
   6. Restart your Request Broker.

Other known possible causes of this problem include the use of ADO or Microsoft Access '97.