VFP OLEDB - odd errors in IIS log?

[GriffMG]

I'm getting some random errors in one of my IIS logs (it may be happening in all of them - I haven't looked yet) relating to VFPOLEDB.

Some are saying the fields in a table don't match the dbc, some are saying the database is invalid - neither of which is correct.

I'm wondering if there is a tweak I can do to reduce the errors - does anyone have any exp. of this?

TIA

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Olaf Doschke]

I don't use vfp via IIS, but do these errors happen in case of a high load of the server? False alarms might have to do with a high load. Hopefully you prgrammed for shared access, even though the server makes it one user only, there can be multiple processes or at least threads. vfpoledb is threadsafe, it can be used from many threads, but that also means it can run concurrent with itself.

Bye, Olaf.

 

[GriffMG]

Morning Olaf

It is quite possibly a load based problem - which is probably a shame.

The code is all designed for shared access, and these errors may have been there for sometime - I only recently modified my scanners to examine the log files in this level of detail.

I have found the same error reported in Experts Exchange, but their 'solution' was unhelpful.

I have reloaded the very latest version of the VFPOLEDB last night... and I have no errors yet today, but there is no load before 8am as a rule.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Olaf Doschke]

Ok, then good luck.

I made a test and by default a adodb.connection via vfpoledb is working shared. Would have surprised me anyway, if exclusive = on would be a default. Nevertheless there might be something in the isolationlevel of the adodb.connection. The default is 4096, which means readcommitted. That should be fine, but you might try something else.

http://msdn.microsoft.com/en-us/library/ee252416(v=bts.10).aspx

Depends of course on using the adodb.connection.

Bye, Olaf.

 

[GriffMG]

Thanks Olaf

I will have a play with those, there are only a few so I should be able to see if any make a difference.



Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[GriffMG]

I have a couple of errors thus far today - well down from yesterday...

It may be that I didn't have the best VFPOLEDB.DLL

In which case Experts Exchange perhaps deserves an apology

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[GriffMG]

I think we can call that a success. Some errors (30 a day from 16 web sites) to zero.

In order to achieve this miracle, just install the right version of VFPOLEDB...

I found that using VFPOLEDBSetup.msi which is dated 8 Feb 2010 16:21 and is 1,292,288 bytes is the one for me.

To be sure, when it installs it shows a licence which has a very prominent SP2 note at the top.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Olaf Doschke]

Good to know as a reference. I don't have the setup here, but looks ok. I think though, the 2010 date was just the date of your download and is not the date and version in the file properties. SP2 including OLEDBSP2 where done in 2007, perhaps 2008.

The latest Hotfix of VFP itslef was done 2009/04/06 in reference to

http://berezniker.com/content/pages/visual-foxpro/vfp-90-versions

Bye, Olaf.

 

[GriffMG]

I wasn't sure about the date either.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.