Re: porting a Gnat Ada program with ODBC code to Windows

[leonid.dulman@gmail.com]

On Friday, December 20, 2013 5:06:44 PM UTC+2, Graham Stark wrote:
> 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

Qt5Ada supports ODBC, mySQL,OCI and SQLite database connections
http://users1.jabry.com/adastudio/index.html