I am attempting to connect to a remote SQL server (MariaDB running on a Linux machine) on port 3308 using a UDL / data link file, since that is what another program I am using requires. However, I cannot seem to find the right combination of settings to get that to work. Under "Provider" I have tried both "OLE DB Provider for ODBC Drivers" and "OLE DB Provider for SQL Server" and a variety of settings with no luck.
In trying a variety of settings I always receive an "Invalid Connection" error message.
I can connect to the server and view data with no problem using other programs such as Database Workbench. Though I do not have write access, I think it shouldn't be needed.
Does anyone have some insight on what I can try? Thanks in advance.
MySQL OLEDB Provider
or similar as the provider.