Stats

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

CIS Database Problem

nimoster

Hi Guys

I have my MySQL database running for CIS now and I can access parts in the database and also place them in a schematic using the CIS Explorer. But when I try to link a placed part in the schematic to a database part (Edit -> Link Database Part...) I get the following error message:


ERROR(ORCIS-6250): ODBC Error Code: -1
Description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Load Capacitance , Physical_Package , Schematic_Part , PCB_Footprint , Manufactu' at line 1

ODBC Error Description: State:37000,Native:1064,Origin:[MySQL][ODBC 3.51 Driver][mysqld-5.0.51a-24+lenny5-log]


I don't have a clue where to start to fix this. Does anybody have an idea what's the problem? Btw, I use Capture CIS 16.5 and the MySQL Connector/ODBC v3.51.27. 

Thanks in advance,
Martin

  • Kuenga606

    Hi,

    If you have latest 16.5 hotfix installed, following Tcl command sets an option to display the SQL query in the session log window, that is created by CIS.

    SetOptionString DisplayCisQuery TRUE

    Capture needs to be restarted after setting the option.

    The SQL query can be entered into mySQL and check where the error is present.

    If mySQL requires different qualifier for table and field name, following INI option sets the qualifier for Table and Field name

    [Part Management]
    Table Qualifier='
    Field Qualifier='

    Thanks

  • nimoster

    Many thanks! That was the hint I needed... with the option I was able to track down the table Capture had a problem with....  D'oh! Whitspaces and dashes are no good in table headers ;-) I got rid of them, now everything is working fine, yay!

    Thanks again,
    Martin

  • DaveCowl

    Thanks for the hint. It seems that OrCAD is escaping the \ in the Part_Type too much. Basically it is using \\\ to represent the \ instead of \\ which is correct.

    Any thoughts on how to get it to behave? Basically I am connected correctly now but I don't see any parts that have sub-types.... :(

      

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.