14May 2021 by Ajayvignesh MV No Comments

LabVIEW 64-bit Database Addon

Blogs, LabVIEW Blog
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. Access Database from both LabVIEW 32bit and LabVIEW 64bit 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…
Read More
16Sep 2019 by Ajayvignesh MV No Comments

Oracle ODBC Connection & Key Learnings

Blogs, Snippets
Using an Oracle database from LabVIEW is quite jargon journey. From Instant-Client to ODBC, OLE DB, SQL Developer etc, difference between ODBC, ODAC, OLE DB, ADO etc, all can lead one to confusion easily. NI has tried to explain well on this document, it's still not very lucid in other sources like stackoverflow. I'm not confronting here to clarify all those. I found some few key learning are worth sharing. Windows has implicit classification of files between 32bit and 64bit. If you create a file using C:\Windows\SysWOW64\cmd.exe, then it creates pure 32-bit file. Look at this link for more details. LabVIEW connects to the database provider purely based on the LabVIEW bitness. If you use 32-bit LabVIEW, then use the 32-bit data provider and UDL file.Never get confused with Oracle…
Read More