Re: Re: Inquiry about OpenOffice Base

Andrew Jensen <[email protected]> Thu, 22 Apr 2010 12:08:12 -0400
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
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]
>
>