I am using OrCad CIS 16.5 and I would like to use my company server to host the CIS database. We are using mySQL. I have set up a database with the properties as described in the help and created a new odbm data source. However, if I want to create a new data source in OrCad CIS preferences it doesn't appear in the options. I was wondering if OrCAD accepts mySQL as data base? Does anyone have a document how to set up the database on mysql and integrate it into OrCad CIS?
Many thanks in advance.
You need to use the 32-bit ODBC drivers, if there is any alternative. The MySQL connector has versions for ODBC 3.51 and 5.x, you might want to try both of these to see which gives best results since these can vary a bit. On a 64-bit OS, use the odbcad32.exe to configure the Datasource in the Control Panel stage. Create a System DSN for the database, any other option won't work (properly or at all). Ensure that you have at least the 4 required CIS fields in the database table(s) Fundamentally, this will all work just fine.
(Basically, the CIS application connects to the ODBC datasource, that is the "universal" bit, what is "at the other end" of the ODBC connection is irrelevant since the ODBC driver maps between the "universal" bit that the application sees and the bit that is specific to the actual database, whatever that might be.)