Mint 20, 32-bit application

Questions about Wine on Linux
Post Reply
fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Mint 20, 32-bit application

Post by fargodwe » Fri Oct 16, 2020 11:22 pm

I recently downloaded and reinstalled linux Mint 20. The release notes said 32-bit applications were no longer supported but the pieces that are needed for wine and virtualbox are.

As you may know from my previous posts, I have a 32-bit application GedstarPro that Bob Wya was so patient with me and got it figured out for me on wine. It needs mdac28 and jet40 (which includes mdec27).

So with the new installation, I followed the winehq download/installation instructions for Ubuntu 20 since the previous was listed a mint 19.x. I did the add of 32-bit architecture ok. Did everything else fine. Created a 32-bit prefix and configured to Windows XP. I installed the application then ran wintricks for mdac28 and then for jet40 as per the previous that did work.

Unfortunately I'm kinda back to square 1. I've tried both stable and staging brances with no luck.

The application does run, but falling on the database again.

I don't know if is this is the result of something with Mint or some incompatibility with the "version" of wine I'm using or whatever.

If anyone have any ideas the help would be greatly appreciated!

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Sat Oct 17, 2020 3:50 am

ooppss - only tried the stable branch not the staging.

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Sun Oct 18, 2020 4:04 am

Staging didn't make any difference either. I also tried the Mint 19.x repository with no difference with stable or staging. After each attempt I purged the version with apt and did apt autoremove so I would be starting "from scratch" each time I tried a different branch.

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Tue Oct 20, 2020 4:10 am

Anyone? This ran ok before in Mint 20 a couple of months ago I think. I downloaded Mint 20 again and installed winehq-stable and then purged that and tried winehq-staging as per prior releases of Mint. GedStarPro refuses to open the database now. As per previous LONG thread on this there was a user here who found out how to make this work and was very patient with me. It involved a 32-bit prefix and then installing first mdac28 via winetricks then installing jet40 in winetricks. This had worked until now. It worked a couple of months ago with the stable branch of wine. I also downloaded winetricks fresh also.

Code: Select all

dave@dave-Aleena:~$ wine --version
wine-5.19 (Staging)
dave@dave-Aleena:~$ 
I'm sorry but my knowledge/understanding of wine is very limited.

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

Re: Mint 20, 32-bit application

Post by spoon0042 » Tue Oct 20, 2020 5:41 pm

hi again. :) I found my reply to you in another thread, I don't know if you saw it:
spoon0042 wrote:
Thu Jul 16, 2020 11:49 am
Oh good, I got it to work. It seems there may be an issue with winetricks where I'm not clear on which dlls should have an override set. Don't worry about that though unless in the future you have a problem again that would be useful information.

odbccp32 native,builtin
msado15 not set
This would be after installing mdac and jet40 with winetricks in a 32-bit wineprefix. Hopefully that's all you're missing. This may or may not be a bug still, I'm not sure if wine's odbccp32 is supposed to work with native dlls or not. Though filing a bug may be the easiest way to find someone who does know, you know?

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Tue Oct 20, 2020 9:02 pm

Thanks for the reply. Yep it was working before, but after being away from Mint 20 for a while I finally downloaded it again and reinstalled wine, etc.. This time around - 32-bit prefix, mdac28 and jet40. I'll have to check the odbccp and msado to see what they say. I'll let you know! Thanks again!

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Tue Oct 20, 2020 10:08 pm

I made sure to add odbccp32 and by default it came up native, builtin.

msado15 did not show. I added it but couldn't see not set so I disabled it.

mdac28 and jet40 were added earlier.

32-bit prefix. I have tried windows xp, windows 7 as it did work with either of those in the past.

I'm still back to where it kicks out the error when it is apparently trying to open the database.

Thank you for hanging in there with me. As you know, the threads for this got long. I tried looking closely at all of those threads but somehow either missed a thread of missed what you had posted. I hope nobody minds but I needed to start over thread-wise because I'm getting lost in the existing threads.

Thanks!

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Tue Oct 20, 2020 11:16 pm

Oh, I also don't know how to do anything in regards to filing a bug report. I got in trouble here once before for apparently taking the wrong approach to that. I don't have a clue on log reports, etc..

Thanks!

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Wed Oct 21, 2020 2:09 am

Just in case, I followed the post I had made right in the other thread right above your post copied above. This meant I purged everything winehq, installed winehq-stable, mdac28 and jet40. I then installed GedStarPro. Same problem. So, I check the version:

Code: Select all

dave@dave-Aleena:~$ wine --version
wine-5.0.2
dave@dave-Aleena:~$ 
The old post showed 5.0.1.

