25 Mar 2004 altair   » (Observer)


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.


Latest blog entries     Older blog entries

New Advogato Features

New HTML Parser: The long-awaited libxml2 based HTML parser code is live. It needs further work but already handles most markup better than the original parser.

Keep up with the latest Advogato features by reading the Advogato status blog.

If you're a C programmer with some spare time, take a look at the mod_virgule project page and help us with one of the tasks on the ToDo list!