Solved Help wanted with ODBC create new data source please


jimbo45

Well-known member
Power User
VIP
Local time
10:17 AM
Posts
1,894
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Hi folks
I'm messing around with trying to pull data from a MariaDB into EXCEL

I've downloaded the Windows ODBC mariaDB driver
Now I'm trying to install the new data source via Add data sources in Windows.

I get the popup panel - but what do I put in the server name

The data base is on my local NAS server at 192.168.1.56 do I use the IP address or the Named page ??

but not sure what's next

Skjámynd 2022-04-17 090518.png

The DB on the server is working properly for example : I can login over LAN to "Remote Computer serving the DB" - it's on the same LAN of course and I'm using the local web server serving phpadmin to browse tables in a test database called classic models -- there's no "Live" data here so no "data protection issues". It's a 100% test system.

The MariaDB is also configured on the NAS to allow remote connections.

Skjámynd 2022-04-17 091626.png

probably obvious to Windows people but this stuff is new to me - and always like learning new stuff. I can usually do the "Hard bits" but get stuck at the "Basics" !! like Login !!!!!!

Remote access from windows via ssh also OK so DB and connectivity are OK.

Skjámynd 2022-04-17 100306.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

z3r010

Administrator
Staff member
Local time
11:17 AM
Posts
2,090
Location
Worsley, Manchester, UK
OS
Windows 11 Workstation
The data base is on my local NAS server at 192.168.1.56 do I use the IP address or the Named page ??
I'd use the IP and port, if you are having trouble connecting then use something that is simple to connect to the database like HeidiSQL to make sure the connection details work.
 

My Computers

System One System Two

  • OS
    Windows 11 Workstation
    Computer type
    PC/Desktop
    Manufacturer/Model
    doofenshmirtz evil incorporated
    CPU
    Ryzen 9 5950X
    Motherboard
    Asus ROG Crosshair VIII Formula
    Memory
    Corsair Vengeance RGB PRO Black 64GB (4x16GB) 3600MHz AMD Ryzen Tuned DDR4
    Graphics Card(s)
    ASUS AMD Radeon RX 6900 XT 16GB ROG Strix LC OC
    Sound Card
    Sound BlasterX Katana
    Monitor(s) Displays
    3 x27" Dell U2714H & 1 x 34" Dell
    Hard Drives
    Samsung 980 Pro 1TB M.2 2280 PCI-e 4.0 x4 NVMe Solid State
    Drive
    PSU
    ASUS ROG THOR 850W 80 Plus Platinum
    Case
    ASUS ROG Strix Helios Midi-Tower ARGB Gaming Case
    Cooling
    ASUS ROG Strix LC Performance RGB AIO CPU Liquid Cooler - 360mm
    Keyboard
    Logi Ergo
    Mouse
    Logitech MX Master 3
    Internet Speed
    900/100 Mbps
    Browser
    Chrome
    Antivirus
    Windows Defender, Malwarebytes Pro
    Other Info
    HP M281 Printer
    Logitech Brio Stream webcam
    Yeti X mic
  • Operating System
    Windows 10
    Computer type
    Laptop
    Manufacturer/Model
    Surface Laptop
    CPU
    i7

jimbo45

Well-known member
Power User
VIP
Thread Starter
Local time
10:17 AM
Posts
1,894
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
I'd use the IP and port, if you are having trouble connecting then use something that is simple to connect to the database like HeidiSQL to make sure the connection details work.

Thanks

These simple things seem to hose me up.

SSH from windows command line to server command line mysql -u -p works so I know the DB and connections are OK.
That HeidiSQL looks good too.

I used that to debug the connection --- all working now - the EXCEL bit is easy !!!

Marking as solved

Skjámynd 2022-04-17 102913.png


Finally job done -- table imported into EXCEL via OBDC from MariaDB on "Remote" NAS

Screenshot 2022-04-17 101913.png


Now Time for Easter Sunday Lunch at favourite bar

Happy Easter everyone.
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
Top Bottom