Professional Web Applications Themes

CF5 to MX7 Problem: Sybase Stored Proc's dont work right - Coldfusion Database Access

Has anyone else had this problem? Stored procedures that worked with CF5 work differently in MX7. Some work part of the time, others not at all. We are using Solaris....

  1. #1

    Default CF5 to MX7 Problem: Sybase Stored Proc's dont work right

    Has anyone else had this problem?
    Stored procedures that worked with CF5 work differently in MX7.

    Some work part of the time, others not at all.

    We are using Solaris.
    DaveF67 Guest

  2. #2

    Default Re: CF5 to MX7 Problem: Sybase Stored Proc's dont workright

    Get the 3.4 drivers from /support/coldfusion and see if those solve your
    problem. If not, email me an example. This is the only one I know of that's
    blatant. None that are intermittent as you describe.

    Sybase

    * 57539 - Qualifying stored proc name with DB name throws error

    Stephen Dupre
    Macromedia QA

    sdupre Guest

  3. #3

    Default Re: CF5 to MX7 Problem: Sybase Stored Proc's dont workright

    Thanks.
    Here is the quick link to the 3.4 Drivers [url]http://www.macromedia.com/go/1a3c2ad0[/url]
    DaveF67 Guest

  4. #4

    Default Re: CF5 to MX7 Problem: Sybase Stored Proc's dont workright

    DAMIT... I spoke too soon.....

    Still Get an Error....
    Both CF5 and MX7 point to the same database...

    On the CF5 Server, this works great:

    awards_list (Records=60, Time=416ms)
    SQL =
    exec awards_search 'ACTIVE', 'Chemistry', null, null, null, null

    on the MX7 Server, when we would run the query above (WITH THE ORIG DRIVERS)
    we would get ALL THE RECORDS BACK.

    Now with the 3.4 drivers the stored proc throws an error... (BTW. the error
    now being thrown is identical to the error with the original drivers if the
    user entered two search terms i.e. 'ACTIVE' 'Chemistry Division',
    null,null,null

    Error Executing Database Query.
    [Macromedia][Sybase JDBC Driver][Sybase]Invalid column name '%CHEMISTRY%'.

    exec awards_search 'ACTIVE', 'chemistry', null, null, null, null

    BTW...
    This stored Procedure DOES WORK as follows:

    exec awards_search 'ACTIVE', null, null, null, 91, null

    It just will not take a search term as the second parameter :(


    DAMIT!



    DaveF67 Guest

Similar Threads

  1. MySQL 5 + MX7 stored proc problem
    By jperkins99 in forum Coldfusion Database Access
    Replies: 1
    Last Post: March 29th, 09:12 PM
  2. Stored Proc problem
    By mitaka in forum ASP Database
    Replies: 1
    Last Post: May 3rd, 05:11 PM
  3. ASP vs Stored Proc vs UDF
    By Brad in forum ASP Database
    Replies: 11
    Last Post: October 28th, 01:46 AM
  4. Stored proc problem on 9.30.UC1
    By Weaver, Bill in forum Informix
    Replies: 1
    Last Post: July 9th, 02:35 PM
  5. stored proc and tcp/ip
    By Helmut Wöss in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: June 30th, 08:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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