isqlw with wine

[waraltca]

Hi,

I need help to find the way of running isqlw (http://msdn.microsoft.com/en-us/library ... L.80).aspx) with wine on ubuntu 9.04.

When I try to connect to the network server I just receive this: "DB-Library error: , Severity: 0"

I'm sure I already have all the dll's that this program needs. Using
(http://www.dependencywalker.com/) I copied all the requested dll's.

Does anybody has info??

thanks

[James McKenzie]

waraltca wrote:

Hi,

I need help to find the way of running isqlw (http://msdn.microsoft.com/en-us/library ... L.80).aspx) with wine on ubuntu 9.04.

When I try to connect to the network server I just receive this: "DB-Library error: , Severity: 0"

I'm sure I already have all the dll's that this program needs. Using
(http://www.dependencywalker.com/) I copied all the requested dll's.

Did you set the dlls to native using Winecfg for isqlw.exe?

Also, be prepared for all sorts of problems including Wine crashes if
you did not use winetricks to install the dependent dlls.

James McKenzie

[waraltca]

waraltca wrote:

Hi,

I need help to find the way of running isqlw (http://msdn.microsoft.com/en-us/library ... L.80).aspx) with wine on ubuntu 9.04.

When I try to connect to the network server I just receive this: "DB-Library error: , Severity: 0"

I'm sure I already have all the dll's that this program needs. Using
(http://www.dependencywalker.com/) I copied all the requested dll's.

Did you set the dlls to native using Winecfg for isqlw.exe?

Also, be prepared for all sorts of problems including Wine crashes if
you did not use winetricks to install the dependent dlls.

James McKenzie

thanks for answering james...
How do I set the dlls to native using Winecfg for isqlw.exe??

thanks for tour help.

[Danila Sentiabov]

On Mon, Aug 3, 2009 at 22:18, waraltca <[email protected]> wrote:

thanks for answering james...
How do I set the dlls to native using Winecfg for isqlw.exe??

thanks for tour help.

Run winecfg, add your .exe to the list on the first tab, select it, switch
to "DLL overrides" tab, add needed dlls there and set them to "Native,
Builtin" order. But if you just set all dlls that program use to "native,
Builtin", it will most probably not work. Windows dlls, especially "core"
ones will almost surely crash in Wine. Wine is compatible (to some degree)
with Windows on the external, "visible" API, but it do the internals
differently (no Wine developers are actually know how Windows do these
internals - it would be copyright violation that'd make the whole Wine
project vulnerable to legal threats). Applications use that API and work. On
the contrary, "core" Windows DLLs rely exactly on those hidden and
undocumented internals and copying those DLLs from Windows will often do
more harm than good.

You should by all means use winetricks to install needed dlls, and try to
copy dlls from Windows manually only as the last resort. And you should not
copy all dlls, only those that not present in Wine or don't work properly,
one at a time. It may be tricky to determine, which ones are not working,
yes.

Also, you should note that to maximize your chances, you should install
everything to the clean prefix (just rename your current ~/.wine directory
and run winecfg - it will create a shiny new prefix for you).

Related links:
http://wiki.winehq.org/winetricks

--
Best regards,
Danila Sentiabov aka dsent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.winehq.org/pipermail/wine-us ... chment.htm>

[waraltca]

On Mon, Aug 3, 2009 at 22:18, waraltca <[email protected]> wrote:

thanks for answering james...
How do I set the dlls to native using Winecfg for isqlw.exe??

thanks for tour help.

Run winecfg, add your .exe to the list on the first tab, select it, switch
to "DLL overrides" tab, add needed dlls there and set them to "Native,
Builtin" order. But if you just set all dlls that program use to "native,
Builtin", it will most probably not work. Windows dlls, especially "core"
ones will almost surely crash in Wine. Wine is compatible (to some degree)
with Windows on the external, "visible" API, but it do the internals
differently (no Wine developers are actually know how Windows do these
internals - it would be copyright violation that'd make the whole Wine
project vulnerable to legal threats). Applications use that API and work. On
the contrary, "core" Windows DLLs rely exactly on those hidden and
undocumented internals and copying those DLLs from Windows will often do
more harm than good.

You should by all means use winetricks to install needed dlls, and try to
copy dlls from Windows manually only as the last resort. And you should not
copy all dlls, only those that not present in Wine or don't work properly,
one at a time. It may be tricky to determine, which ones are not working,
yes.

Also, you should note that to maximize your chances, you should install
everything to the clean prefix (just rename your current ~/.wine directory
and run winecfg - it will create a shiny new prefix for you).

Related links:
http://wiki.winehq.org/winetricks

--
Best regards,
Danila Sentiabov aka dsent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.winehq.org/pipermail/wine-us ... chment.htm>

I did all you say and got an "abnormal program termination"

[waraltca]

someone else with an other idea??

[waraltca]

What I'm trying to do is to connect a vb6.0 program with a sql server. The main idea is to run this application from linux.

Any ideas??

thank for the help!

[Danila Sentiabov]

I'd test your application myself but I don't have MS SQL server to connect
to.

--
Best regards,
Danila Sentiabov aka dsent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.winehq.org/pipermail/wine-us ... chment.htm>

[waraltca]

I'd test your application myself but I don't have MS SQL server to connect
to.
--
Best regards,
Danila Sentiabov aka dsent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.winehq.org/pipermail/wine-us ... chment.htm>

Yesterday I talked to a colleague about the problem and what he said was that wine has problems with network connections. So as I need to run a vb6.0 application located on a windows OS from an ubuntu workstation, wine would not be helpful on that.

He recomended to use terminal services to connect, but I'm not sure if wine is really unable to do it.

Do you know where can I get more info about it?

[Danila Sentiabov]

Lastly Wine had accomplished a lot in the network area. It have network
support that well enough to run torrent clients (and servers), play network
games, run online bank clients etc. I don't think it's really network issue.
I couldn't recommend more than I did before - you should analyze error logs
and see which DLLs it need, then install needed with winetricks (I suppose
you will definitely have to install VB 6.0 runtime - by winetricks, not
copying DLLs from Windows and everything in a clean prefix!). Then if it
still don't work, analyze error logs further to see what it also needs.
Maybe you should report a bug - chances are that it's really not working
because of a bug in Wine, why not.
I have access to MS Action Pack at my workplace and I have right to install
and run MS SQL Server for demonstration and testing purposes. So if nothing
helps, I'll install it on some server and see what I can do. Remind me in 2
weeks (I will not have time for it until then).

--
Best regards,
Danila Sentiabov aka dsent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.winehq.org/pipermail/wine-us ... chment.htm>

[waraltca]

Thanks to everybody who tryied help me and in some way.. did it.

Steps:
1) I updated the wine version to wine 1.1.27 on august 12 2009.

2)After that, I installed mdac_typ.exe from http://www.microsoft.com/downloads/deta ... laylang=en

3) Copied the ntwlib.dll from a windows system and pasted it on system32 folder of wine.

4)executed

Code: Select all

wine cliconfg

on terminal. Then enabled the protocols TCP/IP and NAMED PIPES. Do it in that order. And don't modify the properties of each one.

5) executed

Code: Select all

wine control

on terminal the get acces to the wine control panel.

6)Selected data sources and added a new data sources from the "add button".

