[SOLVED] Â PHP-Runner 9.8 Ent. multiple DB connections |
2/15/2019 4:29:17 AM |
PHPRunner General questions | |
C
ckranich authorDevClub member
Hello All, |
|
![]() |
admin 2/16/2019 |
I'm afraid you doing it wrong. There is no such thing as Connection.db.Tablename. Connection is another level of abstraction, it is not something that you can use in your SQL Query. |
C
|
ckranich authorDevClub member 2/17/2019 |
I'm afraid you doing it wrong. There is no such thing as Connection.db.Tablename. Connection is another level of abstraction, it is not something that you can use in your SQL Query. If you have three databases on the same SQL Server you just need a single database connection. In your SQL queries you just use database.schema.tablename to access any table in any database. Of course you need to make sure that database user has access to all three databases. You need to test all your queries outside of PHPRunner first and once they work you can use them in PHPRunner as well. And, of course, in MySQL query you cannot access SQL Server table and vice versa. That goes without saying.
|
![]() |
admin 2/17/2019 |
I see what you saying. It is simply impossible to query two different databases in a single SQL query. |