ODBC error : OLE DB

Questions about Wine on macOS.
Locked
G-oker
Level 1
Level 1
Posts: 5
Joined: Sun Oct 25, 2020 1:21 pm

ODBC error : OLE DB

Post by G-oker »

Hello,
I’m new to using Wine, and to Mac OS (10.12).
I’m trying to get a windows only MS SQL accessing program to run using Wine.

The program installs fine , and the sqlncli installs fine as well.

When I try and run the exe though, I see the message :

0009:err:oledb:get_data_source OBDC provider for OLE DB nor registered.

I’ve read some post from Ubuntu users about installing winetricks and running MDAC.
This is were I’m stuck.

Using MAC is 10.12 and the latest copy of Wine, how can I get the ODBC installed so the exe works ?

Thank you
Gcenx
Level 6
Level 6
Posts: 709
Joined: Mon Dec 25, 2017 12:11 pm

Re: ODBC error : OLE DB

Post by Gcenx »

https://github.com/Winetricks/winetricks

The readme that you are when loading the repository provides to easy ways to install winetricks on macOS and provides links
G-oker
Level 1
Level 1
Posts: 5
Joined: Sun Oct 25, 2020 1:21 pm

Re: ODBC error : OLE DB

Post by G-oker »

Hi Gcenx,
Thank you. I’m new to MacBooks, so I don’t know how to install winetricks.
Could someone walk me though it ?
G-oker
Level 1
Level 1
Posts: 5
Joined: Sun Oct 25, 2020 1:21 pm

Re: ODBC error : OLE DB

Post by G-oker »

hi. I have now installed home-brew, and then brewed wine tricks. when I now run
sh winetricks mdac28
I get the message

warning: taskset/cpuset not available on your platform!
------------------------------------------------------
wineserver not found!
------------------------------------------------------

I'm running the latest os this machine can take (10.12).
Do I need to get hold an older version of wine tricks ? if so, how do I uninstall the current one and how do I install the pervious one ?

if not, what can I do to resolve this issue ?

thank you
Gcenx
Level 6
Level 6
Posts: 709
Joined: Mon Dec 25, 2017 12:11 pm

Re: ODBC error : OLE DB

Post by Gcenx »

You need to launch the “Wine Stable/Devel/Staging” app you installed and run winetricks from there. You don’t need to use “sh” before it.

Alternatively trash the currently installed wine packaged and then install again via brew, the I’d updated the needed command a while back in the macOS section
G-oker
Level 1
Level 1
Posts: 5
Joined: Sun Oct 25, 2020 1:21 pm

Re: ODBC error : OLE DB

Post by G-oker »

HI,
I have removed and brewed Wine and win tricks, and have installed MDAC using
winetricks mdac28
This completes without error :)
When I run the application , login fails, and I can see this in the terminal screen:

0009:fixme:heap:RtlSetHeapInformation 0x0 1 0x0 0 stub
0009:fixme:win:AnimateWindow partial stub
0009:fixme:win:AnimateWindow partial stub
0009:err:winediag:SECUR32_initNTLMSP ntlm_auth was not found or is outdated. Make sure that ntlm_auth >= 3.0.25 is in your path. Usually, you can find it in the winbind package of your distribution.
0009:fixme:kerberos:kerberos_SpAcquireCredentialsHandle (<null> 0x00000003 0x0 0x0 0x0 0x0 0x319abc 0x319c80)
0009:fixme:kerberos:kerberos_SpAcquireCredentialsHandle Wine was built without Kerberos support.
0009:fixme:keyboard:macdrv_ActivateKeyboardLayout flags 1 not supported
0009:fixme:keyboard:macdrv_ActivateKeyboardLayout flags 1 not supported
0009:fixme:keyboard:macdrv_ActivateKeyboardLayout flags 1 not supported
0009:fixme:win:AnimateWindow partial stub
0009:fixme:msg:pack_message msg 14 (WM_ERASEBKGND) not supported yet
0009:fixme:msg:pack_message msg 14 (WM_ERASEBKGND) not supported yet
0009:fixme:msvcrt:__clean_type_info_names_internal (0x339934a8) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x14f41074) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x1e6993c) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x1ac05bc) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x11ea9830) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x10c92984) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x357a94) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x417168) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x3b4474) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x3a5650) stub
0009:fixme:msvcrt:__clean_type_info_names_internal (0x391dd4) stub

I thought it might have been the line

0009:err:winediag:SECUR32_initNTLMSP ntlm_auth was not found or is outdated. Make sure that ntlm_auth >= 3.0.25 is in your path. Usually, you can find it in the winbind package of your distribution.

so I search for this, and ended up running dot net

winetricks -q dotnet45 corefonts

but after the installs had finished, I still get the same issue .

Ive tried wine winecfg and changing the OS type (from 2003 to NT4, xp and 10), but still get the same as above.
Ive added KERBEROS in the winecfg libraries section (native, builtin)....same issue.

am I looking at the wrong line here, and should I be resolving the kerberos line ?
either way, can someone advise on how I could resolve this ?

thank you :D
Gcenx
Level 6
Level 6
Posts: 709
Joined: Mon Dec 25, 2017 12:11 pm

Re: ODBC error : OLE DB

Post by Gcenx »

Your going to need to compile wine from source with Kerberos support enabled along with the needed built time dependencies
G-oker
Level 1
Level 1
Posts: 5
Joined: Sun Oct 25, 2020 1:21 pm

Re: ODBC error : OLE DB

Post by G-oker »

Is there anywhere that will walk me though doing that ?
Gcenx
Level 6
Level 6
Posts: 709
Joined: Mon Dec 25, 2017 12:11 pm

Re: ODBC error : OLE DB

Post by Gcenx »

G-oker wrote: Thu Nov 05, 2020 1:52 am Is there anywhere that will walk me though doing that ?
Theres no updated guides on compiling wine from source on macOS.

I’ll check how many additional libraries are needed for Kerberos support and see if it’s worth adding into my packages
Locked