ActiveX & ADO?

Open forum for end-user questions about Wine. Before asking questions, check out the Wiki as a first step.
Forum Rules
Locked
Morgan Read

ActiveX & ADO?

Post by Morgan Read »

Hi Folks

I recently got back the message below form a company I suggested
supporting WINE with their software. Is there any answer - or is it, as
they suggest, a lost cause?

The error I get from WINE is:
RTG Bills (title)
ADO error 1AD
ActiveX component can't create object
[OK](button)

Is there anyway to have ActiveX & ADO work with WINE?

Regards,
Morgan.
No, RTG Bills won't run under Wine. The error message explains why:
ActiveX component can't create object
ActiveX components don't work.

RTG Bills does things that RTG Timer does not. Because RTG Bills is a
multi-user program, it does row-level record locking. This requires
a call to ADO, which doesn't work in Wine.

So, it isn't simple, and it isn't going to be fixed. Sorry.

Rather, our goal is to make a version of RTG Bills that runs in a Web
browser, similar to our current RTG Timer Online. It could run as a
service on our server, or (ultimately) you could run it locally on
your computer or network.

Robert Hallem


On Wed, Dec 3, 2008 at 1:42 PM, <[email protected]> wrote:
Message sent from this page:
http://www.rtgsoftware.com/mail/mailrtg.htm Browser: Mozilla/5.0
(X11; U; Linux i686; en-GB; rv:1.8.1.18) Gecko/20081112
Fedora/2.0.0.18-1.fc8 Firefox/2.0.0.18


Comments: Hello

I've recently started as self-employed after being employed. When
employed, my employer had us use RTG Bills.

I used RTG Timer via WINE on my laptop running gnu/linux. I had
assumed and hoped that I could continue making use of RTG on my
own, but unfortunately RTG Bills fails to run under the WINE
environment. This is very frustrating. I suspect RTG Bills would
perhaps require little adjustment to run successfully under WINE:
it installs successfully; RTG Timer runs.

The error window displayed is:
RTG Bills (title)
ADO error 1AD
ActiveX component can't create object
[OK](button)

If RTG Bills were made complaint with WINE, it would not only open
RTG Bills to the gnu/linux market (perhaps not so significant) but
also to the Apple Mac environment.

How about it?

Regards, Morgan.
--
Getting errors: "There are problems with the signature" (or similar)?
Update your system by installing certificates from CAcert Inc, see here:
http://wiki.cacert.org/wiki/BrowserClie ... b54d9e378b
Or, if Internet Explorer is your default browser, simply click this link:
http://www.cacert.org/index.php?id=17

Morgan Read
NEW ZEALAND
<mailto:mstuffATreadDOTorgDOTnz>

fedora + freedom; fact || fiction?
http://fedoraproject.org/wiki/Overview
get freed-ora!
http://www.fsfla.org/svnwiki/selibre/li ... /freed-ora
vitamin
Moderator
Moderator
Posts: 6605
Joined: Sat Feb 23, 2008 2:29 pm

Re: ActiveX & ADO?

Post by vitamin »

Morgan Read wrote:Is there anyway to have ActiveX & ADO work with WINE?
ADO should work if you install it. ActiveX also should be supported via wine_gecko.

If you having any problems with both, please open a bug report in Wine's bugzilla.
Morgan Read

ActiveX & ADO?

Post by Morgan Read »

On 05/12/08 03:43, vitamin wrote:
Morgan Read wrote:
Is there anyway to have ActiveX & ADO work with WINE?
ADO should work if you install it. ActiveX also should be supported via wine_gecko.

If you having any problems with both, please open a bug report in Wine's bugzilla.
Vitamin, thank you.

I've installed the ADO (see below for an interesting tale) and
wine_gecko, but I now get the following error:

RTG Bills (window title)
Method '~' of object '~' failed
[OK] (button)

Clicking "OK" gets me to a database location selection dialogue window,
which when I click "Save" provides me the following window:

RTG Bills (window title)
RTG Bills will exit. Start it again to use the database you selected.
[OK] (button)

Clicking "OK" and restarting simply sends me round in the same loop
again. (BTW, this was the behaviour before I installed ADO and
wine_gecko, but with the different initial "fail" dialogue box.)


