mORMot Open Source

h.hasenack

Member

From: Nijmegen, Netherlands

Registered: 2012-08-01

Posts: 173

Website

Congratulations! 64bit mode appears to work in most parts.

Hi Arnaud

I have managed to compile the mormot in 64bit, as well as the SQLLite dll.
So I went on testing with our own unit tests in 64bit and 32bit mode.
It turns out that the SQLite3 native mode passes all tests (32bit and 64bit)
Oracle passes all tests (32bit and 64bit)
ODBC fails in bot 32bit and 64bit mode. (but COnnection is OK) (Connected to the same MSSQL DB as the OleDB connection)
MSSQL works in 32 bit mode, but fails in 64bit mode. (but COnnection is OK)

SOme of the generated errors:
TestTimedCRUD: ETestFailure
at  $0000000003DB62CF
Client.Add failed

TestAuthGuestReadData: ESQLite3Exception
at  $0000000003B815D7
SetUp FAILED: TOleDBStatement.Execute: wrong column "COLUMN_NAME" for "select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, 0 INDEX_COUNT from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA = 'TEST' and TABLE_NAME = 'UNITTESTSAMPLERECORD'"

Thank you for your hard work.

Hans Hasenack
S&G Asset Management

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,206

Website

Re: Congratulations! 64bit mode appears to work in most parts.

Yes, OleDB internal GUIDs are NOT registered in Win64!
And I do not know if OleDB can be used in 64 bit mode... I suspect Win64 is not supported by OleDB. We have to switch with ODBC.
If you have any information...

I did not check ODBC in Win64.
Did you try with other server than MS SQL?
Did you try to connect to MS SQL using ZeosLib? Since FireBird is working very well using ZeosLib in Win64, I suspect it may work also. You need to download the latest SVN version.

Yes, I'm proud of the Win64 results.
Almost no speed penalty, and full features.

If you can send me the SQlite3.dll in 64 bit mode (did you use the latest 3.16 sources from http://sqlite.org ?), it could be great.
I think we may even publish it on our web site, just like the .obj, since there is no official Win64 library released by Sqlite3 team.
Thanks!