VFP ODBC Driver - How reliable? 1

[GriffMG]

Hi,

I'm just testing a new web interface for one of my VFP apps - running IIS on my XP Home machine - and notice that it doesn't seem to be rock solid, sometimes the back-end seems to just go into a black hole while extracting data.

I'm reasonably confident that it's down to my unorthordox set-up - but thought it worth asking if anyone else finds the ODBC for VFP a little flakey?

Regards

Griff
Keep [Smile]ing

 

[rgbean]

Griff,
Since the last ODBC driver for VFP was for the 6.0 release and MS has publicly stated that they will never update it, it may be time to consider using the VFP OLEDB client. This was recently updated with the VFP 8.0 SP1 update. You can get it at

http://www.microsoft.com/downloads/...8-7a94-4ae1-a59e-965869cb3bc9&displaylang=en.

Rick

P.S. I didn't think IIS was included with XP HOME.

 

[GriffMG]

IIS isn't included 'technically' with XP Home, but my machine won't run XP Pro (like many others) and it's pretty easy to install IIS and most of the other components that MS saw fit to knobble.

I don't really want to go OLEDB... but I'll have a look!

Thanks Rick

Regards

Griff
Keep [Smile]ing

 

[Mike Lewis]

Griff,

I have used several recent versions of the ODBC driver with different applications. Generally speaking, I have found it reliable when used with DBCs, but less so when used with free tables. The more recent versions are less reliable with free tables than some of the older ones.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[GriffMG]

Mike

My version is 6.00.8167.00 I'm working exclusively with tables from DBCs. I think this is the latest available.

Thanks for your thoughts, the tables themsleves are not huge - I think it is probably my set-up with XP Home and IIS.

Martin

Regards

Griff
Keep [Smile]ing

 

[rgbean]

You may want to get the "last" version - 6.1.8629.1 - at

http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx.

Rick

 

[GriffMG]

Thanks Rick - that should be later than mine.


Regards

Griff
Keep [Smile]ing

 

[GriffMG]

For what it is worth, the problem seems to be triggered when my sidebar auto-refreshes at the same time as I invoke a page - I've stopped the auto-refresh and it seems to have stopped. I probably need another machine to test on!

Thanks one and all.



Regards

Griff
Keep [Smile]ing

 

[GriffMG]

Can anyone tell me if this is likely to be a

BACKGROUNDFETCH

Kind of error?

Regards

Griff
Keep [Smile]ing

 

[craigber]

The ODBC driver is not thread safe. It is not recommended for use on a web site. As others have said, you should use the OLE DB provider.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[GriffMG]

Hi Craig,

I've got it working now, still using the ODBC driver, by turning off the backgroundfetch.

Can you tell me more about the driver not being 'ThreadSafe'? or point me towards some more info?



Regards

Griff
Keep [Smile]ing