>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,
SourceDB=\\sdms-finance\data\Software\Saturn\Data\saturn.dbc;
->SourceDB=X:\saturn.dbc;
X: is a mapping driver on your SQL server insead of the network path name.
Steven