SQLGetDiagRec

[jonsv]

I got a program trying to read an Access/Jet database. But I get an error about SQL:

C:\tmp>hhek2sqlite.exe -optin tom.mdb -optout tom.db
Kopierar över "DtbVer".
2020/05/17 15:42:10 SQLGetDiagRec failed: ret=-1

Is this as expected?

I tried to install mdac_typ_25.exe, assuming that the database driver were missing. But it refused to install.

The software is https://www.lysator.liu.se/~jonass/hhek2sqlite.exe from https://www.lysator.liu.se/~jonass/hhek2sqlite.html and tom.mdb is https://www.lysator.liu.se/~jonass/tom.mdb

Is this of interest so I should open a ticket in Jira or is it out of scope for ReactOS?

[jonsv]

I used a fresh install from ReactOS-0.4.13-iso.zip

[learn_more]

That depends entirely on the contents of the debug log.

[jonsv]

@learn_more: Thank you for replying!
I believe the relevant message is:
err:(dll/win32/odbc32/proxyodbc.c:538) failed to open library (null): p�"

[learn_more]

@learn_more: Thank you for replying!
I believe the relevant message is:
err:(dll/win32/odbc32/proxyodbc.c:538) failed to open library (null): p�"

That leads us to this file:
https://git.reactos.org/?p=reactos.git; ... 7ab69#l538

Which appears to be a forwarder only.
So either one needs to provide a complete SQL provider, or write it...

[Julcar]

I would recommed doing the conversion from mdb to sqlite in a windows machine, and then moving it to reactos, because weare lacking a lot of OLE interfaces for data access in the MS way, but third part software as sqlite wrappers are known to work out of the box