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 which connects the LPS to your Oracle Database... see more information on this website.

Related Articles

• Page:
  Cannot Connect to Oracle Database With Underscore in Table Name

  • kb-information-article
  • oracle
• Page:
  Error Missing the following Connector properties: [lpsLabelFormatPath]

  • kb-error-message
  • oracle
• Page:
  Permissions to Grant Users Without Having to Grant Them SYSDBA for Oracle Connector

  • permissions
  • oracle
  • kb-how-to-article
• Page:
  Error M1138 ODBC on Opening Database

  • kb-error-message
  • oracle
  • odbc
• Page:
  Manually Uninstall Connector Console

  • connector
  • kb-troubleshooting-article
  • oracle
  • universal
  • installanywhere