Toad World® Forums

Cross Query Editor not recognizing an Informix ODBC connection

When I try to fully qualify an Informix database the IntelliSense comes up when I start to reference it. When I select the database and server in the IntelliSense, only the server comes up in the editor. I tried running that but got an error (“Unknown database ‘prod_hp’”). ‘prod_hp’ is actually the server. I tried ‘prod_hp.database’ but that returned the error: “ERROR line 1, col 12, ending_line 1, ending_col 12, Found ‘.’, Invalid identifier:”.I would appreciate any help I can get to properly reference this in the cross connection query editor.