Results 1 to 7 of 7

Thread: ODBC failed!

  1. #1
    Join Date
    Jan 2004
    Posts
    37

    Unanswered: ODBC failed!

    I have posted this under Access also--I'm not sure if it is an Access or Oracle problem.

    I have an Access database and right now I'm at home. The tables that I'm using are from an Oracle database at work. I have linked the tables in Access to Oracle using ODBC.

    I'm able to double click on one of the linked tables and see all the data for each table which I have linked.

    I'm trying to run a report that is based on a query. That query is based on several other queries and those queries are based on even more queries.

    When I start the report running I get the progress bar showing the query is runing, after about 2-3 minutes I get an error message ODBC failed!
    Sometimes the report will run and other times I get this error. Often times I will delete the linked tables and link them again and it might or might not do the trick....I have tried runing the linked table manager and again sometimes it allowes me to run the report and other times it won't work.

    Has anyone ever had this type of problem and do you know what I'm doing wrong. I'm new to databases and I'm self taught.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >do you know what I'm doing wrong
    Yes, you are not providing enough information for anyone to do more than guess.
    What is the EXACT & ACTUAL error message?
    Specifically what are YOU doing to generate the error;
    besides "running a report"?

  3. #3
    Join Date
    Jan 2004
    Posts
    37
    "ODBC---call failed"

    I'm not doing anything...just waiting for the report to finish runing.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    When I enter the string into Google I get
    Results 1 - 10 of about 1,780. Search took 0.14 seconds
    I suggest you start doing some research of your own.

  5. #5
    Join Date
    Jan 2004
    Posts
    37
    Thanks for all your help

  6. #6
    Join Date
    Feb 2004
    Posts
    2
    Look at the odbc timeout settings in your connection properties.

  7. #7
    Join Date
    Mar 2004
    Location
    Champaign, Illinois USA
    Posts
    8

    Cool

    If this really is a timeout issue and your ODBC driver for Oracle seems to be functioning otherwise ok, take a look at this document. You can adjust the timeout settings and many other parameters.

    http://otn.oracle.com/software/tech/...cs/ODBCFAQ.pdf

Posting Permissions

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