tag:blogger.com,1999:blog-7531015724450253542.post5703643407857018598..comments2023-10-18T02:06:33.874-07:00Comments on Very Busy Developer Notes: Table Adapters invalid and cannot be generated after altering ODBC Firebird databaseUnknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7531015724450253542.post-90910382722220681572010-09-27T06:37:52.526-07:002010-09-27T06:37:52.526-07:00Did you define the DB as SQL dialect 3? If you do ...Did you define the DB as SQL dialect 3? If you do it as dialect 1 you don't have case sensitivity issues with FB in my experience.<br /><br />I'm a long time IB/FB user but sometimes I need to use that OTHER DBMS. My migration to MySQL running on Linux (prod) vs MySQL running on Windows (dev) also caused some confusion, as Linux is case sensitive, and that seemed to translate to table names as well. I suppose this can be configured, but it can be a pain when deploying to production. My habit these days is to define table names as lowercase.<br /><br />I guess your FB installation is on Windows? I don't know whether it'll really make a difference; it has been a number of years since I deployed a FB instance on anything other than Windoze.Donald Klopperhttps://www.blogger.com/profile/15355608247498667760noreply@blogger.com