MS ADO INSTALL:
I tried installing the ADO by following the "MDAC 2.8 SP1" links from
this page: http://msdn.microsoft.com/en-us/data/aa937729.aspx The
MDAC_TYP.EXE I ended up with (via a Windows box, it wouldn't let me
download to other than a "Genuine bla bla") reports:

FATAL SETUP ERROR (window title)
This setup does not support installing on this operating system.
[OK] (button)

Any ideas how to go about installing ADO on WINE...
Well, I've just answered that one for myself - the answer is to install
the MDAC_TYP.EXE by following the "MDAC 2.8" links on the above page -
perhaps M$ has got wise to people installing ADO on WINE with their SP1
release?...

Regards,
Morgan.
--
Getting errors: "There are problems with the signature" (or similar)?
Update your system by installing certificates from CAcert Inc, see here:
http://wiki.cacert.org/wiki/BrowserClie ... b54d9e378b
Or, if Internet Explorer is your default browser, simply click this link:
http://www.cacert.org/index.php?id=17

Morgan Read
NEW ZEALAND
<mailto:mstuffATreadDOTorgDOTnz>

fedora + freedom; fact || fiction?
http://fedoraproject.org/wiki/Overview
get freed-ora!
http://www.fsfla.org/svnwiki/selibre/li ... /freed-ora
qwertymn
Level 4
Level 4
Posts: 236
Joined: Thu Mar 27, 2008 3:42 am

Post by qwertymn »

[/quote]Method '~' of object '~' failed [quote]

I've seen that error before. Somehow the install of ADO seems to be a bit tricky. For another ap the following worked:


rm -rf ~/garbage

wget http://kegel.com/wine/winetricks

WINEPREFIX=~/garbage sh winetricks vb6run art2kmin mdac27 wsh56

WINEPREFIX=~/garbage wine setup.exe ( run the installer of the application)

cd ~/garbage/drive_c/Program\ Files/Path to the application

and run it

WINEPREFIX=~/garbage wine app_name.exe
Morgan Read

ActiveX & ADO?

Post by Morgan Read »

On 06/12/08 23:19, qwertymn wrote:
Method '~' of object '~' failed I've seen that error before. Somehow the install of ADO seems to be a
bit tricky. For another ap the following worked:


rm -rf ~/garbage

wget http://kegel.com/wine/winetricks

WINEPREFIX=~/garbage sh winetricks vb6run art2kmin mdac27 wsh56

WINEPREFIX=~/garbage wine setup.exe ( run the installer of the
application)

cd ~/garbage/drive_c/Program\ Files/Path to the application

and run it

WINEPREFIX=~/garbage wine app_name.exe
Qwertymn, your going to have to bear with me on this one:)

This "~/garbage" directory - is that a euphemism for "~/.wine",
otherwise I don't have this directory to remove? With that first line,
are you suggesting I remove my current wine install from my user
account? Then, reinstall the application after using winetricks to
install "vb6run art2kmin mdac27 wsh56" and then run it? Why the use of
"WINEPREFIX=~/garbage"?

Hope these Q's aren't too lame...

Many thanks.
M.
--
Getting errors: "There are problems with the signature" (or similar)?
Update your system by installing certificates from CAcert Inc, see here:
http://wiki.cacert.org/wiki/BrowserClie ... b54d9e378b
Or, if Internet Explorer is your default browser, simply click this link:
http://www.cacert.org/index.php?id=17

Morgan Read
NEW ZEALAND
<mailto:mstuffATreadDOTorgDOTnz>

fedora + freedom; fact || fiction?
http://fedoraproject.org/wiki/Overview
get freed-ora!
http://www.fsfla.org/svnwiki/selibre/li ... /freed-ora
vitamin
Moderator
Moderator
Posts: 6605
Joined: Sat Feb 23, 2008 2:29 pm

Re: ActiveX & ADO?

Post by vitamin »

Morgan Read wrote:Qwertymn, your going to have to bear with me on this one:)
Those are _the exact commands_ you put in the terminal. Get used in *NIX world to be given "the exact command you run in the terminal". No one will tell you "GUI step-by-step".
Tlarhices
Level 4
Level 4
Posts: 101
Joined: Sun Mar 02, 2008 9:28 pm

