Connecting MySQL to PostgreSQL

[Dana Aft]

I have a client who has data from a third party vendor in a postgresql database. She set up a server to develop a reporting website off of this database, but for the life of us, we have not been able to create a connection to the postgresql server (even when working with the vendor). Even using pg_connect with the correct parameters, looking at config files, etc. has not worked. It's been weeks, and we have finally given up on this option.

Instead, we decided to set up a mysql database on her server that we can tap into directly. Now, the question is, how can I link the data from an ODBC datasource (the computer can connect to the postgresql database through an ODBC driver, which can pull data into Access) to automatically transfer into the mysql database?