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

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 :




The Guest



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 :

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



Cheers
jimbo

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?

johnp said:

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?

Click to expand...

192.168.1.97

Cheers
jimbo

jimbo45 said:

192.168.1.97

Cheers
jimbo

Click to expand...

I noticed Fedora has the same IP address as Arch Linux.

Did you run both of them together?

Glad you're our resident VM guy @jimbo45. All waaaay over my head.

johnp said:

I noticed Fedora has the same IP address as Arch Linux.

Did you run both of them together?

Click to expand...

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

It can be many reasons.

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

johnp said:

It can be many reasons.

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

Click to expand...

All done with DHCP.

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

Cheers

jimbo

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?

Hopachi said:

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?

Click to expand...

@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.



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




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 :




Cheers
jimbo