When I tried staging here in this thread at said 5.19 (staging).

So, and as you know I am at best an extreme novice at this, is that the stable release I am running now versus the old one with my old install of Mint 20 is a trailing 1 number difference.

Since it also no longer works in staging, have I really messed up somewhere or could this be something that was regressed in wine and is no longer in the staging branch either?

Thanks again!

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Wed Oct 21, 2020 10:41 pm

I am trying to figure out how a complete novice like me can try to debug this problem when all I have is an .exe.

I completely, again, purged winehq and deleted the prefix. Recreated. Got the following at the end of the terminal for installing mdac28:

Code: Select all

ave@dave-Aleena:~$ winetricks mdac28
Executing mkdir -p /home/dave
Using winetricks 20200412-next - sha256sum: 61509663b824d72daafec6a95986e5b256e19e0e8ec1d2b7c4e89cf52665d63b with wine-5.0.2 and WINEARCH=win32
Executing w_do_call mdac28
Executing mkdir -p /home/dave
Executing load_mdac28 
Using native,builtin override for following DLLs: msado15
Executing wine regedit C:\windows\Temp\override-dll.reg
Using native,builtin override for following DLLs: mtxdm odbc32 oledb32
Executing wine regedit C:\windows\Temp\override-dll.reg
Setting Windows version to nt40
Executing wine regedit C:\windows\Temp\set-winver.reg
Executing cd /home/dave/.cache/winetricks/mdac28
Executing wine mdac_typ.exe
0062:err:richedit:ReadStyleSheet skipping optional destination
0062:err:richedit:ReadStyleSheet skipping optional destination
0062:err:richedit:ReadStyleSheet skipping optional destination
0062:err:richedit:ReadStyleSheet skipping optional destination
0062:err:richedit:ReadStyleSheet skipping optional destination
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0063:fixme:setupapi:SetupAddInstallSectionToDiskSpaceListA Stub
0066:fixme:ntdll:NtQuerySystemInformation info_class SYSTEM_PERFORMANCE_INFORMATION
006e:fixme:odbc:SQLWriteDSNToIniW L"MQIS" L"SQL Server"
0070:fixme:odbc:SQLWriteDSNToIniW L"MQIS" L"SQL Server"
The operation completed successfully
Setting Windows version to default
Executing wine regedit C:\windows\Temp\set-winver.reg
------------------------------------------------------
warning: Running /usr/bin/wineserver -w. This will hang until all wine processes in prefix=/home/dave/.wine terminate
------------------------------------------------------
I noticed 2 fixme's regarding SQL Server. I don't know if these are a problem or not. When installing jet40 the installation of mdac27 gets a single line like that except it starts with 0076:

So I looked here:

Code: Select all

https://wiki.winehq.org/Wine_Developer%27s_Guide/Debugging_Wine
After reading through it and not having much of a clue what I was looking at, I decided that since the program kicks up a message box saying Error opening database, I would try the suggested debug for finding where messagebox is used and got this:

Code: Select all

dave@dave-Aleena:~/GEDSTAR/drive_c/Program Files/GedStar Pro$ WINEARCH=win32 WINEPREFIX=~/GEDSTAR  winedbg GedStar\ Pro.exe
WineDbg starting on pid 002b
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0x7bcb1d21 DbgBreakPoint+0x1 in ntdll: ret	
Wine-dbg>??
syntax error
Wine-dbg>help
The commands accepted by the Wine debugger are a reasonable
subset of the commands that gdb accepts.
The commands currently are:
  help                                   quit
  attach <wpid>                          detach
  break [*<addr>]                        watch | rwatch *<addr>
  delete break bpnum                     disable bpnum
  enable bpnum                           condition <bpnum> [<expr>]
  finish                                 cont [N]
  step [N]                               next [N]
  stepi [N]                              nexti [N]
  x <addr>                               print <expr>
  display <expr>                         undisplay <disnum>
  local display <expr>                   delete display <disnum>
  enable display <disnum>                disable display <disnum>
  bt [<tid>|all]                         frame <n>
  up                                     down
  list <lines>                           disassemble [<addr>][,<addr>]
  show dir                               dir <path>
  set <reg> = <expr>                     set *<addr> = <expr>
  pass                                   whatis
  info (see 'help info' for options)     thread <tid>
The 'x' command accepts repeat counts and formats (including 'i') in the
same way that gdb does.

The following are examples of legal expressions:
 $eax     $eax+0x3   0x1000   ($eip + 256)  *$eax   *($esp + 3)
 Also, a nm format symbol table can be read from a file using the
 symbolfile command.