Re: ActiveX & ADO?

Post by Tlarhices »

Morgan Read wrote:This "~/garbage" directory - is that a euphemism for "~/.wine",
otherwise I don't have this directory to remove? With that first line,
are you suggesting I remove my current wine install from my user
account? Then, reinstall the application after using winetricks to
install "vb6run art2kmin mdac27 wsh56" and then run it? Why the use of
"WINEPREFIX=~/garbage"?

Hope these Q's aren't too lame...
I will try to explain it simply.
Wine has a feature called "WINEPREFIX" which gives the possibility to install applications in a different folder than ~/.wine
This feature is often used when you have to make things (using native DLLs, ...) that may prevent other applications from running.
It creates completely isolated environments so you can wipe it and recreate it without removing any other application installed.
The problem is that you will have to prefix every command by :

Code: Select all

WINEPREFIX=something
And can't use anymore the double click on exe files (as it uses default ~/.wine prefix)
http://wiki.winehq.org/FAQ#head-f2f5f3b ... 15657ad552

The command

Code: Select all

rm -rf ~/garbage
Is a not subtle way to tell you that you need to make sure this folder doesn't exists. So if the remove command tells you it isn't here, it is OK.

You don't have to use the "garbage" prefix or even change prefix, but it is be a good idea in this case and for your future test (as using winetrick changes the default behavior of wine).
Morgan Read

ActiveX & ADO?

Post by Morgan Read »

On 08/12/08 14:53, vitamin wrote:
Morgan Read wrote:
Qwertymn, your going to have to bear with me on this one:)
Those are _the exact commands_ you put in the terminal. Get used in
*NIX world to be given "the exact command you run in the terminal".
No one will tell you "GUI step-by-step".
Hay, come on - give us a break! I've been doing this stuff in the *NIX
world for the last 7 years!

I do not have any "~/garbage":
$ rm -rf -v ~/garbage
$ ls ~/garbage
ls: cannot access /home/read/garbage: No such file or directory
$ ls ~ | grep garbage

And no, I don't believe "rm -rf ~/garbage" can make any sense however
long anyone might be used to the *NIX world if "~/garbage" doesn't
exist. So, please, lets not jump quite so quick - and if I have missed
something bleeding obvious - give us a little slack, it's good for
everyone's humour.

Thanks,
M.
PS I see from Tlarhices that perhaps I need some slack...

--
Getting errors: "There are problems with the signature" (or similar)?
Update your system by installing certificates from CAcert Inc, see here:
http://wiki.cacert.org/wiki/BrowserClie ... b54d9e378b
Or, if Internet Explorer is your default browser, simply click this link:
http://www.cacert.org/index.php?id=17

Morgan Read
NEW ZEALAND
<mailto:mstuffATreadDOTorgDOTnz>

fedora + freedom; fact || fiction?
http://fedoraproject.org/wiki/Overview
get freed-ora!
http://www.fsfla.org/svnwiki/selibre/li ... /freed-ora
Morgan Read

ActiveX & ADO?

Post by Morgan Read »

On 08/12/08 15:28, Tlarhices wrote:
Morgan Read wrote:
...
I will try to explain it simply. Wine has a feature called
"WINEPREFIX" which gives the possibility to install applications in a
different folder than ~/.wine This feature is often used when you
have to make things (using native DLLs, ...) that may prevent other
applications from running. It creates completely isolated
environments so you can wipe it and recreate it without removing any
other application installed. The problem is that you will have to
prefix every command by :

Code: WINEPREFIX=something


And can't use anymore the double click on exe files (as it uses
default ~/.wine prefix)
http://wiki.winehq.org/FAQ#head-f2f5f3b ... 15657ad552


The command

Code: rm -rf ~/garbage


Is a not subtle way to tell you that you need to make sure this
folder doesn't exists. So if the remove command tells you it isn't
here, it is OK.

You don't have to use the "garbage" prefix or even change prefix, but
it is be a good idea in this case and for your future test (as using
winetrick changes the default behavior of wine).
Thanks Tlarhices, that's great.
M.

