SQLite library not working with LV2025 64 bit

[viSci]

I realize this SQLite LIbrary (by ShaunR) is pretty ancient so not surprised there maybe some dll updating required but I thought I would inquire.

I have used it many times in the past and have come to appreciate its performant well crafted design.

Edited Sunday at 01:29 PM by viSci

[ShaunR]

The SQLite API for LabVIEW was retired 6 years ago (at version 5.0.0).

[viSci]

That is considerably more modern then my v1.3.1, I would give it a go if you could make it available...

Edited Sunday at 05:45 PM by viSci

[ShaunR]

If you have a commercial waiver then there is limited residual support but apart from that, you should be looking to transition to an alternative product. 

[hooovahh]

There are several SQLite libraries on VIPM.io. I personally use the one by JDP Science, but a few others also look promising. Changing over will obviously take some time finding and replacing one API for another, especially if there are differences in design choices in how they each implement similar functionality. 

[viSci]

Thanks.  I have already started porting to JDP SQLite.  I should have done that a long time ago.

[ShaunR]

22 hours ago, viSci said:

Thanks.  I have already started porting to JDP SQLite.  I should have done that a long time ago.

If you didn't use the encryption then you could use the SQLite binaries from SQLite.org to keep you running while you transition. I can't remember off-hand if it was supported in 1.3.1 but adding AES=NONE to the project conditional symbols enables the use of vanilla SQLite binaries (i.e. comments out encryption function calls). That said, I expect the issue with LV2025 is probably to do with calling parameters rather than the binary itself because V5.0.0. seems to work fine with LV 2025 & 2026.

[viSci]

I did try the latest sqlite dll from SQLite.org and also adding the AES symbol to the project but still crashes.

[ShaunR]

1 hour ago, viSci said:

I did try the latest sqlite dll from SQLite.org and also adding the AES symbol to the project but still crashes.

It is probably one or more misconfigured CLFN's somewhere that was fixed in later versions. It was worth a try though.

[viSci]

It crashes running any of the included examples.  It seems to be able to open a reference to the .db but any queries crash.

[ShaunR]

34 minutes ago, viSci said:

It crashes running any of the included examples.  It seems to be able to open a reference to the .db but any queries crash.

Indeed. That is usually the result of misconfigured CLFN's.

[viSci]

Are you suggesting that the problem was non-uniform application of the pointer-sized integer CLFN parameters?

[ShaunR]

4 minutes ago, viSci said:

Are you suggesting that the problem was non-uniform application of the pointer-sized integer CLFN parameters?

Not necessarily but possibly. Pointer to data instead of value or vice versa, enum sizes, pointer de-references of strings etc. Library calls are trixy.