ODBC Connection from Client

Hi,

I am trying to use my local defined ODBC connection (ODBC 32bit) in SQL Connection, but all it shows me are the Server defined ODBC Connections.

I am using Pipeline Pilot v8.5 Client on a Windows7 64bit Client, but with Oracle Client 32bit and ODBC 32bit definitions (to be used in Office 2010 32bit). Due to some NetworkDomain and corresponding fire-walling, the Pipeline Server sits on a separate domain as my client and datasource, and before I am going to hassle our network guys to open ports between the domains, I was wondering if I could use local ODBC's.....

Does Pipeline Pilot allow Local/Client ODBC Connections, or do they have to be defined on the Server?

And if yes, how do I set them up in Pipeline Pilot Client (couldn't find a description/doc/help)?

Is the Pipeline Pilot Client using the 64bit or 32bit ODBC's?

Thanks for any help

Johannes