From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-0.3 required=5.0 tests=BAYES_00,
	REPLYTO_WITHOUT_TO_CC autolearn=no autolearn_force=no version=3.4.4
X-Google-Thread: 103376,a1f6a4ae31ae12b8
X-Google-Attributes: gid103376,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: 
 g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!club-internet.fr!feedme-small.clubint.net!feeder1-1.proxad.net!proxad.net!feeder2-2.proxad.net!newsfeed.arcor.de!newsspool2.arcor-online.net!news.arcor.de.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: Question about Gnade/ODBC binding
Newsgroups: comp.lang.ada
User-Agent: 40tude_Dialog/2.0.15.1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Reply-To: mailbox@dmitry-kazakov.de
Organization: cbb software GmbH
References: <1190371069.439288.65280@50g2000hsm.googlegroups.com>
Date: Fri, 21 Sep 2007 19:44:29 +0200
Message-ID: <u3f01zlwpwk8.rt7idrlbvg36.dlg@40tude.net>
NNTP-Posting-Date: 21 Sep 2007 19:43:18 CEST
NNTP-Posting-Host: b53033bf.newsspool2.arcor-online.net
X-Trace: 
 DXC=[22C_ck<neVV0Pe9PRnbJ\A9EHlD;3YcR4Fo<]lROoRQ<`=YMgDjhgRVTa[Q2AjR=^[6LHn;2LCV^[<mhadbfdU[_he`A@PPLi[im^=dlgCklS
X-Complaints-To: usenet-abuse@arcor.de
Xref: g2news2.google.com comp.lang.ada:2067
Date: 2007-09-21T19:43:18+02:00
List-Id: <comp.lang.ada>

On Fri, 21 Sep 2007 03:37:49 -0700, Graham wrote:

> Does anyone here use the Gnade ODBC Interface?

I do.

> Integers, Floats and Strings work fine, but it would be good to know
> that I could get a full range of types supported, or know for certain
> that I can't.

You can use all SQL types declared in the package GNU.DB.SQLCLI.

Another question is in which part they are supported by the given ODBC
driver. In each case you have to ask the driver what it can. An example, of
querying support of definite you can find in simple components:

   http://www.dmitry-kazakov.de/ada/components.htm

file gnu-db-sqlcli-api.adb, function Get_Type_Info.

It boils down to issuing SQLGetTypeInfo and then looking through the result
set.

For more detailed information see MSDN documentation for SQLGetTypeInfo
function:

   http://msdn2.microsoft.com/en-us/library//ms714632.aspx

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de