MDAC/ODBC 32bits

Questions about Wine on Linux
Post Reply
pcouderc
Level 1
Level 1
Posts: 7
Joined: Fri Apr 18, 2014 3:33 am

MDAC/ODBC 32bits

Post by pcouderc » Sat Nov 14, 2020 3:58 am

I have to use a 32bits windows application using MDAC/ODBC which accesses a postgresql server with unixodbc (on debian buster).

I have installed "winetrick mdac28" but I do not find the 32bits version of odbcad32.exe. I find :
.wine/drive_c/windows/syswow64/odbcad32.exe
but I do not find:
.wine/drive_c/windows/systrm32/odbcad32.exe

What do I miss ?
Is there a tutorial about that somewhere...?

Thanks for any help
PC

spoon0042
Level 5
Level 5
Posts: 404
Joined: Thu Dec 24, 2009 11:00 am

Re: MDAC/ODBC 32bits

Post by spoon0042 » Sat Nov 14, 2020 10:50 am

Believe it or not, syswow64 is the directory for 32-bit dlls. Anyway. Your winetricks is probably out of date since mdac doesn't really work on 64-bit. You'll probably want to create a 32-bit wineprefix for your app, then get an up-to-date winetricks, and go from there.

Also what wine version are you using? And if you can say what is the app and is it freely available?

e: One last thing, are you following some guide or instructions or was mdac28 a guess on your part?

pcouderc
Level 1
Level 1
Posts: 7
Joined: Fri Apr 18, 2014 3:33 am

Re: MDAC/ODBC 32bits

Post by pcouderc » Sat Nov 14, 2020 12:27 pm

Thank you very much, I shall process as you indicate. But first I answer you.

I use wine 5.0.4 as indicated in apt-policy of my buster debian.

My app is a personal application developed on VC6 on XP years ago in a JET environment but with ODBC interface to postgresql on a debian server.
Then I did decide to switch (many years ago) to full debian desktop (with enlightenment), I did convert my XP to vmware first and qemu next.
And then I did use some apps directly with wine to avoid starting qemu. And it worked.
Now I had to reinstall full PC, and my apps are well except this one wich tries to access Postgresql...
No, I have not found a good guide and it is a reason of my question...

I am sorry that this app has no interest except for me ! In fact, I maintain a good old window VC6+FTN software in a... linux environment !

spoon0042
Level 5
Level 5
Posts: 404
Joined: Thu Dec 24, 2009 11:00 am

Re: MDAC/ODBC 32bits

Post by spoon0042 » Sat Nov 14, 2020 2:06 pm

You may only need to install jet40 with winetricks as well if it's anything like other db apps. Hopefully that works for you.

fargodwe
Level 5
Level 5
Posts: 272
Joined: Mon Oct 02, 2017 7:08 am

Re: MDAC/ODBC 32bits

Post by fargodwe » Sun Nov 15, 2020 3:49 am

Just from the tremendous help I was given I'll also add that it may be necessary to also use winecfg on the prefix and manually add an entry for odbccp32.dll as native,builtin and be sure msado15 is shown as native,builtin as well - if not add an override for this as well. The installation of both of these does not take place via winetricks if the wine version is greater than 4.22.

I had to add mdac28 THEN jet40 in that order for my app to run. Then I had to do the above. I have Bob Wya and you spoon0042 to thank for that!!. Perhaps it might be needed in this case since it's 32-bit as well?

fargodwe
Level 5
Level 5
Posts: 272
Joined: Mon Oct 02, 2017 7:08 am

Re: MDAC/ODBC 32bits

Post by fargodwe » Tue Nov 17, 2020 5:05 pm

A really dumb question but...are you sure postgresql is installed in your Debian installation? If not, I did find this on the net. Perhaps some of the console commands to check the status of postgresql might help.

Code: Select all

https://www.tecmint.com/install-postgresql-database-in-debian-10/

Post Reply