problems with case and Access97

We are trying to export tables from MS Access97 into Informix SE. We are having the following problems: 1. If the Access table has columns with CAPITAL LETTERS in their names (for example ColumnName), then we cannot either drop or modify the column. The error we get is "Error 217: Column columnname not found in any table in the query." 2. If the Access table has CAPITAL LETTERS in its name (for example TableName), then we cannot either drop or alter the table. The error we get is "206: The specified table owner.tablename is not in the database. 111: ISAM error: no record found." Exported tables/columns with all lower case names work fine. However, we are able to create tables/columns with CAPS in their names using SQL statements in dbaccess. These tables/columns appear in lower case in dbaccess. Also, the tables and columns exported from MS Access appear in dbaccess with their original names, i.e. with capital letters (TableName/ColumnName), despite the fact that Informix is case sensitive. The problem tables are the ones imported from MS Access97. We are using OpenLink ODBC drivers. Any ideas? Thanks. Marco Greco wrote: > Greg, > table and column names are case insensitive. That aside, I > have created, > renamed, altered and dropped tables with all sorts of names with and > without > underscores and/or case mixing, and it just works fine. The only catch > would be > if you are trying to rename a table to the same name, but changing the > case of > some letters: this would not be a rename, and can't be done. > > As for the conversion from access, do you need to do anything at all? > I mean SE > will happily handle mixed case names, except that it will consider > case as > irrelevant. Of course, if you named two tables the same way, but with > different > casing, hmmmm, you have a problem, brother :-) I would suggest that > you write a > small awk script that changes table names matching one particular > pattern to > some other, and pass your schema thru it > > Ciao, > Marco > _____ > ________________________________________________________________________ > > Marco Greco <marco@informix.com> Standard > disclaimers apply! > > Informix faq > http://www.iiug.org/techinfo/faq/informix.htm > 4glworks > http://www.ctonline.it/~marcog > Informix on Linux > http://www.ctonline.it/~marcog/ifmxlinux.htm