Query time-out error

[Dalton_Tom1 (Dalton Tom)]

I am using TRemoteDBDatabase connection to a TRemoteDBServer and AureliusConnection. I have a dataset that sends the SQL script to retrieve data from a Azure database. The data that it is extracting can have graphics (mostly not) and the field type is a VarBinary(Max) field. If I run the query on the server using my remote login credentials the query returns the data within 3 seconds. But, when I run the same SQL in the TXData component it gives me a time out error.

I have looked and can’t seem to find the right place to increase the query run time.

Any suggestions?

Regards

Tom Dalton

[wlandgraf (Wagner Landgraf)]

This topic might help you:

Change client timeout

Hello Michael, you can use: RemoteDBDatabase1.Timeout := 30000; // 30 seconds