Stats

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

Linking OrCAD CIS to MySQL -> Only 1 component per Table Shown?

JFuoco

Here's my setup:

  1. Ubuntu server 16.04 running mySQL database (outside network)
    1. I imported the example BenchAccess database to get started -- I'll eventually add my own components, but thats irrelevant for now.
  2. OrCAD 17.2 running inside a Windows 7 VM on my MacBook Pro inside Virtualbox.
  3. I SSH Port Forward the Ubuntu Server MySQL port to my MacBook Pro.
  4. I add the connection in windows ODBC connection manager using MySQL ODBC 3.51 Driver. I am connecting to my MacBook in this scenario.
  5. I import the connection into OrCAD using the CIS configuration file. All goes ok, connection is made.

But then when I try to place a database part, I only see 1 entry for each table...

For example, on MySQL here are all some of the capacitors:

Where as in Place Database Part, here's what I get:

Only the 1 entry. Same holds true for each table.

For sanity, I also accessed the table through MySQL Workbench in my VM. All rows are shown. However it should be noted I accessed MySQL through MySQL's own "Connect to Database" tool instead of using Windows' Data Sources.

Hoping you guys can provide some insight?

Parents
  • JFuoco

    Ok, so as I was posting this I figured out the solution but figured it may be useful to someone in the future.

    UPDATE YOUR DRIVERS. I reconnected using the MySQL ODBC 8.0 ANSI Driver and all is well. 

Reply
  • JFuoco

    Ok, so as I was posting this I figured out the solution but figured it may be useful to someone in the future.

    UPDATE YOUR DRIVERS. I reconnected using the MySQL ODBC 8.0 ANSI Driver and all is well. 

Children
No Data
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.