Page 1 of 1

SQLGetDiagRec

Posted: Sun May 17, 2020 3:23 pm
by 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?

Re: SQLGetDiagRec

Posted: Sun May 17, 2020 4:00 pm
by jonsv
I used a fresh install from ReactOS-0.4.13-iso.zip

Re: SQLGetDiagRec

Posted: Sun May 17, 2020 5:55 pm
by learn_more
That depends entirely on the contents of the debug log.

Re: SQLGetDiagRec

Posted: Sun May 17, 2020 6:19 pm
by 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�"

Re: SQLGetDiagRec

Posted: Mon May 18, 2020 9:02 pm
by learn_more
jonsv wrote:
Sun May 17, 2020 6:19 pm
@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...

Re: SQLGetDiagRec

Posted: Fri May 22, 2020 9:34 am
by 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