Which is better ODBC or JDBC

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Which is better ODBC or JDBC

    dear all,
    after upgrading most of our servers from cf5 to CFMX7.1, it is now time to
    start working on some performance strategies for the upgrades. currently we
    went with the ODBC connector in CFMX for testing purposes. one of our server
    will occasionally lose the odbc and we have to reboot the server to get it
    rolling again.

    this leads up to the question of which is better for performace (speed, less
    process inducive) and realiability. ODBC or JDBC with CFMX7.1
    thanx
    sean

    bikerboy Guest

  2. Similar Questions and Discussions

    1. Still bad driver for JDBC / ODBC
      Hello Since Oct 05 there is version 3.5 available in the package macromedia_drivers.jar and still we got the error 'no more data available to...
    2. Peachtree ODBC/JDBC????
      Does such a thing (ODBC/JDBC Driver) for peachtree exist? Im writing a project tracking app for an intranet that I would like to update a couple...
    3. ODBC\JDBC on same server
      We are building a new Windows server. One of the ColdFusion (MX 7) Admins created a slew of DSNs but when I looked for them I couldn't find a...
    4. ODBC JDBC Bridge
      We are setting up a new server for CF MX7 and having a problem connecting to a Remedy (AR System)database. There is no problems using the Remedy...
    5. ODBC - JDBC - ??BC
      I've made the jump to CF 7 to try and excape the JRUN problem and so far it's only hung twice and that was only within 48 hours of bringing it up. ...
  3. #2

    Default Re: Which is better ODBC or JDBC

    JDBC, no question.

    Phil
    paross1 Guest

  4. #3

    Default Re: Which is better ODBC or JDBC

    I would concur ... as CF is java based, it will run better with JDBC rather
    than having to interpret a bridge between the 2.

    There are a couple of very remote instances where ODBC may be required, but
    you will have much better results with JDBC.

    SafariTECH Guest

  5. #4

    Default Re: Which is better ODBC or JDBC

    thanx much, got some reading to do, but it looks like JDBC will be it. need to set the test server up with it.

    thanx again
    sean
    bikerboy Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139