We are using a view to import data from a foxpro 2.6 table to a SQL 7 table then update the foxpro table do when the process is run it will not re import the data a second time.
The import is fine however changing the field value in the foxpro gives the error
update master..vwABBtrampost
set master..vwABBtrampost.status =
1,
master..vwABBtrampost.run_date =
'06/24/02',
master..vwABBtrampost.error_code = 0,
master..vwABBtrampost.error_desc = ' '
where sessionid = '061902' and tran_id = ' 12197' Msg 7415, Level 16, State 1, Server ACCSVR, Line 1
Ad hoc access to OLE DB provider 'MSDASQL' has been denied. You must
access this provider through a linked server.
Thanks For any Help
The import is fine however changing the field value in the foxpro gives the error
update master..vwABBtrampost
set master..vwABBtrampost.status =
1,
master..vwABBtrampost.run_date =
'06/24/02',
master..vwABBtrampost.error_code = 0,
master..vwABBtrampost.error_desc = ' '
where sessionid = '061902' and tran_id = ' 12197' Msg 7415, Level 16, State 1, Server ACCSVR, Line 1
Ad hoc access to OLE DB provider 'MSDASQL' has been denied. You must
access this provider through a linked server.
Thanks For any Help