There seems to be some confusion on your part, let's see if I can get you some clarification. OrCAD Capture CIS runs on Windows, you might be able to get some virtual hosting to persuade your Linux machine to run it but OrCAD Capture CIS is built for a Windows runtime environment. OrCAD Capture CIS connects to a database for schematic part properties using an ODBC driver, for Windows. ODBC drivers are available to connect to a number of databases which may, or may not, be hosted on a Windows machine. The ODBC drivers that you mention are to make an ODBC connction between a Red Hat Linux machine and a Microsft SQL Server, hosted on a Windows machine, to provide SQL Server based databases available to Red Hat Linux applications. Also, the CIP that you mentioned requires Windows hosted technologies to work, it does not use "any" database, or "any" web server, it specifically requires Microsoft IIS and Microsoft SQL Server technologies to run.
You CAN connect Capture CIS running in a Windows environment to a database, like MySQL, hosted on Linux, or any MySQL supported OS, through a MySQL ODBC driver running on Windows - this also applies to other databases that support and provide ODBC and is what your sale rep was telling you BUT this is NOT applicable to CIP.