Fedora 39 Host with Win 11 PRO as VM on KVM/QEMU - EXCEL error


jimbo45

Well-known member
Pro User
VIP
Local time
9:27 AM
Posts
4,005
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Hi folks
Seems a weird problem if you use Fedora rel 39 as HOST and Win 11 pro as Guest on KVM/QEMU. If you run an Ms query on EXCEL via GET data ->from other sources-> from Microsoft query then you get "server error" when you try and retrieve data from a Maria/MySQL database. I suspect it's a problem with the ODBC driver. I'm using Office 2021 Pro. You can use either the oracle or the MariaDB ODBC drivers. The same identical VM runs perfectly on Arch Linux as host.

The same error occurs with Win11 Enterprise and Win 2022 Server.

Note - HEDISQL can still access the relevant databases remotely so it's definitely something in the ODBC / EXCEL connect that's an issue. -- Since I don't use Fedora that much it's not really an issue but just pointing out to those who do use it and run Windows VM's with KDE/QEMU.

Here's what works

The Host :

Screenshot_20240205_101044.png


The Guest

Screenshot_20240205_101115.png

Here's what Fails

On Fedora instead of the result of the query back in EXCEL (as above) you get Error --can't connect to server. Host running on same hardware as previous examples. Same laptop.


Fedora Host : Screenshot_20240205_105306.png

Same query on Guest : Note it shouldn't even be using local host for this query either !!!!!

Screenshot_20240205_105141.png

Cheers
jimbo
 
Last edited:

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
Perhaps Fedora VM uses a virtual LAN, with different IP ranges, than the IP addresses of the database servers.

What is the IP address of the Fedora VM?
 

My Computer

System One

  • OS
    Windows 11 Pro with Debian Linux in WSL 2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Build to Order machine
    CPU
    Intel Core i7-4790 (Haswell Refresh)
    Motherboard
    MSI Z97 Gaming 7
    Memory
    32 GB
    Graphics Card(s)
    GIGABYTE NVIDIA GeForce RTX 2060 GAMING OC PRO 6G
    Monitor(s) Displays
    LG 27GN650-B IPS HDR Gaming Monitor 27" FHD
    Screen Resolution
    1080p
    Hard Drives
    2 x Samsung 860 EVO SATA SSD 1TB
    1 x Samsung 870 EVO SATA SSD 2TB
    PSU
    Corsair 1000 Watt
    Case
    Corsair Obsidian Series 750D full tower ATX case
    Cooling
    CORSAIR Hydro Series H80i v2
    Internet Speed
    1 Gbps / 1 Gbps symmetrical FTTH (GPON)
    Browser
    Microsoft Edge
Perhaps Fedora VM uses a virtual LAN, with different IP ranges, than the IP addresses of the database servers.

What is the IP address of the Fedora VM?
192.168.1.97

Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

My Computer

System One

  • OS
    Windows 11 Pro with Debian Linux in WSL 2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Build to Order machine
    CPU
    Intel Core i7-4790 (Haswell Refresh)
    Motherboard
    MSI Z97 Gaming 7
    Memory
    32 GB
    Graphics Card(s)
    GIGABYTE NVIDIA GeForce RTX 2060 GAMING OC PRO 6G
    Monitor(s) Displays
    LG 27GN650-B IPS HDR Gaming Monitor 27" FHD
    Screen Resolution
    1080p
    Hard Drives
    2 x Samsung 860 EVO SATA SSD 1TB
    1 x Samsung 870 EVO SATA SSD 2TB
    PSU
    Corsair 1000 Watt
    Case
    Corsair Obsidian Series 750D full tower ATX case
    Cooling
    CORSAIR Hydro Series H80i v2
    Internet Speed
    1 Gbps / 1 Gbps symmetrical FTTH (GPON)
    Browser
    Microsoft Edge
Glad you're our resident VM guy @jimbo45. All waaaay over my head. o_O
 

My Computers

System One System Two

  • OS
    Windows 11 Pro 23H2 22631.3447
    Computer type
    PC/Desktop
    Manufacturer/Model
    Dell Optiplex 7080
    CPU
    i9-10900 10 core 20 threads
    Motherboard
    DELL 0J37VM
    Memory
    32 gb
    Graphics Card(s)
    none-Intel UHD Graphics 630
    Sound Card
    Integrated Realtek
    Monitor(s) Displays
    Benq 27
    Screen Resolution
    2560x1440
    Hard Drives
    1tb Solidigm m.2 +256gb ssd+512 gb usb m.2 sata
    PSU
    500w
    Case
    MT
    Cooling
    Dell Premium
    Keyboard
    Logitech wired
    Mouse
    Logitech wireless
    Internet Speed
    so slow I'm too embarrassed to tell
    Browser
    Firefox
    Antivirus
    Defender+MWB Premium
  • Operating System
    Windows 10 Pro 22H2 19045.3930
    Computer type
    PC/Desktop
    Manufacturer/Model
    Dell Optiplex 9020
    CPU
    i7-4770
    Memory
    24 gb
    Monitor(s) Displays
    Benq 27
    Screen Resolution
    2560x1440
    Hard Drives
    256 gb Toshiba BG4 M.2 NVE SSB and 1 tb hdd
    PSU
    500w
    Case
    MT
    Cooling
    Dell factory
    Mouse
    Logitech wireless
    Keyboard
    Logitech wired
    Internet Speed
    still not telling
    Browser
    Firefox
    Antivirus
    Defender+MWB Premium
I noticed Fedora has the same IP address as Arch Linux.

