Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Darkest Kent, UK., Kent, England
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ODBC call failed... (A2K SR1, W2K SP2)

    Can anyone help me as to why am I getting this error message when trying to query from linked tables (SQL data source)? I've had a look at the Advanced settings in Options and there doesn't seem to be anything different.
    Attached Images Attached Images

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC call failed... (A2K SR1, W2K SP2)

    There are so many variables, network speed, processor/memory load on the SQL server, etc., that it's tough to say. You may want to increase the ODBC timeout for your query, though, as it is set to 60 seconds by default. Right-click in the grey area of your query while in Design view, choose Properties, and you'll see the ODBC Timout property. Good luck!

    Edit: It should go without saying, though, that making a user wait for more than a minute for a query to return is a bit, er, excessive. <img src=/S/wink.gif border=0 alt=wink width=15 height=15> You may want to check out the beauty of pass-through queries, and place the processing load on the SQL server.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

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