I’m using the new C++ builder 2010 and I’m upgrading a c++ program from c++ builder 6.
I have a case sensitive data database (SQL Server 2000) using the collation SQL_Latin1_General_CP1_CS_AS
I’m moving the data components from BDE to dbExpress. Using profiler I can see that when the components query systables / get Meta data its searching for Upper case table/column names.
The command falls to return any data giving me the error SQL error code 208 which is "not found" this is what I expect since its searching for the wrong things.
Any got any ideas on how to get around this? I thought it might just be some option on the dbexpress driver but I haven’t been able to fine any. I can’t see the embercardo can have taken the view that all SQL Server databases are going to be case insensitive.