7)On server combox, I wrote the ip of my server. (ex:. 192.168.10.100)

Wrote the credentials (user and password) and continue installing as in windows. (next ,next ....., test and finish).

If any body has problems... write me, I'll try to help.
[email protected].

thanks once again!
Waraltca.

[Danila Sentiabov]

Please find your program in AppDB (or create it and become maintainer), then
post your solution there (in notes section). This will help other users to
get it working.

On Wed, Aug 12, 2009 at 23:03, waraltca <[email protected]> wrote:

Thanks to everybody who tryied help me and in some way.. did it.

Steps:
1) I updated the wine version to wine 1.1.27 on august 12 2009.

2)After that, I installed mdac_typ.exe from
http://www.microsoft.com/downloads/deta ... laylang=en

3) Copied the ntwlib.dll from a windows system and pasted it on system32
folder of wine.

4)executed
Code:
wine cliconfg

on terminal. Then enabled the protocols TCP/IP and NAMED PIPES. Do it in
that order. And don't modify the properties of each one.

5) executed
Code:
wine control

on terminal the get acces to the wine control panel.

6)Selected data sources and added a new data sources from the "add button".

7)On server combox, I wrote the ip of my server. (ex:. 192.168.10.100)

Wrote the credentials (user and password) and continue installing as in
windows. (next ,next ....., test and finish).

If any body has problems... write me, I'll try to help.
[email protected].

thanks once again!
Waraltca.

--
Best regards,
Danila Sentiabov aka dsent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.winehq.org/pipermail/wine-us ... chment.htm>

[FatButtLarry]

Agreed. This is great info, it should go in AppDB. Thanks Waraltca.
Post in AppDB if you can!!!

-Tres

On Thu, Aug 13, 2009 at 2:02 PM, Danila Sentiabov<[email protected]> wrote:

Please find your program in AppDB (or create it and become maintainer), then
post your solution there (in notes section). This will help other users to
get it working.

On Wed, Aug 12, 2009 at 23:03, waraltca <[email protected]> wrote:

Thanks to everybody who tryied help me and in some way.. did it.

Steps:
1) I updated the wine version to wine 1.1.27 on august 12 2009.

2)After that, I installed mdac_typ.exe from
http://www.microsoft.com/downloads/deta ... laylang=en

3) Copied the ntwlib.dll from a windows system and pasted it on system32
folder of wine.

4)executed
Code:
wine cliconfg

 on terminal. Then enabled the protocols TCP/IP and NAMED PIPES. Do it in
that order. And don't modify the properties of each one.

5) executed
Code:
wine control

 on terminal the get acces to the wine control panel.

6)Selected data sources and added a new data sources from the "add button".

7)On server combox, I wrote the ip of my server. (ex:. 192.168.10.100)

Wrote the credentials (user and password) and continue installing as in
windows. (next ,next ....., test and finish).

If any body has problems... write me, I'll try to help.
[email protected].

thanks once again!
Waraltca.

--
Best regards,
Danila Sentiabov aka dsent
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.winehq.org/pipermail/wine-us ... chment.htm>

--
- [email protected]