Re: [q-lang-users] ODBC connection with MS Access

[Tim H. <q...@st...>]

Albert Graef <Dr....@t-...> writes:

> Albert Graef wrote:
>> Tim Haynes wrote:
>>> Cool. The other thing you might find useful is exposing SQLGetTypeInfo() -
>>> at least so that folks can see the native type-names for use in
>>> create/alter statements.
>> 
>> Ok, I'll have a look at it.
>
> This is in cvs now (see odbc_typeinfo). I don't know how much of that
> information is actually useful or even supported on different ODBC
> implementations, but the function provides it all -- 19 different fields.
> ;-) I also added a bunch of symbolic constants (SQL_*) which should be
> useful when working with this function. (I transcribed these from the
> unixODBC headers, I hope that they are standardized so that they will
> work on all ODBC implementations.)

Excellent.

Yes, they should be reasonably standardized. You can cross-reference
against sql*.h in iODBC if really desperate.

> I also fixed up the odbc_examp.q script, it now makes use of
> SQL_IDENTIFIER_QUOTE_CHAR and thus the function which initializes the
> tables of the sample menagerie database should work with MS Access and
> other strictly ANSI-compliant RDBMSs.

Cool :)

~Tim
-- 
<http://spodzone.org.uk/>