Creating record sets

I want to create a recordset drawing data from another domain (the domain resides on the same remote server). I believe I have my Primary Connection and Additional Connections defined correctly.

How do I create that recordset using Dynamic Connections? It does not let me select the alternate tables. Do I create a separate Primary Connection for each domain I may wish to access data from?

dynamic connections will not work in this way.


dynamic connections relies on the URL in the address bar to determine which connection details to use


you need to use a static connection to connect to the other server, not a dynamic connection.


This may or not be possible depending on the MySQL Server.

These domains are on the same (remote) server. Just different domains.

The pre-sales demo sure seemed to indicate that type of function. "Access datasets across different domains"

Perhaps that functionality can be added to future versions, because without it, I don't see much value to the plug-in.

you dont need a dynamic connection for this.

you need a static connection that uses the information for connecting to the other MySQL server.

The use for dynamic connections is to create one connection file that will use different database connection details based on the domain in the address bar.

A perfect example is using localhost for testing, then uploading to the remote server. Dynamic connections allows you to specify the local connection details and the remote connection details and will use the correct one automatically.

another use would be for multi-lingual sites.

you could have an english copy of the database and a french copy of the database. and using the same connection, change which will be used by using subdomains:
mydomain.en.com would connect to the English DB
mydomain.fr.com would connect to the French version.