Results 1 to 5 of 5

Thread: ODBC Problems

  1. #1
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421

    Unanswered: ODBC Problems

    Strange verry strange (to me atleast)

    We resently upgraded from Oracle 816 to 817.

    Now i have this strange problem. I have a table in Oracle linked via ODBC in Access, in access i do:

    Select right(field,2) from table <-- gets the last 2 characters of a field.
    This works

    Select max(right(field,2)) from table
    This generates an error ORA-00936: Missing expressing

    select right(field,2) from table order by right(field,2) desc
    Generates the same error

    Seeing as the field is allways 5 chars long i tried
    Select Mid(field,3,2) from table <-- Mid = Substr
    => Works (offcourse)

    Select Max(mid(field,3,2)) from table
    => Works also, doing the order by with the Mid also works fine.

    Problem thusly partly solved. But i have things like this all over the place in multi access applications and i dont much feel going thru them replacing those kinds of funtions.

    Has anyone ever heard of these kinds of errors? I searched the Oracle site and this forum, but couldnt find anything.

    P.S. The equevalent Left (gets the first couple of chars) does work!

    Greetz

    The Mailman

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Ensure that you have at least 8.1.7.4 ODBC ... There was a problem with
    prior versions ... You can download it from Oracle (approx: 1 meg)

    HTH
    Gregg

  3. #3
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Do i determan the version on the SQORA32.DLL? If so, we seem to have Product version 8.1.7.0, ODBC version 3.51.

    Also what is the difference between 3.51 and 3.52?

    Preferably we should have the newest version, right? That would be 8.1.7.8.10.

    Thanx for your input, it really has me in a corner...
    Last edited by namliam; 09-22-04 at 11:03.

  4. #4
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    This indeed was the problem,

    Thanx again!

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Glad it worked out for you ...

    Gregg

Posting Permissions

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