PDA

View Full Version : Linux Terminal Server accessing Pervasive database



Archie Campbell
4-Feb-2005, 12:31 AM
I have a customer who runs NT Terminal server with 20 users.
They run a DF31 console mode application that accesses a Pervasive
database on a Novell server.

I am in the process of migrating them away from Microsoft.
They currently use Open Office, FireFox and Thunderbird.

My problem is with the DF31 application.
I want it to run under Linux.
I could convert to IBM's DB2 or MySQL or Postgre.

But what if I want to stay with Pervasive. There is no CK for Linux and
Pervasive.

Maybe I can run the Windows DF32 console mode and CK application on
Linux with WINE installed.
Or not ;-)

Has anyone tried this?

Thanks
Archie

Joerg Thuemmler
4-Feb-2005, 01:45 AM
Archie Campbell wrote:
> I have a customer who runs NT Terminal server with 20 users.
> They run a DF31 console mode application that accesses a Pervasive
> database on a Novell server.
>
> I am in the process of migrating them away from Microsoft.
> They currently use Open Office, FireFox and Thunderbird.
>
> My problem is with the DF31 application.
> I want it to run under Linux.
> I could convert to IBM's DB2 or MySQL or Postgre.
>
> But what if I want to stay with Pervasive. There is no CK for Linux and
> Pervasive.
>
> Maybe I can run the Windows DF32 console mode and CK application on
> Linux with WINE installed.
> Or not ;-)
>
> Has anyone tried this?
>
> Thanks
> Archie

I didn't try this, but I'm sure it's not a good way. wine is "alpha"
until now and lots of problems with complex programs are reported. I
don't know but feels not good to pass all your database traffic
through any emulator. I tried just now to run an old df 2.3b with
wine, it didn't want to run my dflex.bat batch file ... didn't want
to run dfquery (no matter if this would have stopped with any error
because of the needed pathes...) Earlier tried 2.3b with dosemu,
runs but extremly slow on a fast machine...
I even wouldn't test this solution. If really in need, give vmware
or win4lin a try, which are commercially used but the better is to
run a native DB.

I found the dataflex db fast and stable on 2.2 kernels, have now
some problems which seem to be related with 2.4 kernels (I tested a
lot, SuSE and Debian, all show slowdown program loading if more
users attached, something with the cpu time sharing to new processes
I believe after some testing, although the programs run *very* fast,
when started).
But last days I gave 2.6 kernel (SuSEs 9.1) a try and seems it's a
lot better with program starting. All tested with 3.1d, but the 3.2
demo showed the same behavior when I gave a try at a 2.4
kernel...

If the dataflex db isn't what you want you should migrate to one of
db2, mysql, postgre ...

joerg

Archie Campbell
4-Feb-2005, 12:30 PM
Joerg Thuemmler wrote:
> Archie Campbell wrote:
>
>> I have a customer who runs NT Terminal server with 20 users.
>> They run a DF31 console mode application that accesses a Pervasive
>> database on a Novell server.
>>
>> I am in the process of migrating them away from Microsoft.
>> They currently use Open Office, FireFox and Thunderbird.
>>
>> My problem is with the DF31 application.
>> I want it to run under Linux.
>> I could convert to IBM's DB2 or MySQL or Postgre.
>>
>> But what if I want to stay with Pervasive. There is no CK for Linux
>> and Pervasive.
>>
>> Maybe I can run the Windows DF32 console mode and CK application on
>> Linux with WINE installed.
>> Or not ;-)
>>
>> Has anyone tried this?
>>
>> Thanks
>> Archie
>
>
> I didn't try this, but I'm sure it's not a good way. wine is "alpha"
> until now and lots of problems with complex programs are reported. I
> don't know but feels not good to pass all your database traffic through
> any emulator. I tried just now to run an old df 2.3b with wine, it
> didn't want to run my dflex.bat batch file ... didn't want to run
> dfquery (no matter if this would have stopped with any error because of
> the needed pathes...) Earlier tried 2.3b with dosemu, runs but extremly
> slow on a fast machine...
> I even wouldn't test this solution. If really in need, give vmware or
> win4lin a try, which are commercially used but the better is to run a
> native DB.
>
> I found the dataflex db fast and stable on 2.2 kernels, have now some
> problems which seem to be related with 2.4 kernels (I tested a lot, SuSE
> and Debian, all show slowdown program loading if more users attached,
> something with the cpu time sharing to new processes I believe after
> some testing, although the programs run *very* fast, when started).
> But last days I gave 2.6 kernel (SuSEs 9.1) a try and seems it's a lot
> better with program starting. All tested with 3.1d, but the 3.2 demo
> showed the same behavior when I gave a try at a 2.4
> kernel...

> If the dataflex db isn't what you want you should migrate to one of
> db2, mysql, postgre ...
>
> joerg

Hi Joerg
Thanks for the reply
I will approach cautiously.

The database works just fine. The problem is that there is no CK to
access it from Linux DFlex.

Marco
6-Feb-2005, 06:08 PM
Archie,

Just bite the bullet and go for IBM...

As for pervasive, I thought at some stage they did have a driver on
Linux, but the DataFlex app and the pervasive app must be on the same
physical machine. You might want to check that with DAW though.

Cheers,
Marco


On Fri, 04 Feb 2005 11:30:56 -0600, Archie Campbell
<archie@accordsystems.com> wrote:

