ISTech Support Forum - ODBC, PSQL, Linux

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	ODBC, PSQL, Linux 03/17/08 at 09:20:55 We have a Linux Intranet Server that runs on ubuntu and uses pervasive 8.X client. We are planning to upgrade our Pervasive Server to Version 10 Do you know if from Linux/Pervasive Client 9.5 you can connect to PSQL V10? Regards, Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

kkmfg Senior Member Ghost of the code Posts: 411 Gender:	Re: ODBC, PSQL, Linux Reply #1 - 03/18/08 at 04:08:24 It doesn't on the surface sound like a good idea... They've got a 10.10 beta out now that seems to support a linux client. Will that work for you?
Back to top	Collin K & K Manufacturing, Inc EvoERP Version 1-22-10 SP3 5 User Workgroup Pervasive 10 IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: ODBC, PSQL, Linux Reply #2 - 03/18/08 at 12:26:03 uhhh, didnt know that. I will try it. thanks Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 785
Gender: male

Re: ODBC, PSQL, Linux
Reply #3 - 04/30/08 at 03:44:48

Yes, it does works. You can connect PSQL V9 on an ubuntu server to a PSQL V10 on a windows server.

On a side note, I did manage to run EVO on Winxp workstation connected to an ubuntu server via samba. But there are some weird errors, so I gave up, all TAS related I believe.

By the way, psql on a ubuntu server runs very well and very fast.

I keep notes of the entire installation process, if you want them, email me.

Something to put on my resume anyways lips sealed

Regards,

Kelloggs

Back to top

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

kkmfg

Senior Member

Ghost of the code

Posts: 411
Gender: male

Re: ODBC, PSQL, Linux
Reply #4 - 04/30/08 at 04:24:21

Just to be sure I have this right:

You are saying that connecting linux as a client to a windows Pervasive server works fine but that using linux as the server and windows as the client does not?

Quote from Kelloggs on 04/30/08 at 03:44:48:

Yes, it does works. You can connect PSQL V9 on an ubuntu server to a PSQL V10 on a windows server.

On a side note, I did manage to run EVO on Winxp workstation connected to an ubuntu server via samba. But there are some weird errors, so I gave up, all TAS related I believe.

By the way, psql on a ubuntu server runs very well and very fast.

I keep notes of the entire installation process, if you want them, email me.

Something to put on my resume anyways lips sealed

Regards,

Kelloggs

Back to top

Collin
K & K Manufacturing, Inc

EvoERP Version 1-22-10 SP3
5 User Workgroup Pervasive 10

IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 785
Gender: male

Re: ODBC, PSQL, Linux
Reply #5 - 04/30/08 at 08:57:43

The Pervasive Server on Ubuntu runs very well.
I created a Database using dbmaint, then copy the DBAMFG/Default to the /usr/local/psql/data/EVO
The PSQL V9 did not have any issues, and I was able to query the database both from a linux client and a windows client.

A query that takes 10 seconds on a Windows Server, takes on Linux 5 seconds, about half as an average.

----------------

I did setup a Windows Workstation connected to Pervasive on a Linux Server, and I was able to run Evo via samba (The entire DBAMFG directory was on Linux)
Lots of "Access Violation...." all of them pointing to tp7runtime.exe, especially when posting Work Orders and PO's

It was a good learning experience, but it is not worth the trouble. EVO has enough issues as it is.

Wink

Kelloggs

Back to top

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged