>When I try to run my application, I get the Program error:
>Connection
is busy.
>If i hit cancel it closes the program, but if i hit ignore, it continues and appears to work normally.
>The connection is to a Sql Server 7 server which my remote views use.
>Any ideas?
>Thanks,
>Ryan
Just an experienced guess, but what are your setting for the following?
DBGetProp('MyView', 'View', 'FetchSize',)
DBGetProp('MyView', 'View', 'MaxRecords')
DBGetProp('MyView', 'View', 'ShareConnection')
Try these settings:
DBSetProp('MyView', 'View', 'FetchSize', -1)
DBSetProp('MyView', 'View', 'MaxRecords', -1)
DBSetProp('MyView', 'View', 'ShareConnection', .T.)
I had the same problem when querying a table that I knew had exactly 1 record. I had the MaxRecords or FetchSize [can't remember which] set to 1 and got the Connection Busy error. I set it back to -1 and the problem went away.
Mark McCasland
Midlothian, TX USA