Information générale
Forum:
Microsoft SQL Server
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement