I’ve recently started playing around with the connection string in the File: Open dialog box and ultimately, I’d like to interface with a remote postgres server to log/query run information.
Previously I’ve had success connecting to a local xlsx file using command connection strings for querying data and updating information.
(You can even have the file in excel open during the run and watch it update rows in real time)
This got me thinking about if it was possible to connect to a remote SQL server using the same methodology. I still have a lot to learn about windows database connection drivers (ODBC, OLEDB, ACE, etc), but it seems like it should be fairly straight forward:
Install psqlodbc driver (I don’t believe I can use any default windows drivers for this)
Determine connection string that correctly references the new driver with db details
I’m curious if anyone has had success directly interfacing with a remote SQL database using this method and if there were any helpful resources you found along the way.
The following post discusses this specific topic, and contains numerous links to examples and reference material for using VENUS to interface directly with SQL (and other style) databases, as well as a link to guidance on connection strings and database drivers for different database options. Based off of the example content in your post, you are likely knocking on the door already.