we use the JDBC drivers shipping with CF. No need for installing Oracle or the Oracle drivers at all this way too. One less headache in maintenance and in setup.
DK On 7/11/06, Priscilla Yamin <[EMAIL PROTECTED]> wrote: > One that it is working on is > Windows 2000 > Oracle 9i driver > CFMX7 > > Priscilla Yamin * Web Services Manager / Valencia Community College * SunGard > Higher Education * 1800 S. Kirkman Rd. MailCode 4-12 Orlando FL 32811 * Tel > 407-582-1988 * Fax 407-582-5531 * > [EMAIL PROTECTED] * www.valenciacc.edu > > CONFIDENTIALITY: This e-mail (including any attachments) may contain > confidential, proprietary and privileged information, and unauthorized > disclosure or use is prohibited. If you received this e-mail in error, > please notify the sender and delete this e-mail from your system. > > >>> [EMAIL PROTECTED] 7/11/2006 11:57 AM >>> > > Priscilla Yamin wrote: > > We have several servers with connections to oracle > > ODBC with no problems. > > Which OS? Which version of CF? Which drivers? > > > > We just set up a new server with Windows 2003 > > Standard Service pack 1. > > It has an Oracle ODBC set up with Oracle 9.2 > > drivers (we tried 10g, too), the ODBC connection > > verifies on the server. > > How did you test this? > > > > When I create a DSN in CF administrator, the > > connection fails. > > java.sql.SQLException: Timed out trying to establish > > connection > > How have you configured the firewall? > > Jochem > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:10/messageid:6008 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:10 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10
