SELECT JOIN from 2 databases on different servers.
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.
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!