Stats

  • Locked Locked
  • Replies 3
  • Subscribers 165
  • Views 16242
  • 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

MySQL with Orcad CIS Table Property type for Part Number

Dipak Desai

Hi

I am new to setting up a MySQL parts data base however I have managed to use MySql Community version to create a small database jus one table and 2 or 3 row. All i was trying to do is create a table and connect to the databse from Orcad CIS. It went fine i was able to do all of these but when I went to configure CIS I keep getting the ERROR #8023

ERROR #8023 The Table Propoerty Type of field Part Number in table main parts is not TEXT, STRING or CHARACTER

I have this property set as CHARACTER, i have also tried to set it to TEXT and then to Varablecharacter but every time i keep getting the ERROR #8023.

Can some one please help me.

 Best regards

Dipak

  • oldmouldy
    I have attached a sample script to create the tables for a CIS database called "cisdb" using MySQL, you don't have to use this script but it will give you an idea of the required data fields and data types.
    CreateTables.zip
  • Khurana

    We're doing this and did have problems earlier but don't remember the cause or fix but I think it had to do with one of the table names being a reserve MYSQL word.  Try changing the field name to something else without a space (include an underscore or something).  And, sounds like you already tried VARCHAR but if not then try changing type to VARCHAR(<number>) where<number> is a numerical number such as 40 or 80...

  • DaveCowl
    For those searching for this still, it seems that the problem is that you need to use the ANSI and not the Unicode version of the driver.
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.