Unanswered: Timeout expired[microsoft][odbc sql server driver]
I am running an VB6 application with SQLServer 2000,for morethan 6 months. Suddenly I am receiving this TIMEOUT ERROR. when i try to run that particular query in the QUERY ANALAYSER,it takes less than few seconds. But when i try to use in my application, it shows this ERROR.
When I found the number of records it is more than 1,34,245 records.
I am accessing SQL through my DSN name created via ODBC connectivity.
Please pass your valuable suggestion and help me to sort out this...