Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Unanswered: Progress - Coldfusion: JDBC DSN setup

    Using Coldfusion to connect to a progress database running on a solaris host.

    In Coldfusion the DSN setup is

    CF Data Source Name dummy
    JDBC URL jdbc.JdbcProgress:T:localhost:6000:dbname
    Driver Class com.progress.sql.jdbc.JdbcProgressDriver
    Driver Name ----don't know value----
    Username user
    Password password

    resulting error message...
    Connection verification failed for data source: its
    []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: No suitable driver.
    The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect: java.sql.SQLException: No suitable driver.

  2. #2
    Join Date
    Nov 2002
    Location
    London
    Posts
    47
    Hi

    Although not that familiar with the Progress JDBC driver, when that error occurs with our JDBC driver, it usually indicates that you don't have the necessary JDBC driver in your classpath. Typically, your classpath would look something like

    Classpath=c:\openlink\jdbc2\opljdbc2.jar;

    where the jar file contains the openlink JDBC information. You should have something like that setup for your environment. If this is not the case, I believe ColdFusion also has an option were you need to setup your Classpath that might be different from the System one. Again, add the necessary JAR files for Progress into this location.

    Emmon Simbo
    Technical Services Manager
    OpenLink Software

  3. #3
    Join Date
    Jan 2003
    Posts
    3
    Thanks Emmon for your advice, I modified the CLASSPATH accordingly but the same error still results. I am currently investigating on wether it could be a licensing problem.

  4. #4
    Join Date
    Nov 2002
    Location
    London
    Posts
    47
    Zander

    Is this still a problem?

    I managed to get my ColdFusion Setup going yesterday and I had a similar problem to you. In the end, I did a couple of things. I had a CLASSPATH environment defined for my user which pointed to the actual jar file, secondly, I definied it using the JVM and JAVA setting via the administrator. With these defined, I was able to connect to my database.

    HTH
    Emmon

  5. #5
    Join Date
    Dec 2002
    Posts
    19
    Are you using CFMX? If so, Install the temp jrpatch.jar file (search for it on Macromedia support) and you should get more detailed error messages. I have the jdbc connection setup with a merant connection but not openlink. Can you tell me how you have your options configured for the openlink driver?

    Thanks,

  6. #6
    Join Date
    Nov 2002
    Location
    London
    Posts
    47
    Hi

    I did a couple of things.

    I added my jar file located /home/openlink/jdk1.4/opljdbc3.jar. This is all taken care of by the shell script script openlink.sh

    After running this script, I restarted my coldfusion with these settings as part of my environment, don't believe this is really necessary but just in case, and in the Java and JVM settings, I added the directory structure incl. jar file to my settings, restarted CF

    From the Datasources section, I added a new setting for Other and simply added

    URL = jdbcpenlink://emmon/SVT=SQLServer 2000/uid=sa/pwd=/database=northwind

    Driver Class = openlink.jdbc2.Driver

    That was it. It connected to my SQLServer db and I was able to write simple statements.

    I have two connections, one using a Type 3 driver and the other using the OpenLink Type 4 JDBC driver for Virtuoso

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •