使用MS Access& ODBC连接到远程PostgreSQL [英] Using MS Access & ODBC to connect to a remote PostgreSQL

问题描述

我目前有一个通过ODBC连接到PostgreSQL数据库的MS Access应用程序.这可以成功地在具有20个用户的LAN上运行(每个用户都运行自己的Access版本).现在，我正在考虑一些灾难恢复方案，看来保护数据的一种快速简便的方法是使用

I currently have an MS Access application that connects to a PostgreSQL database via ODBC. This successfully runs on a LAN with 20 users (each running their own version of Access). Now I am thinking through some disaster recovery scenarios, and it seems that a quick and easy method of protecting the data is to use log shipping to create a warm-standby.

这使我开始考虑将这个热备用设备放置在远程位置，但是我有一个问题:

This lead me to think about putting this warm-standby at a remote location, but then I have the question:

Access是否可以通过ODBC连接到远程数据库? IE.远程数据库可能在同一国家，并且ping正常，我有一条1兆位的SDSL线路.

Is Access connecting to a remote database via ODBC usable? I.e. the remote database is maybe in the same country with ok ping times and I have a 1mbit SDSL line.

推荐答案

onnodb，

PostgreSQL ODBC驱动程序是积极开发的和一个Access前端在我看来，结合PostgreSQL服务器，在LAN上是快速发展的绝佳选择.我参与了一个相当大的系统(100多个PostgreSQL表，200多个Access表单，1000多个Access查询和报告)，并且它已经运行了很好的几年，有大约20个用户.通常，只要使用视图，以及任何真正需要大量数据的代码，都可以轻松地将其移至PostgreSQL函数中，然后从Access中调用.

The PostgreSQL ODBC driver is actively developed and an Access front-end combined with PostgreSQL server, in my opinion makes a great option on a LAN for rapid development. I have been involved in a reasonably big system (100+ PostgreSQL tables, 200+ Access forms, 1000+ Access queries & reports) and it has run excellently for a few years, with ~20 users. Any queries running slow because Access is doing something stupid can generally just be solved by using views, and any really data-intensive code can easily be moved into PostgreSQL functions and then called from Access.

我们唯一与ODBC相关的主要问题是，无法从Access中终止运行缓慢的查询，因此，我们经常使用户仅终止Access，然后在服务器上执行大量查询.

The only main ODBC-related issue we have is that there is no way to kill a slow running query from Access, so we do often get users just killing Access and then massive queries are just left executing on the server.

这篇关于使用MS Access& ODBC连接到远程PostgreSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！