Basic Oracle Questions

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

  1. #1

    Default Re: Basic Oracle Questions

    Has this been addressed in the form of patches or upgrades? Switching to a
    direct connection is not an option for us, as we only have access to the
    database via ODBC.

    I have 3 cfquery tags against a database and the third one is a simple (select
    sum(field) thesum from theTable), but it crashes.

    I do not understand how Cold Fusion can send out a product that works with 80%
    of Oracle SQL via ODBC. The direct connection does not work for 100% of the
    code we have used in the past, either, for that matter.

    Thanks for any thoughts you might have.

    zaq42 Guest

  2. Similar Questions and Discussions

    1. Basic Questions about FMS. Please help
      Hi, I have see Flash Media Server 2.0.4 that I use to make multiplayer game with shared objects. Now there are 2 more servers called 1 - Flash...
    2. Some basic questions
      Hi All, I've been looking into flex a bit for the last day or two. I have a question though, flex 2 doesn't do player compatibility (pre version...
    3. Basic Questions
      lallous <lallous@lgwm.org> wrote: od -cx and hd Possibly nothing at all, probably where /u or some other is mounted. Type "mount" or "df...
    4. Ruby/Tk Some Basic Questions
      Hi, I'm playing with Ruby/Tk and I've got the Perl/Tk book and some other text/online documentation to go along with. I am wondering if there is...
    5. basic oracle questions.
      Shravana Kumar wrote: 1. SELECT object_name FROM all_objects WHERE object_name LIKE '%PRIV%'; substitute ROLE for PRIV and find more...
  3. #2

    Default Re: Basic Oracle Questions

    What ODBC driver are you using? I recommend that you do NOT use the Microsoft
    ODBC for Oracle driver, as we have had nothing but problems. Try downloading
    and installing the appropriate ODBC driver from Oracle and configure your
    system data source with it. We used to use an Oracle ODBC connection back with
    Oracle 8.0.6 and CF 4.5 and had pretty good luck with it.

    [url]http://www.oracle.com/technology/software/tech/windows/odbc/index.html[/url]

    Phil

    paross1 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