Re: ODBC Error ?
Posted in 1999
If it's looking for table administ.customer, is this in the FROM section of the SQL? FROM should only contain table names and aliases (if aliases are used.) Let's see the whole SQL statement... In article <371412A3.E5C9C4C1@aggieb.demon.co.uk>, 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. > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own