Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Foxpro 2.6 Dos/SQL 7.0

Status
Not open for further replies.

dracos2

MIS
Aug 28, 2001
18
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top