Need help connecting to MSSQL, program CAN see the db

Questions about Wine on Linux
Post Reply
User avatar
rob215x
Level 1
Level 1
Posts: 5
Joined: Sun Apr 28, 2024 12:49 am

Need help connecting to MSSQL, program CAN see the db

Post by rob215x »

I'm trying to help a friend get an old database program running on Linux. He's an hour away so I go down there on Sundays. I ALMOST have the program working but it just won't connect to the database.

Here's what I have so far, let me know if you need any more details.

- The original software has a MSSQL database running on a Windows Server 2003 machine on his local network.
- The client software works on Windows XP or Windows 7. I have it working on a Windows 7 machine so I should be able to copy any settings I need.
- The Linux machine is running the latest version of Manjaro with XFCE. I installed it but I don't have the machine in front of me, so if you need details, I can give those tomorrow.
- I installed the latest version of Wine last week, so everything should be up to date.

I took a few notes so here's what I did:

Code: Select all

$ export WINEARCH=win32
$ winetricks atmlib gdiplus msxml3 msxml6 vcrun2005 vcrun2005sp1 vcrun2008 ie6 fontsmooth=rgb gecko
I ran the installer but it stopped with the error:
"Setup was unable to load the following DLL: C:\users\user\Temp\{...}\_mxuser.dll"

So I fixed that with:

Code: Select all

$ winetricks mfc42
Then it asks for the registration information and that all worked.

Next, it looks for the database on the network, but it couldn't find one and it eventually times out and says you need to have a running database etc etc.

I found this page:
https://wiki.winehq.org/Wine_User%27s_G ... BC_drivers

I couldn't find a mdac_typ.exe online that looked legit, but I found one on my friend's MSSQL server!

I copied it to the local wine folder and tried:

Code: Select all

$ wine MDAC_TYP.EXE
but I got ""This setup does not support installing on this operating system" so I'm not sure if that was a Windows issue or a Wine issue.

Next, I tried:

Code: Select all

$ winetricks mdac27
That seemed to install just fine so I did:

Code: Select all

$ cd ~/.wine/drive_c/windows/system32
$ wine cliconfg.exe
$ wine odbcad32.exe
I copied the settings from the real Windows 7 machine

Now I tried the installer again, and this time IT FOUND THE DATABASE!!
- it has a little window that lists any databases it finds on the network, and it found a test database I made a while ago when we were trying to get this software working, and it found the actual working database as well!

So I thought I was home free! But no... I select the database and click Next...

Then in my Linux terminal, I just get a ton of these...

Code: Select all

GnuTLS error: No or insufficient priorities were set.
GnuTLS error: No or insufficient priorities were set.
GnuTLS error: No or insufficient priorities were set.
GnuTLS error: No or insufficient priorities were set.
GnuTLS error: No or insufficient priorities were set.
GnuTLS error: No or insufficient priorities were set.
GnuTLS error: No or insufficient priorities were set.
It just seems odd that it can SEE the database but can't connect to it? I'm not sure what to do next.

At first, I thought it might be because the Windows network has a username and password but on the Linux side I already have the server mapped to drive R, and in Wine I CAN open the shared R drive.

I don't know what to try next. Any ideas would be appreciated. I'll be down at his place tomorrow, Sunday 28 April.

Thanks!
User avatar
rob215x
Level 1
Level 1
Posts: 5
Joined: Sun Apr 28, 2024 12:49 am

Re: Need help connecting to MSSQL, program CAN see the db

Post by rob215x »

I'm here at my friend's place and I'm trying to copy info FROM odbcad32.exe on the real Windows 7 machine TO the same panel on wine. Here's a screenshot of what it does when I try to connect...
Screenshot_2024-04-28_18-31-33.png
User avatar
rob215x
Level 1
Level 1
Posts: 5
Joined: Sun Apr 28, 2024 12:49 am

Re: Need help connecting to MSSQL, program CAN see the db

Post by rob215x »

Next, I tried creating a new connection with the ODBC panel, since I have a username and password for the MS SQL server. While it still failed as before, I saw some new items in the terminal window I had not seen before...
Screenshot_2024-04-28_19-39-27.png
If anyone has any suggestions for what to try next, I would love it!!

thanks! :D
jakedata
Newbie
Newbie
Posts: 1
Joined: Tue May 21, 2024 1:02 pm

Re: Need help connecting to MSSQL, program CAN see the db

Post by jakedata »

Are you connecting to an ancient MS Sql server?

I saw: GnuTLS error: No or insufficient priorities were set.

until I commented out disabled-version = tls1.0 in /etc/gnutls/config

Now I get past that particular error. Still got 99 problems but this ain't one.
User avatar
rob215x
Level 1
Level 1
Posts: 5
Joined: Sun Apr 28, 2024 12:49 am

Re: Need help connecting to MSSQL, program CAN see the db

Post by rob215x »

Yes, I AM connecting to an ancient MS SQL server on the local network.

I HAVE successfully connected by doing the following:

Code: Select all

$ winetricks mdac28
I had previously tried mdac27 but it was actually TOO old and didn't install a driver needed by MS SQL Server needed.

Now, it connects without any issue and I can even open the Windows ODBC Administrator and test the connection!

Code: Select all

$ cd ~/.wine/drive_c/windows/system32
$ wine odbcad32.exe
User avatar
rob215x
Level 1
Level 1
Posts: 5
Joined: Sun Apr 28, 2024 12:49 am

