in reply to COM Objects and the need to know more

we have a Foxpro Application and need to share data accross the web and read it in to a MySQL DB. After a user has edited it (no problem there) it should be transferred back.
I guess using Foxpro is the real wtf here =)

Anyway, as already stated you cannot use OLE on the linux server side easily, so I suggest that you create some kind of Server/API on the application machine and let your webserver communicated with that, instead of directly to the DB. Then you can use any protocoll you want and you abstract away database specicfic code on your webserver.

You get the idea. The possibilities for implementing this are endless. Chose from plain get/post, soap, xml-rpc, csv, or whatever for transportation and HTTP::Server::Simple, Catalyst, Jifty, etc. for the code. Writing a simple CRUD application with one of the advanced frameworks is a piece of cake. You should be able to set one up within minutes. While I'm at it, I think I should also point you at DBD::Xbase, just in case you didn't already know about it.

update: I forgot to mention, if you for whatever reason still need to use COM and OLE (yes they belong together) have a look at the Perl Dev Kit


holli, /regexed monk/