>Joerg Thuemmler wrote:
>> Archie Campbell wrote:
>>
>>> I have a customer who runs NT Terminal server with 20 users.
>>> They run a DF31 console mode application that accesses a Pervasive
>>> database on a Novell server.
>>>
>>> I am in the process of migrating them away from Microsoft.
>>> They currently use Open Office, FireFox and Thunderbird.
>>>
>>> My problem is with the DF31 application.
>>> I want it to run under Linux.
>>> I could convert to IBM's DB2 or MySQL or Postgre.
>>>
>>> But what if I want to stay with Pervasive. There is no CK for Linux
>>> and Pervasive.
>>>
>>> Maybe I can run the Windows DF32 console mode and CK application on
>>> Linux with WINE installed.
>>> Or not ;-)
>>>
>>> Has anyone tried this?
>>>
>>> Thanks
>>> Archie
>>
>>
>> I didn't try this, but I'm sure it's not a good way. wine is "alpha"
>> until now and lots of problems with complex programs are reported. I
>> don't know but feels not good to pass all your database traffic through
>> any emulator. I tried just now to run an old df 2.3b with wine, it
>> didn't want to run my dflex.bat batch file ... didn't want to run
>> dfquery (no matter if this would have stopped with any error because of
>> the needed pathes...) Earlier tried 2.3b with dosemu, runs but extremly
>> slow on a fast machine...
>> I even wouldn't test this solution. If really in need, give vmware or
>> win4lin a try, which are commercially used but the better is to run a
>> native DB.
>>
>> I found the dataflex db fast and stable on 2.2 kernels, have now some
>> problems which seem to be related with 2.4 kernels (I tested a lot, SuSE
>> and Debian, all show slowdown program loading if more users attached,
>> something with the cpu time sharing to new processes I believe after
>> some testing, although the programs run *very* fast, when started).
>> But last days I gave 2.6 kernel (SuSEs 9.1) a try and seems it's a lot
>> better with program starting. All tested with 3.1d, but the 3.2 demo
>> showed the same behavior when I gave a try at a 2.4
>> kernel...
>
>> If the dataflex db isn't what you want you should migrate to one of
>> db2, mysql, postgre ...
>>
>> joerg
>
>Hi Joerg
>Thanks for the reply
>I will approach cautiously.
>
>The database works just fine. The problem is that there is no CK to
>access it from Linux DFlex.
>
>
>

Archie Campbell
11-Feb-2005, 05:14 PM
Yes, I just might do that Marco.
You will be the 1st to know ;-)

For a while Pervasive has a Linux Server but it was only accessable from
Windows clients. Then they released a Linux client driver. DAW has not
released a Linux client driver.

A


Marco Kuipers wrote:
> Archie,
>
> Just bite the bullet and go for IBM...
>
> As for pervasive, I thought at some stage they did have a driver on
> Linux, but the DataFlex app and the pervasive app must be on the same
> physical machine. You might want to check that with DAW though.
>
> Cheers,
> Marco
>
>
> On Fri, 04 Feb 2005 11:30:56 -0600, Archie Campbell
> <archie@accordsystems.com> wrote:
>
>
>>Joerg Thuemmler wrote:
>>
>>>Archie Campbell wrote:
>>>
>>>
>>>>I have a customer who runs NT Terminal server with 20 users.
>>>>They run a DF31 console mode application that accesses a Pervasive
>>>>database on a Novell server.
>>>>
>>>>I am in the process of migrating them away from Microsoft.
>>>>They currently use Open Office, FireFox and Thunderbird.
>>>>
>>>>My problem is with the DF31 application.
>>>>I want it to run under Linux.
>>>>I could convert to IBM's DB2 or MySQL or Postgre.
>>>>
>>>>But what if I want to stay with Pervasive. There is no CK for Linux
>>>>and Pervasive.
>>>>
>>>>Maybe I can run the Windows DF32 console mode and CK application on
>>>>Linux with WINE installed.
>>>>Or not ;-)
>>>>
>>>>Has anyone tried this?
>>>>
>>>>Thanks
>>>>Archie
>>>
>>>
>>>I didn't try this, but I'm sure it's not a good way. wine is "alpha"
>>>until now and lots of problems with complex programs are reported. I
>>>don't know but feels not good to pass all your database traffic through
>>>any emulator. I tried just now to run an old df 2.3b with wine, it
>>>didn't want to run my dflex.bat batch file ... didn't want to run
>>>dfquery (no matter if this would have stopped with any error because of
>>>the needed pathes...) Earlier tried 2.3b with dosemu, runs but extremly
>>>slow on a fast machine...
>>>I even wouldn't test this solution. If really in need, give vmware or
>>>win4lin a try, which are commercially used but the better is to run a
>>>native DB.
>>>
>>>I found the dataflex db fast and stable on 2.2 kernels, have now some
>>>problems which seem to be related with 2.4 kernels (I tested a lot, SuSE
>>>and Debian, all show slowdown program loading if more users attached,
>>>something with the cpu time sharing to new processes I believe after
>>>some testing, although the programs run *very* fast, when started).
>>>But last days I gave 2.6 kernel (SuSEs 9.1) a try and seems it's a lot
>>>better with program starting. All tested with 3.1d, but the 3.2 demo
>>>showed the same behavior when I gave a try at a 2.4
>>>kernel...
>>
>>>If the dataflex db isn't what you want you should migrate to one of
>>>db2, mysql, postgre ...
>>>
>>>joerg
>>
>>Hi Joerg
>>Thanks for the reply
>>I will approach cautiously.
>>
>>The database works just fine. The problem is that there is no CK to
>>access it from Linux DFlex.
>>
>>
>>
>
>