Woe that is Microsoft
I truly don't know why I have never posed this question here before now. Has any one here had success at getting Linux to communicate with Fox Pro? Yes, yes. I know VFP sucks, and given the choice I'd use MySQL, but I don't have a choice, at least not yet. Actually, I do use MySql for everything else, but the main application used by my company is written in and around VFP. Bastards. Anyway... the only solution I have thought of is to run a minimalistic installation of Apache on a Windows server, with a single script which acts as a pass-through. It would accept an SQL query from a script on the Linux server, send it to VFP, and transmit the results back to my original script. This last part, may have to be done through a temporary MySQL table. This, as I'm sure you understand, sucks more than anything that has ever sucked before. But I have found absolutely nothing on the web that would make the two talk. I've seen something that would work through an Access database, but it's extremely poorly documented and I've never even gotten it to work.
I should mention that my knowledge of databases is fairly limited, so if someone does have an answer or a suggestion, please don't credit me with too much knowledge and be fairly specific when it comes to implementation.
I should mention that my knowledge of databases is fairly limited, so if someone does have an answer or a suggestion, please don't credit me with too much knowledge and be fairly specific when it comes to implementation.
