Distributed databases

Accessing non-local databases with OPC Router does not pose any particular difficulties. In fact, it is more the rights management of the database server that can present a few stumbling blocks. Therefore, please consult the documentation for your database system.

We generally recommend that you consider the following:

• Does the database allow remote access? Does this need to be explicitly granted to individual users?
• Does the login method need to be specified (Windows/NT authentication or username/password)?
• Does the user need to be explicitly granted access to a specific database or table?
• Do you need to explicitly assign the required functions to the user?
• Is the database server’s port allowed through the firewalls on both computers? Allow this specific port instead of disabling the firewall; the ports used by the OPC Router itself are listed under “Network Ports.”
• Depending on the database system, the Server/File property of the DB connection contains different information (see “Storage”).