Stats

  • Locked Locked
  • Replies 1
  • Subscribers 165
  • Views 14382
  • 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

Orcad CIS Access database issue

Hory

Hi colleagues,

I have an issue with .DBC file creation in Orcad CIS, could somebody help me?

We have a MS Access database connected through the system ODBC MS Access connector (as shown on the pictures). In the database we have an ID column (automaticaly generated unique number) to be able to clearly identify each component. When I want to set this ID parameter as Property type "Part_Number" in CIS (DBC file) there is an error while saving the DBC file (as shown on picture below):  

ERROR(ORCIS-6233): The Table Property Type of the field ID in table PARTS is not of type TEXT, STRING or CHARACTER. The Table Property Type of the field assigned as Property Type Part_Number has to be one of the above. 

in the database we have also some virtual components so not all columns are always filled, this is the reason why we want to identify component according to the ID number (to be able View Database Part in Orcad). 

Thanks.

Regards

Petr

  • oldmouldy

    The four "required" fields for a CIS datasource must be formatted as Text, typically VARCHAR in SQL terms, to work, no other options are supported. For "any" database, "ID" will, almost certainly, have a format of NUMBER, or similar, and will not work for the Part Number field source for CIS.

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.