RE: C0000005 Error with Oracle Backend
From: Hitendra (Hitendra_at_discussions.microsoft.com)
Date: 08/09/04
- Next message: Kumar: "Open Dialog on SELECT - SQL"
- Previous message: Eric den Doop: "Re: Cross Tabular queries"
- Maybe in reply to: Hitendra: "C0000005 Error with Oracle Backend"
- Next in thread: Anders: "Re: C0000005 Error with Oracle Backend"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 9 Aug 2004 07:15:02 -0700
Trying out various SYS(3050) settings didnt improve performance, as such that
was expected because the tables are small and at Oracle backend. SYS(1104)
right before and after the SQLEXEC clause caused more repeated C0000005
errors than before and I had to move those calls a lot ahead, but no
improvement. In fact, the performance has now deteriorated.
Any other suggestions, please.
"Lee Mitchell" wrote:
> Hi Hitendra:
>
> What version of VFP are you using? Do you have the most recent service
> pack installed for your version of VFP?
>
> Try using the SYS(3050) function to alter VFP's internal usage of memory
> when handling data. See this article for more information:
>
> 176483 PRB: Large Amounts of RAM Seem to Process Data Slowly
> http://support.microsoft.com/?id=176483
>
> Also, try issuing a SYS(1104) function before and after query the Oracle
> tables.
>
> Finally, disable or prevent your anti virus from scanning any VFP tables of
> temp files. See this article for info on how to configure Norton in this
> manner:
>
> 321550 How To Optimize Visual FoxPro Applications While Using Norton
> AntiVirus
> http://support.microsoft.com/?id=321550
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 Public Beta Now Available!! --*
> Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/
>
> *-- VFP8 HAS ARRIVED!! --*
> Read about all the new features of VFP8 here:
> http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> Purchase VFP8 here:
> http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
> >We are encountering Fatal Exception C0000005 Error quite frequently with a
> Oracle backend.
> >The line where it occurs is SQLExec call and the same Update-SQL statement
> works without
> >any probs for 1000 odd times and then all of a sudden it will throw up
> that Fatal Exception Error.
> >We have upgraded Oracle ODBC drivers to the latest for Oracle 8 and Oracle
> 9 and yet the
> >problem persists.
> >Please suggest some other things that I need to do.
>
>
- Next message: Kumar: "Open Dialog on SELECT - SQL"
- Previous message: Eric den Doop: "Re: Cross Tabular queries"
- Maybe in reply to: Hitendra: "C0000005 Error with Oracle Backend"
- Next in thread: Anders: "Re: C0000005 Error with Oracle Backend"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
