porting a Gnat Ada program with ODBC code to Windows

[Graham Stark <graham.stark@virtual-worlds.biz>]

Hi,
   is anyone out there successfully running a Gnat Ada program on Windows which 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 alternatives 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 probably have ported it in the time I've wasted so far). 

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 UnixODBC. I've also tried the IODBC libraries that ship with Cygwin.

I get ACCESS_VIOLATION exceptions every time any of the linked to ODBC functions gets called (SQLAllocHandle and so on).

Has anyone got this to work. I just don't know my way around Cygwin and Windows and may well be doing something dumb,

thanks (and happy Christmas)

Graham