#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    10
    Rep Power
    0

    I could not connect to cold fusion to sybase


    Hi, Can i ask some help with you,I really don't have idea on how to connect my cold fusion to sysbase...Okay here's what i did...


    DataSource Name: myDTSrcNme
    Driver: I choose the drop down list "other"
    then click add

    CF-DATA SOURCE: myappsource
    JDBC URL: jdbc:jtds:sybase://127.0.0.1:1313/mytest.db
    Driver Class: com.sybase.jdbc2.jdbc
    Driver Name: SybDriver
    USername:myusernamedb
    Password:mypassdb

    THen after i submit. it shows this error.

    Connection verification failed for data source: myappsource
    java.sql.SQLException: No suitable driver available for myappsource, please check the driver setting in resources file, error: com.sybase.jdbc2.jdbc
    The root cause was that: java.sql.SQLException: No suitable driver available for myappsource, please check the driver setting in resources file, error: com.sybase.jdbc2.jdbc
    can you help me on this error...what should i do now?

    Thank you in advance.
  2. #2
  3. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,264
    Rep Power
    968
    Sorry, no idea. I only use Oracle, SQL Server, and MySQL.

    Why are you setting this up manually with JDBC instead of just using the built-in Sybase connector?
  4. #3
  5. No Profile Picture
    Moderator

    Join Date
    Jun 2002
    Location
    Raleigh, NC
    Posts
    5,264
    Rep Power
    968
    Also, don't post multiple threads about the same question.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2008
    Posts
    131
    Rep Power
    7
    Just in the interest of completeness, this question was cross posted on Stack Overflow. The error "No suitable driver available" means CF cannot find the driver class.

    Before creating the "Other" datasource, you must first:

    1) Add the driver jar to the CF class path (such as placing it in {cf_root}\WEB-INF\lib)
    AND
    2) Restart the CF server

    After restarting, CF will be able to find the class. Note, the "Driver Class" is case-sensitive. (This applies to any jdbc driver)
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    10
    Rep Power
    0
    Hi, thank you it's working now.

IMN logo majestic logo threadwatch logo seochat tools logo