Up until LabVIEW 2018, National Instruments provided database addon only for 32-bit version. Those who works with 64-bit LabVIEW version, this could be a roadblock if ever wanted to run the app only in 64bit and still need to access databases.
Short Answer
A simple trick which works. If we copy the database addon from 32-bit LabVIEW installation to 64-bit LabVIEW installation, it still works without any issues. However ensure that other database file (.udl etc) and ODBC connections are setup for 64bit as well. Checkout my Oracle DB Connection learnings as well here
Long Answer
I used Oracle database via ODBC for an application in 32-bit. To get it working in 64 bit
- I had 32-bit version of same LabVIEW installed. You may need to install if you only have 64-bit version
- Copy database folder from C:\Program Files (x86)\National Instruments\LabVIEW xxxx\vi.lib\addons to C:\Program Files\National Instruments\LabVIEW xxxx\vi.lib\addons. Ensure to change xxxx to correct LabVIEW version.
- Installed the 64-bit database instant client for Oracle
- Configured the connection in 64-bit ODBC client.
- Added a new UDL file for 64 bit (now I don’t need to open 32-bit command prompt) and configured the UDL file to use the newly installed 64-bit oracle client.
- Used that new UDL file in the LabVIEW application to connect to the database.
Ajay is a professional developer and architect of NI-LabVIEW applications with extreme interest in getting the hardware connected to LabVIEW and automating the stuff. Recently he is also putting his hands in NI-TestStand to get very dirty on it. He is also a good mentor for the various interns in his career. He is ready to help the people in techie roles.