为什么Microsoft不支持OLE DB连接到SQL Azure
问题说明
在 MSDN网站，它说：正在连接不支持使用OLE DB的SQL Azure。
网络上还有其他地方的人员报告说，它们在调整后可以正常工作连接字符串中的服务器名称，例如这里和这里。甚至SQL Server的 Analysis Services使用OLE DB连接到SQL Azure ！
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!
我在Delphi中开发了一个本机/非托管应用程序，它通过SQL Server的OLE DB提供程序使用ADO连接到SQL Server。我正在考虑添加SQL Azure支持。如果我可以重复使用我的大部分代码，而没有太多的改变，这将是非常有帮助的。我可能不会考虑去这个方向。
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.
如果Microsoft更清楚为什么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.
Microsoft还提到支持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.
这篇好文章是转载于：学新通技术网
