From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
If you copy the various files for the database toolkit from 32-bit to 64-bit, it will work.
However, there are performance issues. The toolkit uses 32-bit ActiveX objects to do its work. When you call 32-bit ActiveX from 64-bit LabVIEW, it has to communicate to a separate process. Not all operations are slow, but I never really benchmarked it to characterize the behavior.
If you vote for this, please comment on how important performance is for you. Making the existing toolkit install on 64-bit is much easier than rewriting to use a newer database interface under the hood.
I'd really like to see a true 64 bit implementation as well.
I had to roll my own solution using direct calls to the MS Access ActiveX objects. It took quite some time.
But I suppose NI can't call Microsoft's code? Or rely on them having the run-time engine installed.
Actually... now that I look at your internals that's what labview is doing. it's just wrappers around calling microsoft's ado functions.
So why then is it at *all* difficult just to link them to the 64 bit versions? Might require a bit of manually crawling through the VI's and updating them, but this is as simple as it gets, unless I'm misunderstanding something.
Updating this toolkit has not been a top priority for National Instruments. It is a "like to have" not a "must have" for us.
Your solution is to make the database calls directly. Your database software in most cases has DLLs that can be invoked to perform database operations. You can use the Call Library Node to make calls into the DLLs.
There is a community effort to supply MySQL functionality for 64-bit that you may want to explore:
Alternatively, the 32-bit version of LabVIEW will run on 64-bit platforms and may suffice for many users' needs.
We realize that many users would like to have a pre-rolled toolkit from National Instruments, but we have not had the bandwidth to support this along with the other priorities that our customers have asked us to work on.
There are only two ways to tell somebody thanks: Kudos and Marked Solutions Unofficial Forum Rules and Guidelines "Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
Available with LabVIEW 2019 and later.