Re: Error 1541 - connection busy

Thanks for the suggestion. I will try it, but I don't see how it can help.
There is a button on Form 1 to call Form 2, and first, there's nothing else
involving the connection going on when the user clicks the button, and
second, waiting any amount of time before clicking the button again gets the
same result.

Any comment on my questions about the SHARE clause?




"Lee Mitchell" <Leemi@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:dVdwWHyhFHA.1336@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi Paul:
>
> This may just be an information error saying that you need to wait until
> the connection is not busy, which may be just a micro second longer.
>
> You need to capture this error in your error routine and use the
> INKEY(0.5)
> function (0.5 is a half of a second) before the RETRY command, or you can
> use the SLEEP API to wait for a period of time before the RETRY command.
>
> * Place the DECLARE line of code in your main program if you want.
> DECLARE Integer Sleep IN Win32API Integer
> * Call the API whenever you want a wait state.
> =Sleep(500) && Pause for a half second, a whole second is
> 1000
> (milliseconds)
>
> Personally, I would use the FoxPro INKEY function because it has been in
> FoxPro for years. You may want to try INKEY(0.1) - 1/10th of a second
> because the wait timing is a part of testing to see what works best for
> the
> app.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>>I have Form 1 that calls Form 2. When that call is made, I get Error 1541
> -
>>connection busy. I can't tell exactly where it's happening, because the
>>error occurs in "Line 0". If I choose "Ignore", Form 2 opens and runs
>>properly.
>
>>The forms have nothing in the de; all data is opened in form.load. Both
> have
>>private data sessions. The data is all in MSSQL, which I access via remote
>>views based on a connection to an ODBC source.
>
>>Naturally, the error occurs only at the client site, and not on my own
>>network.
>
>>Might this have something to do with the SHARE clause in the view creation
>>statement? Some views were created in the view designer, which as far as I
>>can tell, has no option to set this clause, and others were created in
> code,
>>some with SHARE and some without. The description of the SHARE clause of
>>CREATE SQL VIEW in the FoxPro help file is not at all clear to me.
>
>>If this is what's causing my problems? Is it possible to set the SHARE
>>attribute in the view designer? Why does it work on my network but not on
>>the client's?
>
>>Any other suggestions?
>
>


.