SQLGetDiagRec

Ask your support questions in here

Moderator: Moderator Team

Post Reply
jonsv
Posts: 8
Joined: Thu May 15, 2014 8:53 pm

SQLGetDiagRec

Post 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?

jonsv
Posts: 8
Joined: Thu May 15, 2014 8:53 pm

Re: SQLGetDiagRec

Post by jonsv »

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

learn_more
Developer
Posts: 182
Joined: Fri Dec 19, 2014 10:00 pm

Re: SQLGetDiagRec

Post by learn_more »

That depends entirely on the contents of the debug log.

jonsv
Posts: 8
Joined: Thu May 15, 2014 8:53 pm

Re: SQLGetDiagRec

Post 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�"
Attachments
debug.txt.gz
(5.48 KiB) Downloaded 19 times

learn_more
Developer
Posts: 182
Joined: Fri Dec 19, 2014 10:00 pm

Re: SQLGetDiagRec

Post 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...

Julcar
Posts: 134
Joined: Thu Jul 31, 2008 8:19 pm

Re: SQLGetDiagRec

Post 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

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests