Re: Re: Inquiry about OpenOffice Base
Fernand Vanrie <[email protected]> Thu, 22 Apr 2010 19:03:42 +0200
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Andrew , I will do this in the future, but for the moment we are still strugling to find our own best practices to uses OO as a frontend to our compagny databases. Fernand > On Thu, Apr 22, 2010 at 12:01 PM, Fernand Vanrie <[email protected]> wrote: > > >> Eathing is also here the proofing, I tryed different drivers to connect to >> MS databases, ADO is mostly the fastest, bud ODBC gives more posibilities to >> pases correct SQL statements. >> Trye to avoid complex queries on OO-side, make views on the MS side and >> then ADO will be fine to produce output In to de document Beamer or even >> Reports made by the Sun Report Builder. >> You must avoid complex SQL statements because it rapidly gives conflicts >> when using "Grouping" in SRB >> >> > > > Hi Fernand, > > I was just thinking that this sounds a bit like the start of a 'best > practices' type FAQ - ever thought of starting, or contributing, to such at > the wiki? > > Thanks > > Drew > > > > >> Andreas Saeger wrote: >> >> >>> Andreas Saeger wrote: >>> >>> >>>> Sheraz Naseeb wrote: >>>> >>>> >>>>> Hi there, >>>>> >>>>> Just a quick query, can you please tell me that, is this possible to >>>>> create, >>>>> edit and connect database through VS2008 using OpenOffice Base or not? >>>>> and >>>>> it would be without using MS Access files or any other database. >>>>> >>>>> Many thanks, >>>>> >>>>> Sheraz >>>>> >>>>> No, you can't. >>>>> >>> OK, one thing as a theoretical option: On a Windows machine with the >>> necessary ADO drivers and OpenOffice.org being up and running in listening >>> mode you may connect to the running office and access Access. >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [email protected] >>> For additional commands, e-mail: [email protected] >>> >>> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> >> > >