Connect to Oracle via SSH Tunnel?

[Guest]

To do some development work on my laptop (Windows XP running ColdFusion 9 Developer Edition on Apache 2.2.14), I'm trying to connect to an Oracle database via a PuTTY SSH tunnel.  After a bit of work I was able to set up a ColdFusion datasource by creating a System DSN on my laptop that points at the SSH tunnel and using the ODBC socket driver to create the ColdFusion datasource.

However, though I'm able to run very simple queries this way... I get errors when I try to use aggregate functions (e.g. COUNT(*)).

Does anyone know a better way to do this?  Is there a way to use the Oracle driver supplied with ColdFusion to connect through an SSH Tunnel, perhaps?

Any other suggestions?

[mack_]

Do you get errors when running only some functions but it works ok in

general ? In that case I doubt it's a connection issue, it might be an

ODBC driver issue.

Did you try and connect to the Oracle server using the JDBC ColdFusion

driver ? (just put localhost in the Server input field and the local

tunneled port in the Port field)

--

Mack

[Guest]

Yes, it works okay in general--I can do a simple select and I get results.  My guess, too, was that it's an ODBC driver issue.

I was just about to say that I've tried connecting using the Oracle driver with the localhost as the server and one of the tunneled ports as the port--and it hadn't worked.  But I FINALLY figured out that what I thought was the correct SID was NOT the correct SID.  Now that I've got the correct SID, the Oracle driver is working fine this way.

Thanks a million!