var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
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!
Ensure that you have at least 18.104.22.168 ODBC ... There was a problem with
prior versions ... You can download it from Oracle (approx: 1 meg)
Do i determan the version on the SQORA32.DLL? If so, we seem to have Product version 22.214.171.124, 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 126.96.36.199.10.
Thanx for your input, it really has me in a corner...
Last edited by namliam; 09-22-04 at 10:03.
This indeed was the problem,
Glad it worked out for you ...