Linux Today: Linux News On Internet Time.

More on LinuxToday

Connecting Open Office Base Appliction to SQL

Apr 06, 2010, 03:03 (0 Talkback[s])
(Other stories by Mike Diehl)


Re-Imagining Linux Platforms to Meet the Needs of Cloud Service Providers

"In my last article, Quick and Dirty with Open Office Base, I described my initial experiences with building a simple database application for my wife in Open Office Base, having had no prior experience with the program. In that article, I described how easy it is to get started, and how easy it is to build usable software with Base. In this article, I'm going to discuss mitigating one of Base's major weaknesses by connecting it to an external SQL back-end.

"Shortly after I finished the program and demonstrated it to my wife, I encountered one of Base's major limitations. I had put the database file in a shared “Documents” directory so that both she and I would have access to the program, and that's when it happened. I returned to my desk to work on the program and received an error message indicating that the file was locked and couldn't be accessed. It turns out that Base doesn't allow concurrent access to a given database. This limitation doesn't bode well for the day when my wife's business has millions of dollars in sales and hundreds of employees! (Well, one can wish, right?)"

Complete Story

Related Stories: