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'