Home > Archive > Clipper > February 2008 > Adwantage Database Server ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Adwantage Database Server ?
|
|
|
| Hello
Small question, we developed our own clipper application since years. We are using Clipper 5.2e, Blinker 7.0 and Comix 3.0.
All Data's are on a SBS 2003 Server. Every think work well like this.
But I have to include 2 PC thought a SDSL data transmission (about 2-3Mbps). Actually not installed!
I think I will have Performance problem, why the raison to check the Advantage Database Server option.
Question :
- It is difficult to set up this Database Engine on a SBS Server ?
- I have about 20 tables with many index's to move. Are they any tools to do that ?
- News are telling, that no or very less changes do in Clipper PRG. Is that right ?
Many thanks in advance for any help
Otto
| |
| Massimo Belgrano 2008-02-28, 6:55 pm |
| Ads not have any problem on sbs server
an open source product is leto db
i suggest try a very easy recompilation in xharbour 32 bit clone
"otto" <ohaldi@freesurf.ch> ha scritto nel messaggio
news:ncrir3lchqpj59ibvc6u10g1m9082j60k5@
4ax.com...
> Hello
>
> Small question, we developed our own clipper application since years. We
> are using Clipper 5.2e, Blinker 7.0 and Comix 3.0.
> All Data's are on a SBS 2003 Server. Every think work well like this.
>
> But I have to include 2 PC thought a SDSL data transmission (about
> 2-3Mbps). Actually not installed!
>
> I think I will have Performance problem, why the raison to check the
> Advantage Database Server option.
>
> Question :
> - It is difficult to set up this Database Engine on a SBS Server ?
> - I have about 20 tables with many index's to move. Are they any tools to
> do that ?
> - News are telling, that no or very less changes do in Clipper PRG. Is
> that right ?
>
> Many thanks in advance for any help
> Otto
>
| |
| tom knauf 2008-02-29, 6:55 pm |
| Hi Otto,
setup : we had setup ads on sbs server without problems
Tools to move : If you use CDX Indices and FPT memos a reindex (or better
rebuild the index) should be all all you need
changes in code : I only know 5.3, donīt know about rddset() in 5.2. In 5.3
its only a "request dbfcdxax" and a rddsetdefault() instead of dbfcdx and
some libs/files in the blinker link script
Thats it and works fine for years now.
HTH
Tom
"otto" <ohaldi@freesurf.ch> schrieb im Newsbeitrag
news:ncrir3lchqpj59ibvc6u10g1m9082j60k5@
4ax.com...
> Hello
>
> Small question, we developed our own clipper application since years. We
> are using Clipper 5.2e, Blinker 7.0 and Comix 3.0.
> All Data's are on a SBS 2003 Server. Every think work well like this.
>
> But I have to include 2 PC thought a SDSL data transmission (about
> 2-3Mbps). Actually not installed!
>
> I think I will have Performance problem, why the raison to check the
> Advantage Database Server option.
>
> Question :
> - It is difficult to set up this Database Engine on a SBS Server ?
> - I have about 20 tables with many index's to move. Are they any tools to
> do that ?
> - News are telling, that no or very less changes do in Clipper PRG. Is
> that right ?
>
> Many thanks in advance for any help
> Otto
| |
|
| On Fri, 29 Feb 2008 15:49:34 +0100, "tom knauf" <hbgmail@pdtgmbh.de> wrote:
Hi Tom,
Thanks for your information's. But after a check on the Sybase webside I saw that Advantage are to expensive for a small company.
Regards
Otto
>Hi Otto,
>
>setup : we had setup ads on sbs server without problems
>Tools to move : If you use CDX Indices and FPT memos a reindex (or better
>rebuild the index) should be all all you need
>changes in code : I only know 5.3, donīt know about rddset() in 5.2. In 5.3
>its only a "request dbfcdxax" and a rddsetdefault() instead of dbfcdx and
>some libs/files in the blinker link script
>
>Thats it and works fine for years now.
>
>HTH
>Tom
>
>
>"otto" <ohaldi@freesurf.ch> schrieb im Newsbeitrag
> news:ncrir3lchqpj59ibvc6u10g1m9082j60k5@
4ax.com...
>
| |
|
| On Thu, 28 Feb 2008 22:05:59 +0100, "Massimo Belgrano" <mbelgranoRIMUOVI@deltain.com> wrote:
>Ads not have any problem on sbs server
>an open source product is leto db
>i suggest try a very easy recompilation in xharbour 32 bit clone
>
I never head something about leto db. Does it work only wit xHarbour ?
[color=darkred]
>"otto" <ohaldi@freesurf.ch> ha scritto nel messaggio
> news:ncrir3lchqpj59ibvc6u10g1m9082j60k5@
4ax.com...
| |
| Klas Engwall 2008-02-29, 6:55 pm |
| Otto,
>I never head something about leto db. Does it work only wit xHarbour ?
Look it up at Sourceforge, and google for the few pages about it that
exist. It looks like an interesting project, and it is under
development by a group of people with an excellent reputation in the
(x)Harbour world. But it is way too early to use it for any production
work. Release 0.1 is only a month old (there have been a couple of
incremental releases since then), so there is still a lot left on the
developers' to-do-list.
Regards,
Klas
-------
klas dot engwall at engwall dot com
http://www.engwall.com/clipper/
The LFN Library for Clipper
The LanMan Library for Clipper
The NFPAT1A Timeslice release patch for the Nanforum Toolkit
|
|
|
|
|