Thorsten Mauch wrote: > > Hi all > I use sapdb 7.4.30 with the current ODBC driver. > I transferred a MSSQL database to SQLDB using the MS Transfer > manger. I > found that all table names are created in lowercase. > Following ODBC queries seek for the uppercase tables, so a > table not found > exception is > thrown. > Can i adjust the ODBC driver to ignore case ? or can enforce the table > creation in upper letters > > Thx Thorsten
Creation of a table with lower-case name can only happen if the name is enclosed in double-quotes like create table "mylowertable" (....) I am not familiar with MS Transfer manager, but if there is an intermediate file produced with the create table-statements in, you should edit it and try to get rid of the " around the names. Of course you should check the columnnames, names of indexes.... as well. Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
