Solved Help wanted with ODBC create new data source please

jimbo45 · Apr 17, 2022

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

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.

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.

Cheers
jimbo

z3r010 · Apr 17, 2022

jimbo45 said:
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.

jimbo45 · Apr 17, 2022

z3r010 said:
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