Wine-dbg>break messageboxa
Breakpoint 1 at 0x7e8b4c50 MessageBoxA in user32
Wine-dbg>cont
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
002c:fixme:commdlg:IServiceProvider_fnQueryService Interface {e07010ec-bc17-44c0-97b0-46c7c95b9edc} requested from unknown service {e07010ec-bc17-44c0-97b0-46c7c95b9edc}
002c:fixme:shell:ViewModeToListStyle ViewMode 0 not implemented
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1026, a003, 0, 0x32dfcc)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1026, a004, 0, 0x32dfcc)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1025, a003, 1, 0x32dfcc)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1025, a004, 1, 0x32dfcc)
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
002c:fixme:nstc:NSTC2_fnSetControlStyle2 mask & style (0x00000004) contains unsupported style(s): 0x00000004
002c:fixme:shell:IShellBrowser_fnOnViewWindowActive stub, 0x87dda0 (0x87e2f0)
002c:fixme:commdlg:IServiceProvider_fnQueryService Interface {e07010ec-bc17-44c0-97b0-46c7c95b9edc} requested from unknown service {e07010ec-bc17-44c0-97b0-46c7c95b9edc}
002c:fixme:shell:ViewModeToListStyle ViewMode 0 not implemented
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1026, a003, 0, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1026, a004, 0, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1025, a003, 1, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1025, a004, 1, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnOnViewWindowActive stub, 0x87dda0 (0x124b288)
002c:fixme:commdlg:IServiceProvider_fnQueryService Interface {e07010ec-bc17-44c0-97b0-46c7c95b9edc} requested from unknown service {e07010ec-bc17-44c0-97b0-46c7c95b9edc}
002c:fixme:shell:ViewModeToListStyle ViewMode 0 not implemented
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1026, a003, 0, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1026, a004, 0, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1025, a003, 1, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1025, a004, 1, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnOnViewWindowActive stub, 0x87dda0 (0x124caf8)
002c:fixme:commdlg:IServiceProvider_fnQueryService Interface {e07010ec-bc17-44c0-97b0-46c7c95b9edc} requested from unknown service {e07010ec-bc17-44c0-97b0-46c7c95b9edc}
002c:fixme:shell:ViewModeToListStyle ViewMode 0 not implemented
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1026, a003, 0, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1026, a004, 0, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1025, a003, 1, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnSendControlMsg stub, 0x87dda0 (2, 1025, a004, 1, 0x32e32c)
002c:fixme:shell:IShellBrowser_fnOnViewWindowActive stub, 0x87dda0 (0x124cc20)
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
002c:fixme:ntdll:NtQuerySystemInformation info_class SYSTEM_PERFORMANCE_INFORMATION
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
002c:fixme:heap:RtlCompactHeap (0x670000, 0x0) stub
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
Stopped on breakpoint 1 at 0x7e8b4c50 MessageBoxA in user32
Wine-dbg>cont
0009:fixme:dbghelp:elf_search_auxv can't find symbol in module
Invalid address (0x7e8b4c50 MessageBoxA) for breakpoint 1, disabling it
Process of pid=002b has terminated
Wine-dbg>quit
dave@dave-Aleena:~/GEDSTAR/drive_c/Program Files/GedStar Pro$ 
I don't have a clue how to, if at all, use this information to somehow go back and get some kind of trace to see what is being set up for the call (?) to open the database.

I am trying to do this to try to get information that might be helpful to someone trying to help me.

I have done, as best as I can tell, everything I did before when this worked in Mint 20, 32-bit prefix with wine, mdac28 and jet40. In the past when it did run wine --version said 5.0.1 and since this latest complete reinstallation says 5.0.2

I'm sorry if it appears I'm writing another tome. I'm just trying to get this to run and if that includes somehow trying to figure out how to debug something I don't have a clue how to do that maybe someone will give some guidance. I want to learn how people are determining what is wrong so if this keeps happening in the future I can do that myself instead of continually posting here.

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

Re: Mint 20, 32-bit application

Post by spoon0042 » Thu Oct 22, 2020 11:15 am

Did you add the override for odbccp32 after running winetricks? That's what worked for me, although I only have the sample db from Legacy to test. I've attached what my winecfg looks like. I don't know what else it could be, unless you're mixing up wineprefixes somehow; are you setting WINEPREFIX when running winecfg / winetricks as well?
winecfg.png
winecfg
winecfg.png (3.99 KiB) Viewed 154 times

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Thu Oct 22, 2020 5:07 pm

