Re: ODBC Error ?

Posted in 1999

Fuzzy — Wed, 21 Apr 1999 01:14:39 GMT — source: Informix-list mailing list archive (1991-1998)

On Wed, 14 Apr 1999 04:59:31 +0100, chris <chris@aggieb.demon.co.uk> wrote: >When I try to connect to my Informix Database using ODBC, the column >header information is retrieved but the data is not and I recieve error >messages such as: > >The specified table (administ.customer) is not in the database. > >I am using Access to either Link or Import the tables. > >Anyone had a similar problem ? > >Chris. > Sounds like you are logged in as Administrator on your client. When connecting with access, you are therefore using a default schema of administ (1999 and Informix is still not working with longer NT names!). You need to either connect as the owner of the table customer, or explicitly use the full schema.tablename method to see it. Ciao Fuzzy :-)