Stats

  • Locked Locked
  • Replies 0
  • Subscribers 164
  • Views 13176
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Quoted Identifiers not working with PostgreSQL ODBC

KevinL00

Attempting to use PostgreSQL with OrCAD CIS. Connection to the database is fine.

The issue occurs when attempt to view data when a table column has uppercase or special characters. Looking at the database logs, it appears that the column names are not wrapped in quotation marks in the SELECT query. Any way to address that? Is this an OrCAD issue or a driver issue?

I have set the "Parse Statements" setting on, but no results.

Environment:

 - PostgreSQL ODBC driver is 12.0.0, 32-bit. I am able to connect to server without issue via driver test. 

 - We're running OrCAD Capture CIS 16.6-S062 (v16.6-112FF). Yeah it's a bit old....

 - Windows 10 Pro, 10.01.18362 Build 18362

Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.