Re: Tablename qualifiers in ODBC

Alejandro Dunno if this will help but you may try: select * from "alex".customers HTH Sujit ______________________________ Reply Separator _________________________________ Subject: Tablename qualifiers in ODBC Author: "Alejandro Alberola Arias" <alberola@bio.es> at Internet Date: 10/23/1998 8:22 PM Hello, I have a table named customers and an user named alex. If I execute the following statement from the SQL Editor, it doesn't work: select * from alex.customers I suppose that IDS don't support tablename qualifiers. But when I run Windows applications using ODBC (Openlink ODBC or Intersolv ODBC) they use statements like the former. And of course they don't work properly and I get an error like this: "The specified table (alex.customers) is not in the database" How can I configure the ODBCs or IDS to avoid this ? Thanks in advance. Alejandro Alberola alberola@bio.es