MichaelCrawford: The cherry trees have been in blossom for about two weeks now here. Canada's not all cold :)

Database Connectivity

Work currently involves trying to connect a PHP website on a Linux server to an MS Access database on an NT server. Don't ask why, it's government. We've investigated a few alternatives, including Easysoft's ODBC-ODBC Bridge, and right now I'm working on setting up ODBTP (http://odbtp.sourceforge.net).

Ultimately, though, I think the solution is to get rid of Access and switch to MySQL (which we use for some things already). Preliminary tests with some of our applications that are heavily database-driven have shown that there is a substantial performance hit over the old setup, where the websites were hosted on the same NT box that the databases live on.

Has anyone tried to do this sort of thing? I've got a couple more programs to try, but I'm interested in hearing about your experiences.

Thanks.