Hi all,
I'm converting a VFP app for a client to run against a SQL Server back end instead of VFP. (They have enough sense to keep the VFP front end!) I've made remote views in a DBC that work fine, but I've started having problems with the connection or something. I have some SQLExec's and they are getting the error "Invalid call issued while executing a sqlmoreresults sequence". I'm not attempting any asynch data returns, at least intentionally. If I pause the debugger and run a sqlmoreresults() I get a 2 and I can continue fine until the next SQLExec(). Also, after the form loads, when a method calls for a ReQuery() of a view, I get a "Connection MyConnection Is Busy". The connection is set up as shared. I've tried about every setting I can think of, although perhaps not the proper combination. Has anyone run into this before and more importantly, fixed it? Thanks for any consideration.