From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: porting a Gnat Ada program with ODBC code to Windows
Date: Fri, 20 Dec 2013 17:46:21 +0100
Date: 2013-12-20T17:46:21+01:00 [thread overview]
Message-ID: <3xrxtz09rjlg$.8zo2rpkbh328$.dlg@40tude.net> (raw)
In-Reply-To: 8ae80e57-4c43-408b-9d99-79f879e85ee8@googlegroups.com
On Fri, 20 Dec 2013 07:06:44 -0800 (PST), Graham Stark wrote:
> is anyone out there successfully running a Gnat Ada program on Windows
> which uses the ODBC database drivers?
Yes, of course.
> I've been asked to port this big program:
>
> https://github.com/grahamstark/wales_social_care
>
> to a Windows server but can't get the database connections to work at all,
> even on simple test programs.
ODBC connectivity requires configuration of the DSN, user credentials, all
specific to the concrete DBMS and ODBC driver.
> I'm using the original Gnade odbc interface;
GNADE ODBC didn't incorporate changes MS made to the ODBC API, which were
significant. The summary is here:
http://support.microsoft.com/kb/298678
> I have Cygwin installed and have used it to build a clean version of
> UnixODBC. I've also tried the IODBC libraries that ship with Cygwin.
It is a quite strange idea to use UnixODBC instead of ODBC32 (native for
Windows). Technically, it should work if you install necessary ODBC drivers
under Cygwin (if you find them) and edit odbc.ini for your DSNs.
> I get ACCESS_VIOLATION exceptions every time any of the linked to ODBC
> functions gets called (SQLAllocHandle and so on).
AFAIK, UnixODBC honestly followed MS changes => GNADE ought to be broken
regardless the driver manager and OS you are using.
> Has anyone got this to work.
ODBC works perfectly well with Ada both under Linux and Windows.
> thanks (and happy Christmas)
Same to you.
--
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de
next prev parent reply other threads:[~2013-12-20 16:46 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2013-12-20 15:06 porting a Gnat Ada program with ODBC code to Windows Graham Stark
2013-12-20 16:46 ` Dmitry A. Kazakov [this message]
2013-12-28 15:59 ` leonid.dulman
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox