This topic is locked

SELECT JOIN from 2 databases on different servers.

11/15/2017 2:35:11 AM
ASPRunnerPro General questions
V
VORONOY author

Is it any way to SELECT JOIN from 2 databases on 2 different server without linking server?
Primary database: MySQL

Second database: MS SQL
When I try to JOIN MSSQL to MySQL in query - getting access denied to MSSQL with MySQL credentials.
Also MSSQL and ASP pages behind firewall, MySQL external.

admin 11/20/2017

No, it is not possible at all.

V
VORONOY author 11/21/2017



No, it is not possible at all.


What about something like this:
SELECT FROM OPENROWSET('SQLNCLI', 'Server=YOUR SERVER;Trusted_Connection=yes;','SELECT FROM Table1') AS a

UNION

SELECT FROM OPENROWSET('SQLNCLI', 'Server=ANOTHER SERVER;Trusted_Connection=yes;','SELECT FROM Table1') AS a ?
Any how if it's not passable, how I can check IF record exist in MSSQL (non primary) database and compare it to MySQL (primary) record in ASPRunner in Before record processed?
Or can I show two tables from 2 databases on one LIST page?
Thank you!