Coldfusion Administrator

Posted on 2004-11-26
Last Modified: 2013-12-24

Can anybody help me in creating dsn for a Teradata datasource from ColdfusionMX Administrator.

Actually if i create a system dsn through the control panel odbc connectivity, it creates sucessfully. But i am not able to create the same through coldfusion administrar.

Since no driver is listed for Teradata in coldfusion administrator, i chose the "other" option for this driver. It asks for driver name,driver class and url for creating this datasource.How do i register the driver in coldfusion administrator ? Can anybody please help me in this.

Thnx in advance,
Question by:awsns
    LVL 10

    Accepted Solution

    Hi there

    I gues you need to download the the  JDBC Driver you want here

    and copy the files to JRun/servers/lib
    not sure what to fill in in driver class

    maybe there is something in the documentation

    LVL 5

    Expert Comment

    Most JDBC drivers come with some documentation. You can copy the necessary *.jar
    file to

    1. JRun/servers/lib directory (JRun Install)

    2. Go to CF admin and configure an "Other Datasource" - think last option of drivers.

    3. Refer to the docs that came with the JDBC Driver for correct Driver Class and URL

    Author Comment

    i have downloaded the driver and got the respective jar files "terajdbc4.jar" and "tdgssjava.jar" as mentioned in the site. I have placed the jar files respectively in the lib directory of


    Then i created the dsn using "other datasources" option.

    Driver URL : "jdbc:teradata://serverloc where teradata is running;"
    Driver class : "com.ncr.teradata.TeraDriver"
    Driver Name : "TeraDriver"

    But still while submitting it throws an error :

    "Connection verification failed for data source: sample
    []java.sql.SQLException: No suitable driver available for sample, please check the driver setting in jrun-resources.xml, error: com.ncr.teradata.TeraDriver
    The root cause was that: java.sql.SQLException: No suitable driver available for sample, please check the driver setting in jrun-resources.xml, error: com.ncr.teradata.TeraDriver"

    I am not able to identify the mistake committed in the steps i have followed.

    Please help.

    LVL 5

    Assisted Solution

    as per

    remove any trailing spaces from the Driver Class field
    LVL 10

    Expert Comment

    Split points Mause (1st) and kkhipple (last)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Course: HTML5 Specialist

    HTML5 development skills are critical to all developers. HTML5 is the foundation to almost any development process. That's why business, design studios, development shops and other organizations need HTML5 developers. Get your foot in the door as a HTML5 specialist.

    Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
    Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
    The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and Log…
    The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now