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 autolearn=unavailable autolearn_force=no version=3.4.4 X-Received: by 10.224.24.65 with SMTP id u1mr3487769qab.6.1387552004209; Fri, 20 Dec 2013 07:06:44 -0800 (PST) X-Received: by 10.49.74.134 with SMTP id t6mr97982qev.14.1387552004195; Fri, 20 Dec 2013 07:06:44 -0800 (PST) Path: border1.nntp.dca3.giganews.com!backlog4.nntp.dca3.giganews.com!border4.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!p15no35924388qaj.0!news-out.google.com!l9ni249qay.0!nntp.google.com!p15no35924381qaj.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.lang.ada Date: Fri, 20 Dec 2013 07:06:44 -0800 (PST) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=86.157.158.187; posting-account=04rmagoAAABZ9PN7u3MdbKIs6DPG57E- NNTP-Posting-Host: 86.157.158.187 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <8ae80e57-4c43-408b-9d99-79f879e85ee8@googlegroups.com> Subject: porting a Gnat Ada program with ODBC code to Windows From: Graham Stark Injection-Date: Fri, 20 Dec 2013 15:06:44 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Original-Bytes: 2261 Xref: number.nntp.dca.giganews.com comp.lang.ada:184304 Date: 2013-12-20T07:06:44-08:00 List-Id: Hi, is anyone out there successfully running a Gnat Ada program on Windows w= hich uses the ODBC database drivers? 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. I'm using the original Gnade odbc interface; I *know* there are better alte= rnatives but this was originally written 3 years ago when there weren't and= I haven't got time to change it right now (though in retrospect I could pr= obably have ported it in the time I've wasted so far).=20 I'm developing on an all 32-bit Windows 7 VM, to avoid 32/64 bit mismatches= as far as I can. I have Cygwin installed and have used it to build a clean version of UnixOD= BC. I've also tried the IODBC libraries that ship with Cygwin. I get ACCESS_VIOLATION exceptions every time any of the linked to ODBC func= tions gets called (SQLAllocHandle and so on). Has anyone got this to work. I just don't know my way around Cygwin and Win= dows and may well be doing something dumb, thanks (and happy Christmas) Graham