blocks|key|1779278|text|作为SQLXML的一部分，有一个SQL+ISAPI扩展，但我认为它已被弃用：http://msdn.microsoft.com/en-us/library/aa226559%2528v=SQL.80%2529.aspx|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1779279|这实际上是一个预先构建的、相对开放的web服务--所以我不确定这算不上是直接连接。|1779280|你也可以查看http://odbcrouter.com/Main|1779281|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/aa226559%2528v=SQL.80%2529.aspx|1|http://odbcrouter.com/Main^0|12|1V|0|0|0|6|Q|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

There was a SQL ISAPI extension as part of SQLXML, but I think it has been deprecated: <a href="http://msdn.microsoft.com/en-us/library/aa226559%28v=SQL.80%29.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/aa226559%28v=SQL.80%29.aspx</a>

This was effectively a pre-built, and relatively open, web service - so I'm not sure this counts as a direct connection.

You could also check out <a href="http://odbcrouter.com/Main" rel="nofollow">http://odbcrouter.com/Main</a>

blocks|key|1779293|text|web服务确实是唯一的方法，但是Red+Gate编写的方法可以重用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1779294|http://www.mobilefoo.com/iSqlServerSDK.html|offset|length|1779295|http://labs.red-gate.com/Tools/Details/iSqlSDK|1779296|它还没有正式发布，只是测试版，所以请记住，功能和价格可能会改变。|1779297|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|17|0|0|0|1A|1|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|I|5|6|7|10|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|C]]|Q|$5|M|N|O|A|$P|G]]]]

A web service is indeed the only way, but Red Gate's written one you can reuse:

<a href="http://www.mobilefoo.com/iSqlServerSDK.html" rel="nofollow">http://www.mobilefoo.com/iSqlServerSDK.html</a>

<a href="http://labs.red-gate.com/Tools/Details/iSqlSDK" rel="nofollow">http://labs.red-gate.com/Tools/Details/iSqlSDK</a>

It's not officially released yet, just in beta, so keep in mind that features &amp; prices may change.

blocks|key|1992954|text|因此，经过多次的搜索和试验，不幸的是，最好的(唯一？)我发现的方法确实是使用Web服务。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1992955|幸运的是，Linq+to+SQL使WCF创建端变得非常简单。当我让工作中的人指导我设置Windows+web服务器和添加web服务(以及购买访问在线web服务器的权限)时，Windows端就可以使用了。|1992956|我仍然在研究SOAP交互方面的所有语法内容，但保持我的不同方法在结构上有些相似，这使我可以稍微修改一下，直到它生效。到了这个时候，我想我已经让它工作得很好了。|1992957|所以，我得到的两个答案都是(令人失望的)正确的。交互的唯一方式是通过Web服务。即使是他们提到的第三方解决方案，也只是对相同类型的技术进行了方便的包装。事实证明，我更愿意对这个过程进行更好的控制。|1992958|一句忠告:获得一个真正的外部web服务器。我试着在我的iMac/MacBook+Pro上的非服务器Windows虚拟机上这样做，就像拔牙一样！一旦我实际访问了一个外部的、完整的、独立的web服务器，这个过程就变得更加流畅和简单。帮你自己一个忙，把头痛从方程式中去掉吧！|1992959|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

So, after much searching and trial and error, unfortunately the best (only?) way I've found is indeed using Web Services.

Fortunately, Linq to SQL makes the WCF-creation-side incredibly easy. Once I got someone at work to walk me through setting up a Windows web server and adding the web service (and buying access to an online web server), the Windows side was up and ready to go.

I'm still working through all of the syntax stuff on the SOAP interaction side, but keeping my different methods somewhat similar in structure allows me to tinker a little until it works. By this time, I think I've gotten it to work pretty well.

So, both answers I got back were (disappointingly) correct. The only way to interact is through a Web Service. Even the 3rd party solutions they mentioned were really just convenient wrappers around the same type of technology. As it turns out, I'd rather have finer control over the process.

One word of advice: Get a real, external web server. I tried doing this on a non-Server Windows VM on my iMac/MacBook Pro, and it was like pulling teeth! Once I actually got access to an external, full, stand-alone web server, the process was much more streamlined and easy. Do yourself a favor and take that headache out of the equation!

blocks|key|1779341|text|实际上，最简单的方法是创建一个MVC3或4+asp.net+web应用程序。调用web方法。你不需要任何API来支付。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1779342|我使用SBJson来序列化领域对象，然后将这些对象作为序列化的jSOn发送到MVC3。我甚至用base64发送图像，所以它与.net兼容。|1779343|请参阅我的博客文章，其中包含示例代码：http://nickturner.wordpress.com/2012/10/09/107/|offset|length|1779344|entityMap|0|LINK|mutability|MUTABLE|url|http://nickturner.wordpress.com/2012/10/09/107/^0|0|0|J|1B|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Actually the easiest way is to create a MVC 3 or 4 asp.net web application. call the web methods. You don't need any API to pay for.

I use SBJson to serialize domain object and then send the objects as serialized jSOn to MVC 3. It's super easy to do. I even send images with base64, so it's .net compatible.

See my blog post with sample code: 
<a href="http://nickturner.wordpress.com/2012/10/09/107/" rel="nofollow">http://nickturner.wordpress.com/2012/10/09/107/</a>

I am working on an in-house, iOS app that will need read-only access to a SQL Server with multiple databases. I know the stock answer here is "write some web services", but I'd like a solution that is self-contained. Is there any way to directly connect to a SQL Server database from an iOS application? I'm thinking something like a basic ODBC connection.

I've seen a lot of users asking this question, but very few answers other than "write a web service." Is that really the only way?

Query SQL Server Database from native iOS Application

SQL Server

数据库

服务器

虚拟机

Windows

我正在开发一个内部的iOS应用程序，它需要对具有多个数据库的SQL Server进行只读访问。我知道这里的常见答案是“编写一些web服务”，但我想要一个自包含的解决方案。有没有办法从iOS应用程序直接连接到SQL Server数据库？我在考虑一种基本的ODBC连接。我见过很多用户问这个问题，但除了“编写web服务”之外...

问从本地iOS应用程序查询SQL Server数据库
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从本地iOS应用程序查询SQL Server数据库EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从本地iOS应用程序查询SQL Server数据库
EN