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