>All,
>
>My foxpro program need update one MS SQL database every hour and the data is huge.
>I always get a error message 'Connection is busy."
>Is it because I use remote view?

See if following articles could help
PRB: Connection Busy Message With Remote Views of SQL Server Tables mskb #Q217082.
PRB: Connection Busy Error with a Shared Connection mskb #Q191343.