VFP7 Remote View Into SQL Server - Error

[JRB-Bldr]

I am hoping that someone out there has encountered this problem and come up with a resolution.

I have a VFP7 application which is using Remote Views into an Informix and a SQL Server backend to acquire data which is then processed.

The Informix backend has worked fine for multiple years. The SQL Server backend is a new addition.

As this new integration is being developed, I am building the CREATE SQL VIEW's (there are a number of them) by hand and then testing them.

For testing purposes I will do a MODI DATABASE and double click on a View within the Database. Every now and then when I do that I get a Visual Foxpro Error:
Fatal Error: Exception code C00000005 ...etc.

This generally causes VFP to shut down automatically.

If I launch VFP again I will do:
SET EXCL ON
MODI DATA SQLTest
DELETE VIEW Test
I then run a Cleanup Database to ensure that EVERYTHING from before is removed from the Test DBC and then close it.

Next I SET EXCL OFF and open the database again and CREATE SQL VIEW "SQLTest" again.

When I once again attempt to launch the View and it immediately "blows chunks" and causes VFP to automatically close.

Another piece of information is that a number of the SQL tables within the same SQL Server database open into their individual VFP7 Remote Views fine.

Questions:
1. What caused the problem?
2. How to fix problem?
3. How to prevent from occurring again?

I would appreciate any advice you could offer.

Thanks,
JRB-Bldr

 

[AndyKr]

That are lots of possibilities here. If you run VFP with RESOURCE=ON I would try backing up our FoxUser table and then deleting it to see if that fixes the problem.

(The rationale is that if the foxuser is storing invalid data about the remote connection that can cause the error)


----
Andy Kramek
Visual FoxPro MVP

 

[JRB-Bldr]

Andy,

Thanks for the reply.

I can certainly try your suggestion, but since a number of the SQL tables within the same SQL Server database open into their individual VFP7 Remote Views fine., I am guessing that the Remote Connection is working OK. If the Database Connection were a problem I would expect to see problems with ALL of the Remote Views to that SQL Server - not just one or two.

Thanks,
JRB-Bldr

 

[AndyKr]

>> If the Database Connection were a problem I would expect to see problems with ALL of the Remote Views to that SQL Server - not just one or two.

Not necessarily. VFP stores each instance of the designer separately - if one of those is corrupted then you will get exactly what you see.

----
Andy Kramek
Visual FoxPro MVP