FoxPro ODBC problem

[mletson]

Hank,

We have similar problems. Our traffic load is relativley heavy and we have to
reboot the server sometims 3 or 4 times a day. We haven't been able to find a
solution yet.

Have you found a solution?

Thanks,
Mike

[sdupre]

If you need a type 4 JDBC driver, try [url]www.hxtt.com[/url].

We've tested their MS Access drivers but not the Foxpro.

Stephen Dupre
Macromedia QA

[HankM]

Originally posted by: sdupre
If you need a type 4 JDBC driver, try [url]www.hxtt.com[/url].

That was the solution we settled on, sort of...

We found that the HXTT FoxPro driver works perfectly for reads, but is
unpredictable for inserts and updates, so we use it only for reads. For writes,
we use the old Microsoft ODBC driver in single-threaded mode -- it's relatively
slow, but writes are such a small percentage of our activity that it presents
no problems for us. We've been operating in this mode for more than six months,
during which time we've basically experienced no problems. It seems like a
bizarre solution, but it's worked quite well for us.

BY the way, the folks at HXTT are probably the most responsive support people
I've ever met. They haven't implemented every last FoxPro function in their
driver, but every time we need to use a function that they don't support, we
ask them about it and they implement it within 24 hours, at no extra charge. I
have a feeling that they could have resolved the problems we experienced with
writing to FoxPro tables if we had worked with them, but the solution we
implemented works for us so we didn't want to take the time to do that. I can't
say enough about their responsiveness, despite being halfway around the world
and not speaking great English, they're wonderful to work with.