Did you run both of them together?
No --that was the whole point --to run both on identical hardware one after the other --the fedora and arch linux installs were installed individually on the same internal HDD -- packages as far as is possible the same and the VM file identical.

The crazy thing is if I created the VM file first on the Fedora system and then booted up the Arch Linux system it worked (but still not on the Fedora system). (I installed the Linux Hosts on the same HDD -- 100% wiping the HDD after each test).

I've done a rigorous test here so there's definitely something wrong. It works actually on Fedora 38 !!! and I'll have another go on the soon to appear Fedora 40.

Anyway I'm not spending any more time on this as Fedora 40 at least in beta is only a few weeks off and my daily use of Windows is usually as a VM on Arch Linux (so it should work on Debian / Manjaro / Ubuntu and other Debian based systems)

Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
It can be many reasons.

Did you try with DHCP, to give the virtual machines their IP addresses, instead of configuring them manually?
 

My Computer

System One

  • OS
    Windows 11 Pro with Debian Linux in WSL 2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Build to Order machine
    CPU
    Intel Core i7-4790 (Haswell Refresh)
    Motherboard
    MSI Z97 Gaming 7
    Memory
    32 GB
    Graphics Card(s)
    GIGABYTE NVIDIA GeForce RTX 2060 GAMING OC PRO 6G
    Monitor(s) Displays
    LG 27GN650-B IPS HDR Gaming Monitor 27" FHD
    Screen Resolution
    1080p
    Hard Drives
    2 x Samsung 860 EVO SATA SSD 1TB
    1 x Samsung 870 EVO SATA SSD 2TB
    PSU
    Corsair 1000 Watt
    Case
    Corsair Obsidian Series 750D full tower ATX case
    Cooling
    CORSAIR Hydro Series H80i v2
    Internet Speed
    1 Gbps / 1 Gbps symmetrical FTTH (GPON)
    Browser
    Microsoft Edge
It can be many reasons.

Did you try with DHCP, to give the virtual machines their IP addresses, instead of configuring them manually?
All done with DHCP.

Anyway I'd leave this now as I'll wait till Fedora 40 before having another go.

Cheers

jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
Weird issue from what I can read above.
Never seen it yet as I don't use those exact programs in mentioned VMs.

It can indeed be many reasons.
One thing that came to mind is maybe the firewall rules on the F39 host may be different than Arch's or F38's, who knows. I guess they're at default. So it may indeed be the odbc driver... but can you test in different Office version?
 

My Computers

System One System Two

  • OS
    Windows 11 Pro
    Computer type
    PC/Desktop
    Manufacturer/Model
    Intel NUC
    CPU
    i3 8109U
    Motherboard
    Intel
    Memory
    16GB DDR4 @2400
    Graphics Card(s)
    Intel Iris Plus Graphics 655
    Sound Card
    Intel / Realtek HD Audio
    Monitor(s) Displays
    LG-32ML600M
    Screen Resolution
    1920x1080
    Hard Drives
    Intel SSD 250GB + Samsung QVO SSD 1TB
    PSU
    Adapter
    Cooling
    The usual NUC airflow
    Keyboard
    Logitech Orion G610
    Mouse
    SteelSeries Rival 100 Red
    Internet Speed
    Good enough
    Browser
    Chromium, Edge, Firefox
    Antivirus
    Windows Defender
  • Operating System
    CentOS 9 Stream / Alma / Rocky / Fedora
    Computer type
    Laptop
    Manufacturer/Model
    TOSHIBA
    CPU
    Intel i7 4800MQ
    Motherboard
    TOSHIBA
    Memory
    32GB DDR3 @1600
    Graphics card(s)
    NVIDIA Quadro K2100M
    Sound Card
    Realtek HD Audio
    Monitor(s) Displays
    Built-in
    Screen Resolution
    1920x1080
Weird issue from what I can read above.
Never seen it yet as I don't use those exact programs in mentioned VMs.

It can indeed be many reasons.
One thing that came to mind is maybe the firewall rules on the F39 host may be different than Arch's or F38's, who knows. I guess they're at default. So it may indeed be the odbc driver... but can you test in different Office version?


@johnp

The Fedora system is the HOST and Windows the VM. !!!

@Hopachi

what I'm trying to do is use the Query facility in EXCEL (Get data --> from other sources -->Microsoft query) to get data from classicmodels MariaDB on my NAS on the same LAN so access / network issues not a problem:

From Windows VM via SSH to login to the NAS (install openssh-server from the Windows add optional features and in services ensure it's started and starts automatically at Windows boot) the DB is perfectly accessible.

Screenshot_20240206_092916.png

The DB is OK as well-- no errors in it. Here's the ist 10 rows of customers in the classicmodels DB.

BTW this is a free test DB available on the web for testing Mysql / MariaDB databases obtainable at


Screenshot_20240206_095423.png

No -- I've only got Office 2021 and the 32 bit version of Office2010 -- I might just for a bit of time wasting create another Windows VM and accept a 30 day free trial of Office/365 to see if it works.

Office 2010 is too old for these types of queries so no good testing on that. Also I only have Office 2010 32 bit edition - which means installing the 32 bit ODBC driver which creates a different scenario so you won't be comparing like with like-

The problem with that is after the 30 day expiry you'll get nag letters "ad nauseam" begging you to sign up or wanting reasons why you've declined the offer. I don't want todo a "blanket ban" on emails from Microsoft, or relegate those to the junk mail or this folder :

Screenshot_20240206_092424.png


Cheers
jimbo
 
Last edited:

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

Latest Support Threads

Back
Top Bottom