HELP: ADO and DELIMIDENT

Posted in 1999

Bashar Chalabi — Tue, 7 Dec 1999 00:50:40 -0000 — source: Informix-list mailing list archive (1991-1998)

Hello again, Found the problem to my previous posting, about ADO generating quotation marks around identifiers in SQL statements. Platform is: IDS7.31 on NT, VB6, ADO2.1, Informix OLE-DB. I found out that setting the DELIMIDENT env variable to Y makes Informix accept the quotation marks. However, my identifiers are now case sensitive! That's a lot of code to go through. Do we really have to live with case-sensitive identifiers if we want to use ADO? Thanks for help. -- Bashar Chalabi CTL, London