| Author |
|
AllanMar
Groupie
Joined: April 02 2007
Online Status: Offline
Posts: 45
|
| Posted: February 18 2009 at 18:51 | IP Logged
|
|
|
I was just wondering if anyone had any luck running PowerHome on linux via wine.
Getting the error:
Database Connection Error 999
The allocation of the environmental handle has failed.
I realize Linux isnt supported, but any chance you (Dave) could chime in with the specific windows component requirements powerhome needs?
Thanks,
-Allan
|
| Back to Top |
|
| |
Gadgets
Senior Member
Joined: January 28 2008
Location: Canada
Online Status: Offline
Posts: 178
|
| Posted: March 17 2009 at 20:13 | IP Logged
|
|
|
I'm taking the silence as a no? I just logged on to look into this very question. 
__________________
Friends, don't let friends install Norton Products
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: March 22 2009 at 00:00 | IP Logged
|
|
|
Im not familiar with anyone running PH on Linux, but do know of people running it on a MAC (which I figured would have been more difficult to get running).
Anyways, the error you're getting has to do with the launching of the Adaptive Server Anywhere database. If you could get it running, then you have a shot at PH working. The database is ASA version 7.03 from Sybase. I don't know of any specific reason why it wouldnt work under Linux but have no idea how to determine what would be needed  .
Dave.
|
| Back to Top |
|
| |
Gadgets
Senior Member
Joined: January 28 2008
Location: Canada
Online Status: Offline
Posts: 178
|
| Posted: March 22 2009 at 01:40 | IP Logged
|
|
|
Thanks Dave,
This sounds like it could be worth experimenting with. We use 90% Ubuntu (Linux) at work because Windows can't handle what we do, and although I'm still a total NOOB working with it, I am getting there... I sort of have to, I keep the technical side of things running  . I run windows here at home, but I've been thinking about switching my server to Linux for the increased speed, and that's where PH currently resides. Maybe in a few weeks when I get some time, I'll build a basic Linux box and try PH on it, would be awesome if it works. If I happen to make it work, I'll post all details in case someone else wants to take a stab at it.
Brian
__________________
Friends, don't let friends install Norton Products
|
| Back to Top |
|
| |
AllanMar
Groupie
Joined: April 02 2007
Online Status: Offline
Posts: 45
|
| Posted: April 20 2009 at 17:01 | IP Logged
|
|
|
There is some scattered reports of people running Powerbuilder apps under wine. I had stopped checking this thinking I wasnt going to get an answer.
Dave: Could you "Then, using PowerBuilder on a Windows machine, create a package to install the PowerBuilder runtimes; use the tool in the Program files/sybase/PowerBuilder 11/PowerBuilder runtime packager."
I imagine these are probably included in the powerhome install, but this may help. Thanks.
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: April 20 2009 at 21:18 | IP Logged
|
|
|
Allan,
Just to clarify, are you asking for me to create a separate installer for just the PowerBuilder runtimes?
You are correct that all PowerBuilder runtimes are already included as part of the PowerHome install but if this is causing problems, then I can certainly make a package that contains just the PowerBuilder runtimes that PowerHome uses. There are ALOT of PB runtime files but PH only uses a few. I don't know what would be better though, just a simple zip file containing the runtimes or an MSI file containing the runtime files.
Keep in mind that the PB runtime packager you reference does not include the SQL Anywhere runtimes which are also a part of the PH install and what seemed to be the problem for Brian.
Let me know and I'll do what I can to help.
Dave.
|
| Back to Top |
|
| |
AllanMar
Groupie
Joined: April 02 2007
Online Status: Offline
Posts: 45
|
| Posted: April 21 2009 at 05:50 | IP Logged
|
|
|
Yea, I was hoping for a separate installer. Installer would work over a zip Id say. I thought this included the SQLAnywhere run times, is there some sort of package for those? Installers are fine, as they will run under WINE.
Is there some way to get just the ASA server for powerhome? Is there a log or something for ASA that might show why it's not starting?
|
| Back to Top |
|
| |
AllanMar
Groupie
Joined: April 02 2007
Online Status: Offline
Posts: 45
|
| Posted: April 22 2009 at 13:56 | IP Logged
|
|
|
So I go this from process manager on how the database is run:
rteng7.exe -c 8m -ga "c:\program files\powerhome\database\pwrhome.db" "-hn0,1788:208"
Running this under wine, ASA comes up just fine and runs. And powerhome runs through its initlation up to the database just fine. So it seems both apps will run under wine.
I guess the problem lays in how powerhome is starting the db/trying to connect to it. Any thoughts Dave?
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: April 22 2009 at 22:21 | IP Logged
|
|
|
Hmmm...the ASA command line looks pretty good. The actual command (embedded within PH) looks something like this: rteng7.exe -c 8m
with the rest of the parameters being supplied by the environment.
What puzzles me is that PH launches and runs (up to DB connect) and the ASA launches and runs fine but PH cannot connect. If you are able to launch the ASA database and have it running beforehand and then launch PH, PH should automatically connect to the already running database. If this is not happening, it would appear that the connection to the database is failing (versus starting the DB...if we can get the connection going, we can worry about the launching later). Im pretty sure communication to/from the database is done via sockets and specific ports (unfortunately, I don't know what ports are used).
When ASA is launched under Windows, you get a tray icon that can be double-clicked to give the details of the ASA server application. Is this accessible under WINE?
Dave.
|
| Back to Top |
|
| |
AllanMar
Groupie
Joined: April 02 2007
Online Status: Offline
Posts: 45
|
| Posted: April 23 2009 at 06:09 | IP Logged
|
|
|
Yep, it defiantly appears to be an inter-connection problem. The ASA status tray icon/window is available and it shows no errors or anything, says ready for connections (I didnt bother to copy and paste it, it appears just like my XP machine does).
I was wondering if it would connect to ASA if already running, launching ASA and then launching PH gives the same environment handle error.
Could this be a problem with the loading of the DLL's? Would PH throw a error if it couldnt load one of them? One of the problems sometimes with WINE is because Linux is case-sensitive and windows is not, DLL loading will fail because applications used different caps in the filename than whats in wine's system32 folder.
|
| Back to Top |
|
| |
rboyleiii
Newbie
Joined: January 15 2008
Location: United States
Online Status: Offline
Posts: 11
|
| Posted: May 12 2009 at 22:47 | IP Logged
|
|
|
I found this thread intriguing so I decided to do some tinkering myself.
I got the same as error as above.... and then thought wait, MDAC is not installed on wine by default.
After downloading MDAC and installing it I still got the same error until I added some dll overrides for it to the registry, then a new error:
SQLSTATE=IM002 Microsoft ODBC Driver Manager error
Next step, I ran ODBC administrator and saw there was no Adaptive Server Anywhere ODBC driver.
Copied the dlls from my windows machine and edited the registry to add the ODBC driver.
And now Power Home starts the database on its own, runs through the main splash screen, and then displays an error dialog:
A critical error occurred at 2009-05-12 22:32:02.202.
PowerHome Version: 2.1b
Error Number: 35
Error Message: Error calling external object function <unknown> at line 8 in function f_initialize of object uo_broadcast.
Window: uo_broadcast
Object: uo_broadcast
Event: f_initialize
Line: 8
Also about 10 regsvr32 window/consoles fire off after the error dialog is displayed.
Any advice on where to look next Dave?
Edited by rboyleiii - May 12 2009 at 22:51
|
| Back to Top |
|
| |
rboyleiii
Newbie
Joined: January 15 2008
Location: United States
Online Status: Offline
Posts: 11
|
| Posted: May 12 2009 at 23:20 | IP Logged
|
|
|
Seems that Wine needs a lot of things installed, this is what I have installed so far:
MDAC, ASA ODBC driver, IE, MFC, WSH and Rich Text Editor Support 
And.... It is up and running on Ubuntu!
I will have to move my PLM to the Linux machine to test connectivity and serial port operation, but just seeing the main application working is a nice site! 
I will post more after testing in the next couple of days.
|
| Back to Top |
|
| |
AllanMar
Groupie
Joined: April 02 2007
Online Status: Offline
Posts: 45
|
| Posted: May 13 2009 at 08:43 | IP Logged
|
|
|
I've used serial ports and even USB->Serial on WINE before. There is a few extra steps to map the linux device to COM1,COM2, etc (Mayb done automatically in newer WINE). Better tutorials than I could describe out there.
I thought I had installed MDAC, any chance you could give more details on what you had done...and specific DLL's if possible.
|
| Back to Top |
|
| |
rboyleiii
Newbie
Joined: January 15 2008
Location: United States
Online Status: Offline
Posts: 11
|
| Posted: May 13 2009 at 21:25 | IP Logged
|
|
|
How did you install mdac, if you download the install from Microsoft and ran it there are some edit you need to make to the registry:
[HKEY_CURRENT_USER\Software\Wine\DllOverrides]
"odbc32"="native,builtin"
"odbccp32"="native,builtin"
If you use an application like wine-doors it makes the edits for you when installing the software. (this is how I installed IE6 and all the other dependency I listed) (However, they have taken their repositories off-line, so I had to build my own locally, that is another story...)
As far as the Adaptive server anywhere driver:
Make sure you have:
dbodbc7.dll
dblgen7.dll
dbcon7.dll
in the system32 directory and then add the following registry entries:
# Create the registry key:
# HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\Adaptive Server Anywhere 7.0
# Add the following values under the new key:
Name Type Valu e
Driver Reg_SZ c:\windows\system32\dbodbc7.dll
Setup Reg_SZ c:\windows\system32\dbodbc7.dll
# Create the registry key:
HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\ODBC Drivers
# Add the following values under the new key:
Name - Type - Value
Adaptive Server Anywhere 7.0 Reg_SZ Installed
That is the process I used to get it up and running.
I have plugged in my PLM(Serial) to a serial port native on the computer and no problems, works like a champ! I am sure that if you use a usb plc or a usb > serial adapter, it will require links to be made for it to work.
(I am running Wine 1.0.1 on Ubuntu 9.04 Jaunty Jackalope)
I still have about 15 regsvr32 command windows fire off when starting PH, but they go away in a few seconds.
If you have any more questions, I will be glad to help!
HTH
Edited by rboyleiii - May 13 2009 at 23:34
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: May 14 2009 at 22:44 | IP Logged
|
|
|
Richard,
EXCELLENT WORK!!!
The regsvr32 statements are normal as PH tries to re-register all of its components everytime it starts. However, you can disable this behaviour by opening PowerHome Explorer and navigating to PowerHome|Setup|Preferences and unchecking "Register ActiveX @ Startup".
Keep us posted on any new discoveries or progress. Very glad to hear you were able to get this working.
Dave.
|
| Back to Top |
|
| |
williammanda
Groupie
Joined: December 03 2008
Location: United States
Online Status: Offline
Posts: 84
|
| Posted: May 27 2009 at 13:15 | IP Logged
|
|
|
rboyleiii
Please keep us posted of your progress. I would love to have Powerhome run on Ubuntu via usb > serial adapter.
Thanks
|
| Back to Top |
|
| |
rboyleiii
Newbie
Joined: January 15 2008
Location: United States
Online Status: Offline
Posts: 11
|
| Posted: June 25 2009 at 22:55 | IP Logged
|
|
|
So far, running PH on Wine is very sluggish, there always seems to be waiting periods, it seems to be related to the the amount of database access needed. I have had it stop responding for several minutes on occasion. With PH running on Wine, my system was always using 60% or more of both my CPU's.
The overall performance of Wine running PH left me abandoning the idea for now.
I would like to say that there is still hope for those who want to run a flavor of Linux as their main OS and they own a valid copy of 2000, XP or Vista.
I have been testing an installation of PH with Sun's VirtualBox and I am very happy with the results so far. It uses a lot more of the system memory (500MB vs 250MB, I have 250MB reserved for the XP Virtual Machine, This could be reduced as in task manager it reports it is only using 100MB) but performance is outstanding, not sluggish and just as fast as running on Windows natively. (Well with VB it is natively I guess ;-) )
I have attached screen shots of PH running on both.....
Wine:
VirtualBox:
Edited by rboyleiii - June 26 2009 at 08:59
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: Powerhome on Linux Via WINE
