I keep getting the following error, both while in development and when running an application:

"Program Error:
VFP6.exe has generated errors and will be closed by Windows.
You will need to restart the program.

An error log is being created."

I just recently started with this company, who has a mainframe located in Chicago where several Oracle and DB2 databases reside. My new job requires that I gather lots of data from these databases. I haven’t had a lot of experience with non-native databases in the past. My predecessors used SQLCONNECT and SQLEXEC to handle this function. I’ve converted some of the processes to Remote Views stored in a DBC containing named connections with a named data source, userid, and password.

When working in development I seem to be getting the error when I go to modify one of my views. I’m also getting the same error when running an application which uses the SQLCONNECT and SQLEXEC functions. It’s hard to tell what causes the error when running the application, there doesn’t seem to be any pattern. Several end-users are also getting the error when running the application.

I'm guessing it has something to do with the connection timing-out between the database.

Has anyone encountered this problem before?

TIA,