Forums: SELECT JOIN from 2 databases on different servers. - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

SELECT JOIN from 2 databases on different servers. Rate Topic: -----

#1 User is offline   VORONOY 

  • Member
  • PipPip
  • Group: Members
  • Posts: 19
  • Joined: 14-February 07

Posted 15 November 2017 - 07:35 AM

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.
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15497
  • Joined: 03-February 03

Posted 20 November 2017 - 10:12 PM

No, it is not possible at all.
Best regards,
Sergey Kornilov
0

#3 User is offline   VORONOY 

  • Member
  • PipPip
  • Group: Members
  • Posts: 19
  • Joined: 14-February 07

Posted 21 November 2017 - 09:33 PM

View Postadmin, on 20 November 2017 - 05:12 PM, said:

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!
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic