Information générale
Forum:
Microsoft SQL Server
>Hi All,
>
>Any ideas why queries like this would be working intermittantly?
>
>
>This SQL query when executed does not respond at all (queries like this were working last week):
>
>UPDATE
> OPENROWSET('MSDASQL',
> 'Driver=Microsoft Visual FoxPro Driver;
> SourceDB=\\sdms-finance\data\Software\Saturn\Data\saturn.dbc;
> SourceType=DBC',
> 'SELECT * FROM botran WHERE bo_ref="BORI000308"')
>SET
> bo_hours = 39.00,
> bo_erprsi = 0,
> bo_billholsbank = 0,
> bo_billsick = 0,
> bo_billholsstd = 0,
> bo_aorate1 = 27.81,
> bo_aorate2 = 0.81,
> bo_aorate3 = 0.00,
> bo_aorate4 = 0.00,
> bo_aorate5 = 0.00,
> bo_clrate1 = 30.90,
> bo_clrate2 = 0.90,
> bo_clrate3 = 0.00,
> bo_clrate4 = 0.00,
> bo_clrate5 = 0.00,
> bo_useMarkup = 0,
> bo_markup = 0.00,
> bo_grossplus_ersprsi = 0,
> bo_singlebillrate = 0,
> bo_expiry = 'Dec 30 1899 12:00AM',
> bo_dept = ' ',
> bo_modby = 'ANNIE ',
> bo_bookedby = 'STELLA CORRIGAN',
> bo_moddt = 'Sep 26 2006 3:43PM',
> bo_porder = 'D304382 ',
> bo_manager = ' ',
> bo_enddate = 'Dec 30 1899 12:00AM'
Kevin,
Intermittent execution and timeouts make me think about record locks. Does this work correctly in a controlled test environment? If you are certain that it is not a record locking issue, check the server's error log for any DTC (Distributed Transaction Coordinator) errors.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement