To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.
The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Hey Peter,
Awesome plugin. Will the remote connection functionality work with Microsoft Azure SQL Database? We have the option of choosing between Microsoft Azure SQL Database and Microsoft Azure SQL Server. We prefer to use the Azure SQL Database because less administrative overhead and cost of ownership. Our WordPress database is Percona Server (SSO Sigon) and I don’t believe we have a remote MariaDB database connection setup. Is the remote connection functionality still a viable option for us to connect to Microsoft Azure SQL Database/Server?
Best Regards,
Arslan
Hi Arslan,
That is an interesting question! 🙂 I have never tested with Azure, but ODBC and JDBC are supported by MariaDB and Azure, so it should be possible. Is this something we can pickup together?
Best regards,
Peter
Hi Peter,
Awesome plugin you made.
I’m running this website http://www.inksaneartists.com, and I would love to have it read data from a remote microsoft SQL server db.
My wordpress plugin is using MySql and not MariaDB.
So i’m trying to follow your videotutorial, where you make a gateway to a mariadb first.
But here I’m stuck..
Obviously copying the same data that you put in is not working. Since you are using a personal IP.
Should I first go make a mariadb somewhere else (with my current hosting provider?), and then have WP Data Access connect to that?
Or where can I find the IP that does work for my installation? What am I missing?
Thanks already!
Hi Sandy,
To use your SQL Server tables from your WordPress server, your MariaDB database needs to be reachable from your WordPress server and your SQL Server needs to be reachable from your MariaDB server. The MariaDB server acts as a proxy. Your MariaDB and SQL Server databases will usually be on the public network both, and you need to be able to establish a remote connection.
Hope this helps,
Peter
Hello,
Is this possible to connect to remote SQLite database?
Regards,
Jimmy
Hi Jimmy,
You can use JDBC or ODBC to connect to a remote SQLite database (I have not tested this!). You should carefully read this page before you start:
https://wpdataaccess.com/docs/heterogeneous-connections/odbc-jdbc/
Additionally you need to download the necessary drivers and call them in your table definition.
You can follow the steps as described in the video on this page, you just need to change the connection parameters. The correct parameters should be documented with your driver.
Hope this helps,
Peter
Peter, I also am interested in connecting to a Microsoft SQL Server. Isn’t there a way now to connect directly rather than use MariaDB as a proxy?
Hi Robert,
It is possible to connect directly to SQL Server from WP Data Access, but only if you run MariaDB and have full OS admin access. You can find more information here: https://wpdataaccess.com/docs/remote-database-connections/connect-to-sql-server/
It is generally possible to connect to SQL Server, but our API is MariaDB|MySQL based, the reason why we route through MariaDB. Connecting directly would require DBMS specific classes for each supported DBMS. Maybe something for the far future…
Hope this helps,
Peter