Request timed out due to user timeout

[S V Ramakrishna]

Hi,
Iam getting the following error while trying to run a select statement
using Cache ODBC driver.

[Caché ODBC][State : S1T00][Native Code 450]
[c:\Program Files\Microsoft S
QL Server\90\DTS\Binn\DTExec.exe]
Request timed out due to user timeout.

Can anyone help me resolving this issue ?

Thanks,
RK

[Sukesh Hoogan]

Ramakrishna

Goto
Windows->Start->Settings->Control Panel->Administrative Tools->Data Source,
edit the Caché ODBC Data Source Setup
and
Check Disable Query Timeout. Click OK

Regards
Sukesh Hoogan
Bombay,India

[S V Ramakrishna]

Thanks for the reply. The error persisted even after " Disable Query
Timeout" option was selected. Iam using Cache ODBC driver to connect to
Cache database in SQL Server Integration Services package Data Reader task.
I could remove the error after increasing the Command Time out property(set
to '0' ) of DataReader source.
--
RK
"Sukesh Hoogan" <sukesh...@NOSPAMvsnl.com> wrote in message
news:47318...@info2.kinich.com...

[Sukesh Hoogan]

The cause of the error could be on either database. Glad to hear that
you managed to solve the problem.

Regards
Sukesh Hoogan
Bombay, India

[Nicki]

Experiment with this:

 CacheCommand Command = new CacheCommand(SQLtext, conn);

 Command.CommandTimeout = 50000; 

 CacheDataReader Reader = Command.ExecuteReader();