Subject RE: [IB-Architect] SQL Dialects and ODBC
Author Leyne, Sean

-----Original Message-----
From: Jim Starkey [mailto:jas@...]
Sent: Tuesday, May 23, 2000 3:48 PM
Subject: [IB-Architect] SQL Dialects and ODBC

InterBase SQL, now old enough to drive in 45 states, originally
supported both single and double quoted literal strings. The
current SQL standard provides for single quoted literal strings
and double quoted identifier strings. This is pain, but has
to be dealt with.

What's the pain?

V6 InterBase differentiates between the two by a "sql dialect"
identifier passed in on the isc_dsql_prepare and isc_execute_immediate

The question of the hour is how the ODBC driver should interprete
SQL strings since a) existing programs use double quotes for
literals and b) new program will use double quotes for identifiers.

Personally, I don't think that the ODBC driver should not care about
existing programs (which presumably don't use ODBC for connections).
There comes a point in time when systems need to be updated to conform
to the "latest thinking", your new driver seems to be case and point.
The use of the ODBC driver should conform to the appropriate standards.
ODBC is/was intended to provide a seamless access to datasources,
accordingly, these programs need to use conforming SQL.

There isn't a good way to handle this because in a good world this
wouldn't happen. Please note that BLR was immune to this sort
of problem [sigh].

A candidate solution would be to an attribute to the driver
connect string passed through SQLDriverConnect. It would also
be configurable through the ODBC configuration mechanism,
so a system default could be established.

Does anybody have any better ideas?

Jim Starkey

Click here for savings: beMANY!

To unsubscribe from this group, send an email to: