C#-使用不同的ODBC驱动程序联接来自两个不同数据库的表 [英] C# - Join tables from two different databases using different ODBC drivers

问题描述

我有一个C#应用程序，需要从两个不同的数据库中提取数据: 数据库1是一个MYOB数据库(使用ODBC通过MYOB的驱动程序进行连接) 数据库2是一个Access数据库，再次使用ODBC连接到它.

I have a C# application which needs to pull data from two different databases: Database 1 is a MYOB database (which uses ODBC to connect using MYOB's driver) Database 2 is an Access database, again I'm using ODBC to connect to it.

例如.这是我要运行的查询:

Eg. this is the query I would like to run:

$query = "SELECT * FROM [" + myobConnectString + "].Accounts, ["+accessConnectString+"].tblTest WHERE tblTest.ID = Accounts.AccountID";

我的问题是我该如何运行它(或者甚至有可能)?

My question is how can I run this (or if it's even possible)?

谢谢！

推荐答案

除了其他答案外，您还可以使用ODBC Join Engine，例如

In addition to the other answers you can use an ODBC Join Engine like the one at ODBC-ODBC Join Engine. However, this will pull the data locally and perform the join for you so it has similar disadvantages as Nickoli outlines at the end of his answer.

这篇关于C#-使用不同的ODBC驱动程序联接来自两个不同数据库的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！