Re: Need help connecting to MSSQL, program CAN see the db

Post by rob215x »

Now, I'm at a new roadblock...

The Maximizer 12 installer goes through its process, checks the registration and serial, tests the connection to the MS MQL Server, and even asks if I want to add a desktop shortcut. The installer completes and says everything is ready to go.

When I start the program, the little Maximizer Title box appears for a second, then disappears. This is the normal operation. But then nothing. Nothing happens. The main program window doesn't open.

Here's the output in my terminal:

Code: Select all

$ cd '/home/user/.wine/drive_c/Program Files/Maximizer'
$ wine MaxWin.exe
0024:fixme:heap:RtlSetHeapInformation HEAP_INFORMATION_CLASS 1 not implemented!
0024:fixme:shcore:SetCurrentProcessExplicitAppUserModelID L"Maximizer.MaximizerCRM.AMGR": stub

$ 0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F7C4, 0031F93C 0031F7CC
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F7C4 0031F93C 0031F7CC) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F7CC, 0031F83C 0031F7D4
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F7CC 0031F83C 0031F7D4) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F670, 0031F7E8 0031F678
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F670 0031F7E8 0031F678) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F688, 0031F6F8 0031F690
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F688 0031F6F8 0031F690) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F624, 0031F79C 0031F62C
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F624 0031F79C 0031F62C) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F628, 0031F7A0 0031F630
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F628 0031F7A0 0031F630) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F668, 0031F7E0 0031F670
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F668 0031F7E0 0031F670) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F7D4, 0031F844 0031F7DC
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F7D4 0031F844 0031F7DC) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F694, 0031F80C 0031F69C
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F694 0031F80C 0031F69C) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F664, 0031F7DC 0031F66C
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F664 0031F7DC 0031F66C) returning a dummy value (current locale)
0110:fixme:heap:RtlSetHeapInformation HEAP_INFORMATION_CLASS 1 not implemented!
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031F54C, 0031F5BC 0031F554
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031F54C 0031F5BC 0031F554) returning a dummy value (current locale)
0110:fixme:shcore:SetCurrentProcessExplicitAppUserModelID L"Maximizer.MaximizerCRM.AMGR": stub
0110:fixme:file:NtLockFile I/O completion on lock not implemented yet
0110:err:ole:com_get_class_object class {6c736db1-bd94-11d0-8a23-00aa00b58e10} not registered
0110:err:ole:com_get_class_object no class object {6c736db1-bd94-11d0-8a23-00aa00b58e10} could be created for context 0x1
0110:fixme:ntdll:NtQuerySystemInformation info_class SYSTEM_PERFORMANCE_INFORMATION
0110:fixme:msg:ChangeWindowMessageFilter 323 00000001
0110:fixme:msg:ChangeWindowMessageFilter 326 00000001
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031E398, 0031E510 0031E3A0
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031E398 0031E510 0031E3A0) returning a dummy value (current locale)
0110:fixme:msvcrt:__clean_type_info_names_internal (05FA8964) stub
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031DF10, 0031E088 0031DF18
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031DF10 0031E088 0031DF18) returning a dummy value (current locale)
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031E3C8, 0031E540 0031E3D0
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031E3C8 0031E540 0031E3D0) returning a dummy value (current locale)
0110:fixme:msvcrt:__clean_type_info_names_internal (05FD9994) stub
0110:fixme:nls:RtlGetThreadPreferredUILanguages 00000034, 0031DF40, 0031E0B8 0031DF48
0110:fixme:nls:get_dummy_preferred_ui_language (0x34 0x409 0031DF40 0031E0B8 0031DF48) returning a dummy value (current locale)
0088:fixme:appbar:handle_appbarmessage SHAppBarMessage(ABM_GETAUTOHIDEBAR, hwnd=00000000, edge=3): stub
0088:fixme:appbar:handle_appbarmessage SHAppBarMessage(ABM_GETAUTOHIDEBAR, hwnd=00000000, edge=1): stub
0088:fixme:appbar:handle_appbarmessage SHAppBarMessage(ABM_GETAUTOHIDEBAR, hwnd=00000000, edge=0): stub
0088:fixme:appbar:handle_appbarmessage SHAppBarMessage(ABM_GETAUTOHIDEBAR, hwnd=00000000, edge=2): stub
0110:fixme:win:NtUserLockWindowUpdate (0x20154), partial stub!
0110:fixme:win:NtUserLockWindowUpdate ((nil)), partial stub!
0110:err:ole:com_get_class_object class {d844289b-ef60-46d2-a252-26ccdc1b401c} not registered
0110:err:ole:com_get_class_object class {d844289b-ef60-46d2-a252-26ccdc1b401c} not registered
0110:err:ole:create_server class {d844289b-ef60-46d2-a252-26ccdc1b401c} not registered
0110:fixme:ole:com_get_class_object CLSCTX_REMOTE_SERVER not supported
0110:err:ole:com_get_class_object no class object {d844289b-ef60-46d2-a252-26ccdc1b401c} could be created for context 0x17
0110:fixme:msvcrt:__clean_type_info_names_internal (05FD9994) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (05FA8964) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (0249555C) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (01EA9ADC) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (01E84B0C) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (01DDC754) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (6626125C) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (01CBDB54) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (01C72814) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (6422CAE4) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (642CDA64) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (6032E37C) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (1004EC24) stub
0110:fixme:msvcrt:__clean_type_info_names_internal (78E6F254) stub
it just hangs there until I hit CTRL-C
Post Reply