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]
>>
>>
>>     
>
>