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 and asynch data returns, at least intentionally. If I pause the debugger and run a sqlmoreresults() I get a 2 and I can continue. 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 combonation. Has anyone run into this before and more importantly, fixed it? Thanks for any consideration.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only