--
Getting errors: "There are problems with the signature" (or similar)?
Update your system by installing certificates from CAcert Inc, see here:
http://wiki.cacert.org/wiki/BrowserClie ... b54d9e378b
Or, if Internet Explorer is your default browser, simply click this link:
http://www.cacert.org/index.php?id=17

Morgan Read
NEW ZEALAND
<mailto:mstuffATreadDOTorgDOTnz>

fedora + freedom; fact || fiction?
http://fedoraproject.org/wiki/Overview
get freed-ora!
http://www.fsfla.org/svnwiki/selibre/li ... /freed-ora
Morgan Read

ActiveX & ADO?

Post by Morgan Read »

Tlarhices, Qwertymn & Vitamin - thank you, it works. Installing vb6run
art2kmin mdac27 wsh56 via winetricks seems to have done the trick. I'll
add it to the appdb.

Thanks again,
Morgan.

On 08/12/08 15:28, Tlarhices wrote:
Morgan Read wrote:
This "~/garbage" directory - is that a euphemism for "~/.wine",
otherwise I don't have this directory to remove? With that first
line, are you suggesting I remove my current wine install from my
user account? Then, reinstall the application after using
winetricks to install "vb6run art2kmin mdac27 wsh56" and then run
it? Why the use of "WINEPREFIX=~/garbage"?

Hope these Q's aren't too lame...
I will try to explain it simply. Wine has a feature called
"WINEPREFIX" which gives the possibility to install applications in a
different folder than ~/.wine This feature is often used when you
have to make things (using native DLLs, ...) that may prevent other
applications from running. It creates completely isolated
environments so you can wipe it and recreate it without removing any
other application installed. The problem is that you will have to
prefix every command by :

Code: WINEPREFIX=something


And can't use anymore the double click on exe files (as it uses
default ~/.wine prefix)
http://wiki.winehq.org/FAQ#head-f2f5f3b ... 15657ad552


The command

Code: rm -rf ~/garbage


Is a not subtle way to tell you that you need to make sure this
folder doesn't exists. So if the remove command tells you it isn't
here, it is OK.

You don't have to use the "garbage" prefix or even change prefix, but
it is be a good idea in this case and for your future test (as using
winetrick changes the default behavior of wine).





--
Getting errors: "There are problems with the signature" (or similar)?
Update your system by installing certificates from CAcert Inc, see here:
http://wiki.cacert.org/wiki/BrowserClie ... b54d9e378b
Or, if Internet Explorer is your default browser, simply click this link:
http://www.cacert.org/index.php?id=17

Morgan Read
NEW ZEALAND
<mailto:mstuffATreadDOTorgDOTnz>

fedora + freedom; fact || fiction?
http://fedoraproject.org/wiki/Overview
get freed-ora!
http://www.fsfla.org/svnwiki/selibre/li ... /freed-ora
vitamin
Moderator
Moderator
Posts: 6605
Joined: Sat Feb 23, 2008 2:29 pm

Re: ActiveX & ADO?

Post by vitamin »

Morgan Read wrote:On 08/12/08 14:53, vitamin wrote:
Morgan Read wrote:
Qwertymn, your going to have to bear with me on this one:)
Those are _the exact commands_ you put in the terminal. Get used in
*NIX world to be given "the exact command you run in the terminal".
No one will tell you "GUI step-by-step".
Hay, come on - give us a break! I've been doing this stuff in the *NIX
world for the last 7 years!
Then why are you asking such a noob questions? :D
Morgan Read wrote:I do not have any "~/garbage":
Then removing this dir is a no-op. What's the problem with that?
qwertymn
Level 4
Level 4
Posts: 236
Joined: Thu Mar 27, 2008 3:42 am

Post by qwertymn »

Morgan, sorry for the confusion, i guess i 'd better make the explanation of the garbage directory clearer in the first place. Anyway, glad it worked out in the end.

Apart from adding this to the appdb, i think it might be useful that someone also adds this info to the wine-wiki, as i've seen several apps failing now, because the installation of art2kmin/mdac seemd to be "sequence-sensitive" ( i mean , apparently only "art2kmin mdac27" works, installing other way around, or mdac28 makes the apps crash in strange ways...)
Locked