ODBC Oracle and Query Parameter

M

Mike Johnson

Using MS Acces 2002.I have a query parameter which prompts user for a text
value, the ODBC connection was changed a few days ago and I had to refresh
the links. I was using a ODBC connection to Oracle 8.0.5 and now Oracle
8.1.7. since the refresh my queries are not working. If I type in the value
directly into the critria field it works fine. I've tried using the trim$
function thinking it maybe adding leading or trailing spaces to the parameter
but this did'nt work. Does any one have any ideas. Thanks
 
M

Mike Johnson

No error, just no data.

It turned out to be Oracle was expecting the string tobe 15 charaters long
not just 5 so all i had to do was add 10 spaces to the string.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle ODBC Driver Errors 0
ODBC-Query with a parameter (by function) 0
How to tell what's going on with complex queries on linked oracle tables 3
Best way to get a list back from oracle via passthrough query? 4
MS Oracle ODBC failure in Access 07 3
append query problem 4
Append Records to ORACLE via ODBC 0
How to login "Oracle ODBC Driver Connect" in the programmatically 2

Top