Ok, I thought when you said "msado15 not set that it shouldn't show in the libraries list, so as mentioned above I had removed it.

Code: Select all

spoon0042 wrote: ↑
Thu Jul 16, 2020 11:49 am
Oh good, I got it to work. It seems there may be an issue with winetricks where I'm not clear on which dlls should have an override set. Don't worry about that though unless in the future you have a problem again that would be useful information.

odbccp32 native,builtin
msado15 not set 
Adding odbccp32 and not touching msado15 did allow it to run. So I guess I completely misunderstood what you were saying about msado15.

Is there anyway, even if in PM's, you can explain to me how you determined these things? I *REALLY* want to be able to try to determine things like this on my own, but I have no clue right now. I HATE creating posts like this one and the others if there is a way I can determine these things myself. I had walked through the other threads before creating this one but as mentioned above misunderstood what you were saying. So, for example, how did you determine that odbccp32 needed to be added and that I had to be sure msado15 was there? Thank you for any help you might be able to provide to help me do these things on my own.

As an example, running depends x86 on the gedstar executable shows no trace of odbccp32.


Thank you again for your help and patience!

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

Re: Mint 20, 32-bit application

Post by spoon0042 » Thu Oct 22, 2020 9:57 pm

"not set" wasn't clear, yeah, I think maybe I tried either way but I'm not sure. Glad it's working.

As for how I got there, not sure either. :) I'd been following some threads here and issues on winetricks. Took a look at what winetricks was doing for mdac installs. Which for recent wine is *not* overriding odbccp32, and I don't know if that makes sense or not... how different dlls interact and stuff like that is kind of a mystery to me still. Like I know it's possible to trace what dlls are used, etc. but not really how to do it which would be useful to know if wine is doing something different from windows.

Don't be afraid to ask questions, it's generally harmless even if some people are less than pleasant about it.

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

Re: Mint 20, 32-bit application

Post by spoon0042 » Thu Oct 22, 2020 10:15 pm

Like I know enough to go poking around and finding what debug channel to use, trying with builtin odbccp32 and WINEDEBUG=+odbc and getting something like

Code: Select all

0009:trace:odbc:SQLGetPrivateProfileString "Microsoft Access Driver (*.mdb)" "setup" "" 0032C9D4 260 "odbcinst.ini"
Any more than that though? I may be able to find out what exactly is failing, and it might be a bug, at least the comment on the winetricks tracker seemed to imply it should work. eh.

e: it's possible there's some additional configuration needed and using native odbccp32 is just a workaround? there's this section that I'm trying to make sense of but that's all for today lol https://wiki.winehq.org/Wine_User%27s_G ... _Databases

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Thu Oct 22, 2020 10:38 pm

I guess I'm a lost cause. I still don't see how one knows you need to add odbccp32 before trying to debug, and then knowing to debug on odbc. Thanks.

I guess I hope I don't run into problems in the future as I just don't want to create anymore threads or posts on Gedstar Pro and wine.

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Fri Oct 23, 2020 12:02 am

Thank you for this! I have no idea what to look for for documentation so the link is appreciated. After seeing your winedebug syntax I thought ok - must be something in odbcinst.ini file. I can't find the file. I was hoping to be able to trace how you got to odbcc32 but so far no luck. I will be slowly digging into this more and hope I don't find myself going out into some non-useful sidetrack ;)

I hate to sound so stupid, and I hope you don't think I'm pestering you as I don't mean to. I know when I originally had problems with Gedstar Pro way back when Bob Wya had talked about what winetricks was doing and at that time I didn't even know it was a script! I've made it that far but again I must be missing the next step I should be taking to help myself.

Thank you SO MUCH FOR YOUR HELP!! I am so thankful to have Gedstar Pro running again it is hard to describe as it is very important to me.
spoon0042 wrote:
Thu Oct 22, 2020 10:15 pm
Like I know enough to go poking around and finding what debug channel to use, trying with builtin odbccp32 and WINEDEBUG=+odbc and getting something like

Code: Select all

0009:trace:odbc:SQLGetPrivateProfileString "Microsoft Access Driver (*.mdb)" "setup" "" 0032C9D4 260 "odbcinst.ini"
Any more than that though? I may be able to find out what exactly is failing, and it might be a bug, at least the comment on the winetricks tracker seemed to imply it should work. eh.

e: it's possible there's some additional configuration needed and using native odbccp32 is just a workaround? there's this section that I'm trying to make sense of but that's all for today lol https://wiki.winehq.org/Wine_User%27s_G ... _Databases

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Fri Oct 23, 2020 5:49 am

