I've successfully created a connection between Virtual View Manager(Server A) to a MySQL Database on Server B. I've added the ODBC connection on Server A for the database. I'm not sure how to specify then the connection to VVM-ODBC(Server A) from Cognos(Server C). Thoughts? Thank you in advance!
Here is my server layout(yes you guessed right, these are virtual servers on a mainframe):
Server A - Virtual View Manager
Server B - MySQL DB
Server C - Cognos Content Manager
Server D - Cognos Reporting
Server E - Cognos Gateway