问题描述
在它说，通过使用连接到SQL Azure的不支持OLE DB。
有网络上的其他地方，人们报告说，它工作正常，为他们连接字符串中调整服务器名称后，如here和here. href=\"http://msdn.microsoft.com/en-us/library/ms175608.aspx\"> Analysis Services使用OLE DB即使SQL Server的！
There are other places on the web where folks report that it works fine for them after tweaking the server name in the connection string, such as here and here. Even SQL Server's Analysis Services uses OLE DB to connect to SQL Azure!
我开发德尔福连接通过OLE DB提供程序SQL Server中使用ADO SQL Server的本机/非托管的应用程序。我正在考虑加入SQL Azure支持。这将是非常有益的，如果我可以重用我的大部分code，而不没有太多的变化。我可能不会考虑去，否则这个方向。
I develop a native/unmanaged application in Delphi that connects to SQL Server using ADO through the OLE DB provider for SQL Server. I'm considering adding SQL Azure support. It would be really helpful if I could reuse the majority of my code without not too much change. I probably wouldn't consider going this direction otherwise.
如果微软为什么OLE DB不支持更清楚这将是有益的。如果有使用OLE DB内一定的局限性，它们是什么？也许我可以工作在他们身边，也许它不会影响我。
It would be helpful if Microsoft were more clear on why "OLE DB is not supported". If there are certain limitations within the use of OLE DB, what are they? Maybe I can work around them, or maybe it wouldn't affect me.
微软还提到了ODBC支持。所以我可以用OLE DB提供程序ODBC并连接这种方式？或者是，包括OLE DB的任意组合不支持？
Microsoft also mentions that ODBC is supported. So could I use the "OLE DB provider to ODBC" and connect this way? Or is any combination that includes OLE DB "not supported"?
推荐答案
您可以使用它，但它并没有得到彻底的所有情况进行测试。从本质上讲，它应该适用于大多数的事情，但也有可能是一些边缘情况下，它不会工作。直到我们记录的情况下，它仍然是不支持的。话虽这么说，如果你使用，并遇到错误，我们很想知道这件事，并优先处理加以固定。
You can use it, however it has not been thoroughly tested for all cases. Essentially, it should work for most things, but there might be a few edge cases where it won't work. Until we document those cases, it remains unsupported. That being said, if you were to use and run into errors, we would love to know about it and prioritize that to be fixed.
这篇关于为什么不支持微软对SQL Azure的OLE DB连接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！