Subject Remote access to a dBase database living on a private server from cloud From Franck <francisvachon.it@gmail.com> Date Tue, 08 Dec 2020 10:47:55 -0500 Newsgroups dbase.getting-started Hi there, I need to work with a dBase database that lives on a private server, from the cloud (Amazone web services). I personally know nothing really about dBase, but I need to connect an app that lives on the cloud to that dBase instance. From what I have seen, dBase as it is currently used works with a graphical interface and this is how they currently access/modify the database's data. However, my application would have to be able to query dBase without going through the UI. The ability (or not) to access that data pretty much determines if we do the project at all, or if we need to migrate everything off dBase into Postgres/MySQL or similar. At the moments, here are my thoughts as to what the options are. As I have little knowledge of dBase, if anyone has done something similar I'd like to get your thoughts: 1 - Use a connector to connect dBase to the broader SQL database the app will use. It seems that there is an ODBC driver (https://media.datadirect.com/download/docs/odbc/allodbc/help.html#page/odbc%2Fthe-dbase-driver.html%23) to do something along those lines. 2 - I've also found this (http://dbase.com/help/8_0/ADO/Setting_up_UDL_Source_dBASEPLUS8ADO_v3.htm). However this is for connection on the same host computer, not a remote connection. It's not clear to me that I could actually setup that same connection remotely. So.... anyone has some idea of whether or not I'm about to dive into an bottomless rabit hole trying to do that? Is rebuilding the dBase part into the wider application a better idea than trying to salvage it with tricky connections?