ODBC connection question

Hot Topic

Installing VS 2005 keeps on asking ' Please insert the disk: Visual studio 2005'
How to halt a program???
Get information from database
Jpg to Tif convert
invalid parameter
Cannot open existing form in Designer HELP! - VB 2005 Express Edition Beta
Database Developing
Locking a member Variable in Memory
User session logon time!
Package and Deployment Wizard

Visual Basic

Datagrid collapse
Creating your First Database (VB.Net 2005)
Is it possible to generate a solution with a class library in it using codeDom?
Overflow???
Using multiple ORs in an if statement
modifying messagebox buttons
I have 512 ram and Semprom 2800 but Visual Web Developer run slow
Interacting with another aapplication
DAta Sources Toolbox functionality reversed
VB Refactoring in VS.2003

ODBC connection question

Hopefully this is an easy question, but I am trying to run a query that is returning a fairly large amount of data from an AS400. I am now getting an error "Estimated query processing time 186 exceeds limit 30". It is a SELECT DISTINCT statement. When I remove the "DISTINCT", the query runs fine.

Where do I need to go to set the processing time

Thanks for the information.

Answer this question

ODBC connection question

  • CarlLS

    in the connection objects timeout property

  • Lewis Christie

    the easiest place to view methods, properties, classes and namespaces is by using the object browser...look for the system.data namespace or do a search for the dbconnection object and then look in the right hand pane to see the methods and properties

  • MClift

    The command object has a timeout property, defaulting to 30s. This can be extended if the command it likely to take longer to process, e.g. when building an access path. Try myCommand.CommandTimeout=200.

  • briancamping

    I hate to sound ignorant, but where do I find the connection objects properties

  • HokieTX

    Hi, Did you manage to find a solution for this issue -I am experiencing the same problem as you trying to bring data back from AS/400.
  • ODBC connection question
Answer this question