Skip to main content
A
Anonymous
August 24, 2010
Question

Connect to Oracle via SSH Tunnel?

  • August 24, 2010
  • 1 reply
  • 1610 views

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?

This topic has been closed for replies.

1 reply

M
mack_
Participating Frequently
August 24, 2010

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

A
Anonymous
August 24, 2010

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!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices