Getting a proprietary Win32 application running on Wine

[RUMI Szabolcs]

Hello there!

I'm trying to get a proprietary business application running.
It is basically a kind of a special small business accounting
app which can be used in a distributed manner. If it is configured
this way, the server installation is running an MSSQL server
instance locally to store the data, while a client installation
just uses the remote server installation (apparently directly
connects to the remote MSSQL instance). I'd be very happy if
I could get at least a client installation running under Wine
while running the server installation under a real Windows
environment.

The client software package installs under Wine seamlessly.
When started, it crashes with an exception until I install
Microsoft Database Engine. With MSDE installed the program
does start up but stops immediately with an error dialog
basically saying that it cannot connect to the database.
From a quick .exe strings analysis I believe it has been
coded in Borland Delphi.

Well, it is possible that this is only some network level
issue (LMHOSTS lookup failing or whatever) but realistically
I suspect that there could be some deeper problem than that
as the program fails to create some OLE objects etc.

How do I start to make it work?

I can send a Wine debug log if somebody with a clue would
be so kind to look into it...

Thanks,

Sab

[austin987]

On Wed, Mar 18, 2009 at 4:36 AM, RUMI Szabolcs <[email protected]> wrote:

Hello there!

I'm trying to get a proprietary business application running.
It is basically a kind of a special small business accounting
app which can be used in a distributed manner. If it is configured
this way, the server installation is running an MSSQL server
instance locally to store the data, while a client installation
just uses the remote server installation (apparently directly
connects to the remote MSSQL instance). I'd be very happy if
I could get at least a client installation running under Wine
while running the server installation under a real Windows
environment.

The client software package installs under Wine seamlessly.
When started, it crashes with an exception until I install
Microsoft Database Engine. With MSDE installed the program
does start up but stops immediately with an error dialog
basically saying that it cannot connect to the database.
From a quick .exe strings analysis I believe it has been
coded in Borland Delphi.

Well, it is possible that this is only some network level
issue (LMHOSTS lookup failing or whatever) but realistically
I suspect that there could be some deeper problem than that
as the program fails to create some OLE objects etc.

How do I start to make it work?

I can send a Wine debug log if somebody with a clue would
be so kind to look into it...

Thanks,

Sab

Try:

$ wget kegel.com/wine/winetricks
$ sh winetricks hosts jet40

--
-Austin

[RUMI Szabolcs]

Hello!

On Sat, 21 Mar 2009 18:54:38 -0500
Austin English <[email protected]> wrote:

Try:

$ wget kegel.com/wine/winetricks
$ sh winetricks hosts jet40

Nice idea! I've done the above and then written explicit hosts
entries both into the winetricks hosts file and into the Linux
/etc/hosts file for the database server. Jet Engine also
installed successfully, but the program still doesn't work.
The same error dialog appears as before:

OLE Error 80004005
Cannot connect to database

Thanks,
Sab

[quasimodo]

try to add an override for the ole32.dll in winecfg. worked for me with another app

[vitamin]

try to add an override for the ole32.dll in winecfg. worked for me with another app

You can't just override a dll without "installing" it first.

[James McKenzie]

RUMI Szabolcs wrote:

Hello!

On Sat, 21 Mar 2009 18:54:38 -0500
Austin English <[email protected]> wrote:

Try:

$ wget kegel.com/wine/winetricks
$ sh winetricks hosts jet40

Nice idea! I've done the above and then written explicit hosts
entries both into the winetricks hosts file and into the Linux
/etc/hosts file for the database server. Jet Engine also
installed successfully, but the program still doesn't work.
The same error dialog appears as before:

OLE Error 80004005
Cannot connect to database

Sorry for the rather late reply, but is the database using Windows
Authentication?

James McKenzie

[RUMI Szabolcs]

Hello!

On Sat, 04 Apr 2009 20:08:59 -0700
James McKenzie <[email protected]> wrote:

Nice idea! I've done the above and then written explicit hosts
entries both into the winetricks hosts file and into the Linux
/etc/hosts file for the database server. Jet Engine also
installed successfully, but the program still doesn't work.
The same error dialog appears as before:

OLE Error 80004005
Cannot connect to database

Sorry for the rather late reply, but is the database using Windows
Authentication?

Well, I don't know... How can I tell?

I've sniffed on the network with tcpdump and there was some traffic
back and forth between the client and the SQL server but that's all
I know. I'm not much into Microsoft solutions, I'm using OSS for
everything whenever possible, Linux on the desktop, etc...

Thanks,

Sab

[James McKenzie]

RUMI Szabolcs wrote:

Hello!

On Sat, 04 Apr 2009 20:08:59 -0700
James McKenzie <[email protected]> wrote:

Nice idea! I've done the above and then written explicit hosts
entries both into the winetricks hosts file and into the Linux
/etc/hosts file for the database server. Jet Engine also
installed successfully, but the program still doesn't work.
The same error dialog appears as before:

OLE Error 80004005
Cannot connect to database

Sorry for the rather late reply, but is the database using Windows
Authentication?

Well, I don't know... How can I tell?

I've sniffed on the network with tcpdump and there was some traffic
back and forth between the client and the SQL server

You are using SQL Server, correct? The default is to use Windows
Authentication, which needs to be changed. Otherwise, you will get the
error you received and Wine (as far as I know) does not support this, yet.

James McKenzie

[RUMI Szabolcs]

Hello!

On Sun, 05 Apr 2009 18:03:52 -0700
James McKenzie <[email protected]> wrote:

Well, I don't know... How can I tell?

I've sniffed on the network with tcpdump and there was some traffic
back and forth between the client and the SQL server

You are using SQL Server, correct? The default is to use Windows
Authentication, which needs to be changed. Otherwise, you will get the
error you received and Wine (as far as I know) does not support this, yet.

Well, yes and no... It's not a full blown MSSQL installation but a
stripped down database engine (MSDE) that was bundled with the Delphi
app so there are no utilities, no controls, no nothing... But!
I've g00gled around to read about the authentication settings of this
thing and I've manually changed the following registry value to "2":

HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\LoginMode

This should have resulted in the SQL server instance being set to
"Mixed" authentication allowing both Windows Authentication and SQL
Authentication. Now the client program starts up and probably tries
to connect, then the following error dialog appears:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

On the network I see SYN packets going out to the server and only
RST+ACK packets coming back every time.

I've managed to connect to the SQL server instance locally with OSQL
but if I issue any commands (stored procs etc) nothing seems to happen,
there are no error messages, no nothing.

Now I really don't know how to go any further...

Thanks,

Sab

[vitamin]

On the network I see SYN packets going out to the server and only
RST+ACK packets coming back every time.

Looks like it's not even listening on that port. You sure it's configured with tcp/ip not named pipes?

[cmr]

This post is old, but it can be useful to someone. I solved copying the file "dbnetlib.dll" a computer with windows xp and replacing int the "$HOME/.wine/drive_c/windows/system32/"

This works.