wine users - Apr 2009 - Trying to make a Delphi database application run correctly

Hello, everybody!

First of all I have to say that I'm already posted this question in another
forum:

http://www.delphipages.com/threads/thread.cfm?ID=206179&G=206179

but as I haven't got any response from there I thought that this would be
the right
place to ask what I asked there. I really hope to get your help about this
because
I am totally new to Linux and I don't know where to go anymore.
If you read my question in the forum listed above you know that I'm trying
to run
a Delphi database application developed in Windows using Wine.

That's what I'm using in the Windows side:

- Windows XP (Service Pack 3)
- Delphi 2005
- dbExpress (I'm not using BDE, which makes things simpler)
- MS SQL Server 2000

On Linux:

- Ubunto 8.10
- Wine 1.0.1

First my application wasn't connecting to the database, but I could make it
connect
installing mdac28 with the winetricks script. All queries sent to the database
in the
application are running ok, but when I try to write something I get the
following error:

Database Server Error: [DBNETLIB][ConnectionRead (Error SIO_KEEPALIVE_VALS()).]
General network error. Check your network documentation.

I changed the Windows version in Wine to Windows 98 and tried to install jet40
using
winetricks, but I'm getting an error. That's how I proceed and the error
messages
that I get:

marcos at marcos:~$ sudo su

root at marcos:/home/marcos# sh winetricks jet40
Executing wine /root/.winetrickscache/jet40sp8_9xnt.exe
fixme:ntdll:find_reg_tz_info Can't find matching timezone information in the
registry for bias 180, std (d/m/y): 0/00/0000, dlt (d/m/y): 0/00/0000
fixme:ntdll:find_reg_tz_info Can't find matching timezone information in the
registry for bias 180, std (d/m/y): 0/00/0000, dlt (d/m/y): 0/00/0000
fixme:setupapi:extract_cabinet_file awful hack: extracting cabinet
"C:\\windows\\temp\\IXP001.TMP\\Jetsetup.CAB"
err:ole:TLB_ReadTypeLib Loading of typelib L"C:\\Program files\\Common
files\\Microsoft shared\\dao\\dao2535.tlb" failed with error 2
Install of jet40 done
winetricks done.

I want to to install jet40 just to try if the error that I'm getting in the
application
will disappear, but I'm just guessing this.
I also want to tell you that I run my application using winefile.

I would be very thankful if someone could help me with this issue.

Thank you.

Marcos

marcos_antonio_ps wrote:
> - Wine 1.0.1
This is too old, upgrade.

[quote="marcos_antonio_ps"]marcos at marcos:~$ sudo
su[quote="marcos_antonio_ps"]
DO NOT!!! run Wine as root!!!

On Mon, 2009-04-20 at 08:13 -0500, marcos_antonio_ps wrote:
> If you read my question in the forum listed above you know that I'm
trying to run
> a Delphi database application developed in Windows using Wine.
Database apps on Linux. My favourite topic :)

2 points.

Firstly, Borland have a Linux version of Delphi, called Kylix. I bought
Kylix version 1 ( and was pretty disappointed with it to be honest ).
But later versions may have improved. Interestingly, Kylix was mostly
Delphi on wine anyway. I think they've ported more of it to run native
now. If you want to try running under Kylix, email me.

Secondly, if you haven't invested too heavily in Delphi yet, I recommend
checking out my Perl projects: Gtk2::Ex::DBI, Gtk2::Ex::Datasheet::DBI
and PDF::ReportWriter. All are available on CPAN. We website is cactus
at the moment ( story of my life ). All are open-source, cross-platform
libraries that provide a nice environment for building database
front-ends. Speaking from experience, Perl is *way* better than Object
Pascal. Brings back some memories though :)

Dan

Daniel Kasak wrote:
> But later versions may have improved.
What later versions? There wasn't any. Kylix died before learning to crawl.

On Mon, 2009-04-20 at 08:13 -0500, marcos_antonio_ps wrote:
> If you read my question in the forum listed above you know that I'm
trying to run
> a Delphi database application developed in Windows using Wine.
Further to my suggestion on Kylix, I've just come across this:
http://en.wikipedia.org/wiki/Lazarus_(software)

It's a linux clone of Delphi. Can't comment on it's quality /
usability / compatibility ( obviously, as I haven't used it ), except to
quote:

"Under Linux, Delphi source code can be compiled with Lazarus with a
little adaptation."

Dan

Hello, Daniel. Thanks for you reply. I'm sorry for the delay. Just now I had
a look at the forum because I'm not working today.
Well, I have already heard of Kylix since the early beginning, but I'm not
considering giving it a try now because I don't have the time to make any
changes to my application right now (and I know I would need to do some). I just
need to make it run on Linux and Wine seems a good choice. Besides the error
when I try to post something to the database, everything else is working ok.
Tomorrow I will start looking at upgrading to a new version of Wine as suggested
by vitamin. Thank you once again.

Marcos

One last question before upgrading Wine: I installed ODBC (mdac28) and a fake
IE6 using winetricks . Do I have to uninstall them before upgrading or they will
be remove automatically when I uninstall my current Wine version?

marcos_antonio_ps wrote:
> One last question before upgrading Wine: I installed ODBC (mdac28) and a
fake IE6 using winetricks . Do I have to uninstall them before upgrading or they
will be remove automatically when I uninstall my current Wine version?
There is no way to uninstall them.

It is recommended to remove ~/.wine whenever you do a big version change. Or
when doing any sort of troubleshooting to "start clean".