pure-odbc 64 bit issues/fixes

[Albert Graef]

Hi Jiri,

A while agao I have committed some fixes for 64 bit compatibility in
pure-odbc, which fix some compile warnings and crashes I got on 64 bit
Ubuntu. See:

http://code.google.com/p/pure-lang/source/detail?r=427173b8c648

Right now I don't have the means to test these changes on Windows,
though, so it would be very kind if you could have a look before I
release this stuff.

Many thanks in advance,
Albert

--
Dr. Albert Gr"af
Dept. of Music-Informatics, University of Mainz, Germany
Email: Dr.G...@t-online.de, a...@muwiinfa.geschichte.uni-mainz.de
WWW: http://www.musikinformatik.uni-mainz.de/ag

[Albert Graef]

On 09/05/2011 11:22 AM, Albert Graef wrote:
> A while agao I have committed some fixes for 64 bit compatibility in
> pure-odbc, which fix some compile warnings and crashes I got on 64 bit
> Ubuntu. See:
>
> http://code.google.com/p/pure-lang/source/detail?r=427173b8c648

Well, the bad news is that sqliteodbc still segfaults inside SQLExecute
on 64 bit Ubuntu when executing queries. This can be reproduced by
running 'initdb' with the menagerie.pure example, and occurs with both
the stock libsqliteodbc 0.87 on Ubuntu Natty and the latest sqliteodbc
0.91 at http://www.ch-werner.de/sqliteodbc/ compiled from source.

The same example works fine with a MySQL datasource, so I believe that
it must be a bug in sqliteodbc. Probably some 64 bit issue, as I didn't
notice this problem on my Opensuse 11.4 system (where SQLLEN is still
int, whereas it's long on Ubuntu 11.04).

It's certainly not an issue with sqlite3 itself, as Peter's native
sqlite3 module appears to work fine.

Has anyone else seen this? Any ideas?

[Albert Graef]

I finally figured this out as well. Apparently it's the old unixODBC and
sqliteodbc versions in the Ubuntu repos. They seem to be broken, at
least when used in concert. Installing the latest versions from source
fixes all of this for me (tested with unixODBC 2.3.1 and sqliteodbc
0.94, available from http://www.unixodbc.org/ and
http://www.ch-werner.de/sqliteodbc/).

As this works for me now and noone else complained, I'm going to release
this as pure-odbc 0.9 asap.

[Albert Graef]

On 03/09/2012 12:33 AM, Albert Graef wrote:
> As this works for me now and noone else complained, I'm going to release
> this as pure-odbc 0.9 asap.

Said and done. So without any ado:
http://pure-lang.googlecode.com/files/pure-odbc-0.9.tar.gz