Michael,

I've run into this same problem. The solution is to make sure that each view completes execution before the next one begins. The easiest way to do that is to:

1. Make sure the connection you're using is not set for asynchronous operation (it probably isn't).

2. Make sure each view's fetch size (the number of records to fetch at once) is set to -1 (all). If it's set to 100 (the default), a view with more than 100 records will get the first 100 then allow the program execution to continue while it fetches the rest of the records. Not only will this fix your "connection is busy" error. It will also make your views that return more than a few hundred records execute much faster.

>I have created a Visual Foxpro application that is a front end to a oracle backend database server. My problem is that since I have to use remote views because I am adding data to 20 or so tables the odbc connection string creates a connection for every tables I have open.
>
>I have tried to set the view to share the connection but it returns an error when loading the form saying the connection is busy.
>
>I would be okay for it create 2 or so connections not 1 for every table.
>
>Can any help me