I am having a problem with VFP8 SP1 using stringconnect with Advantage ODBC V7.10 on XP Pro Dev system. It happens on a particular record in a complicated series of SQL accesses. However, usually it doesn't happen on the first access, only if you repeat the series. At first I thought it was different in IDE vs run as EXE, but it happens within a couple of trys in either mode. The error is reported by the "Advantage DB Server" (title of messagebox) with the follow message:
An exception occurred in the Advantage Local Server axCommReq function. This process will be stopped. The exception code is 0xC0000005. The base load address is 0x1E940000. The execption occurred at address 0x77e765F7
(yes, the second exception is spelled incorrectly in the message box).
I changed the values for sys(3050) for foreground and background sizes larger and smaller and it had no effect on the message. I also deleted the foxuser.*** files.
I have other programs that work fine that use the same advantage odbc connection methodologies that have been running in the field since 1999.
Any ideas ?
Thanks in advance.
An exception occurred in the Advantage Local Server axCommReq function. This process will be stopped. The exception code is 0xC0000005. The base load address is 0x1E940000. The execption occurred at address 0x77e765F7
(yes, the second exception is spelled incorrectly in the message box).
I changed the values for sys(3050) for foreground and background sizes larger and smaller and it had no effect on the message. I also deleted the foxuser.*** files.
I have other programs that work fine that use the same advantage odbc connection methodologies that have been running in the field since 1999.
Any ideas ?
Thanks in advance.