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

[Albert G. <Dr....@t-...>]

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.)

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.

Albert

-- 
Dr. Albert Gr"af
Dept. of Music-Informatics, University of Mainz, Germany
Email:  Dr....@t-..., ag...@mu...
WWW:    http://www.musikinformatik.uni-mainz.de/ag