Cannot Connect to Oracle Database With Underscore in Table Name
Description
When attempting to set up connections in Loftware Design between my label and an Oracle database, tables with underscore ( _ ) characters in the name are not visible.
Explanation
This is a known issue with version 8.0.4 of Oracle's ODBC driver.
Information
The issue has been resolved with the release of the latest version of the driver, which can be downloaded from Oracle's web site.
The problem can also be avoided by using Microsoft's Oracle driver.
Loftware has an Oracle Connector See Loftware Connector. which connects the LPS to your Oracle Database... see more information on this website.
Article Number
2009048
Versions
All supported LPS family product versions
Environment
LPS using Oracle ODBC driver version 8.0.4