Home > Archive > Visual FoxPro SQL Queries > September 2005 > SQL Pass through









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQL Pass through
howard

2005-09-13, 11:25 am

Moved my app to use SQL Pass Through on Windows 2k LAN. All is well except
one user gets a seemingly random "internal consistency error" as he
instantiates one of the forms. MSDN search results in a page that recommends
to call Microsoft Support who is looking for a credit card number....

Any ideas would be appreciated.

Fred Taylor

2005-09-14, 3:24 am

Try deleting your FOXUSER.DBF and FOXUSER.FPT files.

--
Fred
Microsoft Visual FoxPro MVP


"howard" <howard@discussions.microsoft.com> wrote in message
news:47203E96-035C-41C1-9778- F184191BAFB8@microso
ft.com...
> Moved my app to use SQL Pass Through on Windows 2k LAN. All is well
> except
> one user gets a seemingly random "internal consistency error" as he
> instantiates one of the forms. MSDN search results in a page that
> recommends
> to call Microsoft Support who is looking for a credit card number....
>
> Any ideas would be appreciated.
>



howard

2005-09-14, 1:24 pm

Fred - tnx for the suggestion. Deleted all occurences of foxuser on server
and client machines. Still get the occasional 'internal consistency error'.

Do I rebuild the machine next?

"Fred Taylor" wrote:

> Try deleting your FOXUSER.DBF and FOXUSER.FPT files.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "howard" <howard@discussions.microsoft.com> wrote in message
> news:47203E96-035C-41C1-9778- F184191BAFB8@microso
ft.com...
>
>
>

Fred Taylor

2005-09-15, 3:25 am

Then you may have a corrupted index file. Try re-indexing all data files,
you may need to re-create the indexes, not just do a REINDEX command.
Something, somewhere is corrupted or you might have a flakey memory module,
that is not an error you should ever see if things are in good shape.

--
Fred
Microsoft Visual FoxPro MVP


"howard" <howard@discussions.microsoft.com> wrote in message
news:0A5BA2FB-8147-4497-B7DD- 1953060EA26A@microso
ft.com...[color=darkred]
> Fred - tnx for the suggestion. Deleted all occurences of foxuser on
> server
> and client machines. Still get the occasional 'internal consistency
> error'.
>
> Do I rebuild the machine next?
>
> "Fred Taylor" wrote:
>


howard

2005-09-15, 3:25 am

Will do. I had ruled the indexes out as I reindex automatically nightly.
Only one of a dozen or so machines that bang away using the app have
experienced the problem thus my leaning toward simply rebuilding that machine.

"Fred Taylor" wrote:

> Then you may have a corrupted index file. Try re-indexing all data files,
> you may need to re-create the indexes, not just do a REINDEX command.
> Something, somewhere is corrupted or you might have a flakey memory module,
> that is not an error you should ever see if things are in good shape.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>
> "howard" <howard@discussions.microsoft.com> wrote in message
> news:0A5BA2FB-8147-4497-B7DD- 1953060EA26A@microso
ft.com...
>
>
>

Fred Taylor

2005-09-15, 3:25 am

If it's a single machine, you may have a problem with the NIC, cable,
memory, video card, etc., there alone.

--
Fred
Microsoft Visual FoxPro MVP


"howard" <howard@discussions.microsoft.com> wrote in message
news:5C147199-D377-438A-AEE5- FAC5EAFF8C07@microso
ft.com...[color=darkred]
> Will do. I had ruled the indexes out as I reindex automatically nightly.
> Only one of a dozen or so machines that bang away using the app have
> experienced the problem thus my leaning toward simply rebuilding that
> machine.
>
> "Fred Taylor" wrote:
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com