Crap. I was searching on odbcc32, not odbccp32, and hence why I didn't find it. I see in winetricks where it is overriding a bunch of built-in dlls, and again in the mdac "section"

Code: Select all

w_metadata native_mdac settings \
    title_uk="Перевизначити odbc32, odbccp32 та oledb32" \
    title="Override odbc32, odbccp32 and oledb32"

load_native_mdac()
{
    # Set those overrides globally so user programs get MDAC's ODBC
    # instead of Wine's unixodbc

    # https://github.com/Winetricks/winetricks/issues/1447
    if w_wine_version_in 4.22, ; then
        w_override_dlls native,builtin msado15
    fi

    # https://github.com/Winetricks/winetricks/issues/1448
    if w_wine_version_in ,4.22 ; then
        w_override_dlls native,builtin odbccp32
    fi

    w_override_dlls native,builtin mtxdm odbc32 oledb32
}
So, I have no clue right now where the wine version is determined, and therefore if comparing it to 4.22 is even valid, so here's what I'm wondering: I don't know how/when load_native_mdac() gets called but if it is comparing only to 1 wine version it doesn't set odbccp32 to native, builtin does it? I have no clue if this has anything to do with odbccp32 not being set or not as I'm having a hard time following things that far.

I can't remember if you mentioned this already or not, but this *might* be a clue:

Code: Select all

https://github.com/Winetricks/winetricks/issues/1448
As best I can tell all of this has something to do with mdac28. I can't tell for sure but I think everything is saying the override is no longer needed by mdac28, and the link above also has a link to the source code but I don't have enough experience to be able to follow it.

For a test I installed just jet40. It installs mdac27 first then jet. When I check with winecfg after that odbccp32 is not shown. I then installed mdac28 to that test and again odbccp32 doesn't show. In addition, as Bob Wya had said back in the initial thread on this, mdac28 MUST come first in order for GEDSTAR to run. So, mdac28 is installing somethings that help and others that must get overwritten or something by mdac27. Either way around, the echo's from winetricks don't show any mention of odbccp32 - perhaps from the above?

So, I don't know - this may be something unique to getting GedStar Pro to run. Even so, it might be worth pursuing why the override of odbcc32 was apparently dropped.

I think maybe we've gone as far on this as we can - but if you know I'm not correct and goofing up again please let me know. Otherwise I don't know if I should try to post this as a bug or perhaps more precisely have the GedStar Pro entry (if it exists) in the wineapp db to mention you must specify odbcc32.dll as native, builtin. I suspect that's where it probably needs to go

I suppose I'm way off base again - sigh. Either way, thank you SO MUCH again for all of your help on this!

Have a great weekend and week!
Dave

fargodwe
Level 4
Level 4
Posts: 245
Joined: Mon Oct 02, 2017 7:08 am

Re: Mint 20, 32-bit application

Post by fargodwe » Fri Oct 23, 2020 4:30 pm

Indeed a potential bug in winetricks at that load_native_mdac. I commented out the "if" and "fi" so it was no longer conditional then recreated the prefix. Indeed odbccp32.dll is now correct and no need to specifically add it under libraries. I don't where to turn to ask a question about winetricks. Do you have any idea where we would post something on this?

Thanks again for all of your help!

For GedStar Pro this is now a finished thread. Winetricks? I don't know.

EDIT: I just filed a bug report with winetricks on the github for it.

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

Re: Mint 20, 32-bit application

Post by spoon0042 » Fri Oct 23, 2020 6:10 pm

I can try to clear up a few things, maybe more later.

The w_wine_version_in bit compares the wine version (that winetricks gets from either /usr/bin/wine or set with WINE=/path/to/wine) to a given version. ',4.22' means 'up to' 4.22. So 5.0 or 5.19 will return false, and in that case skips the override for odbccp32. (At least now that a bug in winetricks has been fixed, anyway. Works now, don't worry about it.)

The url in winetricks there - https://github.com/Winetricks/winetricks/issues/1448 - is what I was talking about with that 'supposed to work' bit. Apparently the guy who implemented (parts of?) odbccp32 in wine filed that report and says that behavior is correct. I don't know enough to say so hopefully you'll get some help there. You may be able to message him on github, or by email, if you're feeling adventurous.

And I don't know, it's possible something needs configured some way (like did it just work "out of the box" on windows or what) or some different combination of builtin and native dlls works now. Ideally this would be documented somewhere, huh. It's also still possible wine's implementation isn't complete enough for Gedstar to run properly. Anyway, good luck.

Post Reply