Upon attempting to create a remote sql view, using a database connection this error is being returned. Has anyone seen this? This is in a production environment where others are working on the same sql database with the same dbc.

I don't know if it is related but the connecttimeout property of the connection in the dbc is 15, set by the developers, not the default of 0.

Some web searches indicate that a (similar) but not exactly the same error is fixed by installing the lates sql server 2000 sp.

I have seen connection is busy returned as a vfp error, but this error is being returned by odbc.