There are actually 4 different ways you can connect to an Oracle
database from LabVIEW and the Database Connectivity Toolkit:
Microsoft ODBC driver for Oracle
Microsoft OLE DB provider for Oracle
Oracle ODBC driver for Oracle
Oracle OLE DB provider for Oracle
In my experience, the Microsoft drivers aren't as good as the Oracle
ones. In fact, I never could get the Microsoft drivers to return
binary data at all. That might be what you are seeing.
Also in my experience, OLE DB providers are more robust and efficient
than ODBC. However, if ODBC is your only option, then definitely use
the Oracle drivers. You can download them from the Oracle website if
you don't already have them.
I hope this helps,
Crystal
