ODBC Oracle and Query Parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

append query problem 4
ODBC Queries 3
How to tell what's going on with complex queries on linked oracle tables 2
odbc connectivity to oracle 2
MS Oracle ODBC failure in Access 07 3
Best way to get a list back from oracle via passthrough query? 4
ODBC Pass-Through Queries 2
Oracle ODBC Connection Problem 1

Back
Top