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=-1.9 required=5.0 tests=BAYES_00,FREEMAIL_FROM autolearn=unavailable autolearn_force=no version=3.4.4 X-Received: by 10.182.121.39 with SMTP id lh7mr6167453obb.46.1388246376212; Sat, 28 Dec 2013 07:59:36 -0800 (PST) X-Received: by 10.49.16.168 with SMTP id h8mr675324qed.2.1388246376186; Sat, 28 Dec 2013 07:59:36 -0800 (PST) Path: eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!news.eternal-september.org!news.eternal-september.org!feeder.eternal-september.org!goblin1!goblin.stu.neva.ru!gf10no11886223igb.0!news-out.google.com!p7ni7qat.0!nntp.google.com!p15no47944480qaj.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.lang.ada Date: Sat, 28 Dec 2013 07:59:35 -0800 (PST) In-Reply-To: <8ae80e57-4c43-408b-9d99-79f879e85ee8@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=46.116.144.17; posting-account=gOkKbAoAAACKpspXTBDXeWNsiTyhFowY NNTP-Posting-Host: 46.116.144.17 References: <8ae80e57-4c43-408b-9d99-79f879e85ee8@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: porting a Gnat Ada program with ODBC code to Windows From: leonid.dulman@gmail.com Injection-Date: Sat, 28 Dec 2013 15:59:36 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Xref: news.eternal-september.org comp.lang.ada:18085 Date: 2013-12-28T07:59:35-08:00 List-Id: On Friday, December 20, 2013 5:06:44 PM UTC+2, Graham Stark wrote: > Hi, >=20 > is anyone out there successfully running a Gnat Ada program on Windows= which uses the ODBC database drivers? >=20 >=20 >=20 > I've been asked to port this big program: >=20 >=20 >=20 > https://github.com/grahamstark/wales_social_care >=20 >=20 >=20 > to a Windows server but can't get the database connections to work at all= , even on simple test programs. >=20 >=20 >=20 > I'm using the original Gnade odbc interface; I *know* there are better al= ternatives but this was originally written 3 years ago when there weren't a= nd I haven't got time to change it right now (though in retrospect I could = probably have ported it in the time I've wasted so far).=20 >=20 >=20 >=20 > I'm developing on an all 32-bit Windows 7 VM, to avoid 32/64 bit mismatch= es as far as I can. >=20 >=20 >=20 > I have Cygwin installed and have used it to build a clean version of Unix= ODBC. I've also tried the IODBC libraries that ship with Cygwin. >=20 >=20 >=20 > I get ACCESS_VIOLATION exceptions every time any of the linked to ODBC fu= nctions gets called (SQLAllocHandle and so on). >=20 >=20 >=20 > Has anyone got this to work. I just don't know my way around Cygwin and W= indows and may well be doing something dumb, >=20 >=20 >=20 > thanks (and happy Christmas) >=20 >=20 >=20 > Graham Qt5Ada supports ODBC, mySQL,OCI and SQLite database connections http://users1.jabry.com/adastudio/index.html