David Guest wrote: > I've returned to this, this week-end after wandering in a Windows > wonderland for the last few months. It's good to be back. > > I have reviewed where we got up and been through the HCN database tables > so I have a fairly rough idea of where everything is. I'll look at > refining my searches next week-end. > > I have sketched out my understanding of the use of OOo.Base for querying > the HCN database using an ODBC driver at > http://zeeclor.mine.nu/npcc/index.php/Medical_Director but would be > pleased if Tony E, Richard H or Syan could make corrections and > suggestions. (Even Kuangie might be able to help me get the best out of > those docle codes. :-) >
The page looks good and has the potential to be a very useful resource David. I had a quick look around the hsql site and google but cannot find any windows ODBC or ADO.net drivers for base or HSQL. If that is correct it is worth pointing out that ms Access tables can do the same thing but has that advantage of those connectivity options. If you believe as I do that simple web based "EHR surfing" is the way to get the best value out of the stored data then this is an important consideration. You don't actually need MS access on each windows webserver running the web application, just on the development machine to create the deployable .mdb file which links to MD/PS tables and to any other persistent data accessed by or created within the application. Tony Eviston _______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
