Hi,

I am pulling data from a very slow connection to a SQL Server 2000 database. When I run the following query in Query Analyzer, I get a record set though in some cases it may take 1-2 minutes to do so.

select distinct ifs_table_clrled.transaction_id, 
ifs_table_clrled.bank_account_code, ifs_table_clrled.agency,  
ifs_table_clrled.ref_trans_id,  
ifs_table_clrled.vendor_code,   ifs_table_vend.vendor_name,ifs_table_vend.vendor_address_line1,
vendor_address_line2,ifs_table_vend.vendor_address_line3, 
 ifs_table_vend.phone_area, ifs_table_vend.phone_exchange, ifs_table_vend.phone_number,
ifs_table_vend.last_payment_date,
ifs_table_vend.contact, ifs_table_vend.id_number,
ifs_table_vend.id_type, ifs_table_vend.city,
ifs_table_vend.state, ifs_table_vend.zip,ifs_table_vend.comment,
ifs_table_vend.vend_elec_pay_ind  FROM ifs_table_clrled,ifs_table_vend  where ifs_table_clrled.vendor_code =  
ifs_table_vend.vendor_code  AND RTRIM(ifs_table_clrled.transaction_id) in 
('AD00001494521','AD00001494793','AD00001494817','AD00001494825',
'AD00001495243','AD00001495343','AD00001495351','AD00001495357',
'AD00001495363','AD00001495364') 
AND ifs_table_clrled.fisc_year = '2004'  
AND ifs_table_vend.fisc_year = '2004' 

When I run the query through a CursorAdapter, I receive the following error if the query takes over 1 minute.
"Microsoft OLE DB Provider for ODBC Drivers [Microsoft] [ODBC SQL Server Driver] Timeout Expired"
I don't see any place to extend the timeout for a CursorAdapter. Where would I do that?