"ODBC - call failed" Error Msg

[kashew]

I'm connected to an Oracle database and trying to set a parameter in an MSAccess query when I receive the above error msg. The WHERE portion of the SQL in Access looks like this:
WHERE (TABLENAME.FIELDNAME)=[Forms]![FormName]![value];
The error goes away when I replace the parameter with a hard value.
Can anyone tell me why I'm getting an error? I haven't had any parameter problems with similar Sybase tables. This is my first experience with Oracle tables.

 

[ETID]

Maybe you need to trim() the value, do not convert to values because of an extra leading character position (reserved for "-" in the event of a negetive number).


syntax:

WHERE (TABLENAME.FIELDNAME)=trim(stR$(([Forms]![FormName]![value]));

 

[ETID]

Oops, I mean values do not convert.......

 

[kashew]

I've already tried that. It doesn't work. I'm now being told that MS Access does not work very well with Oracle. I'd like to find a way to make it work. I'm sure someone out there has run across this problem before.

 

[ETID]

can you build this filter in an access query?...maybe you Can get a clue of the syntax by viewing the sql statement?