My MFC application functions perfectly when run against SQL Server (using ODBC through CRecordset-derived classes). When I change my ODBC data source to point to Oracle, I have all sorts of problems with the SQL query strings being built wrong by MFC. It seems to mostly be that with SQL Server, it wants to use square brackets around columnn and table names, but Oracle needs quotes there. Example:
MFC generates queries like:
SELECT [account] FROM [Table1] WHERE [Balance] < 0
Oracle needs to have that query be:
SELECT "account" FROM "Table1" WHERE "Balance" < 0
Is there something I need to do to tell MFC what type of query string to produce? I've looked on MS's site and KnowledgeBase but can't seem to find this.