Ms sql db连接 [英] Ms sql db connection
问题描述
您好。有一个小问题
Hello. have a little question
除了rodbc,我是否有一些连接到MS SQL 2016服务器的方法?如果微软已经做出了像ms r open这样一个很好的解决方案,可能会有一些方便的方式......像sqllite或postgres的dplyr或其他类型的db(conn< -
src_sqllite(" mydb") ;,...)与懒惰的交互类型
Do I have some method of connection to MS SQL 2016 server besides rodbc? If Microsoft have made such a nice solution like ms r open, may be there are some convinient way... something like dplyr for sqllite or postgres or some another types of db (conn <- src_sqllite("mydb",...) with lazy type of interaction
谢谢
推荐答案
Microsoft R Open不提供除RODBC之外的任何SQL Server连接,但是(免费)
Microsoft R Client 和(付费)
Microsoft R Server 提供更直接的ODBC连接。
Microsoft R Open does not provide any connection to SQL Server other than RODBC, but the (free) Microsoft R Client and the (for-pay) Microsoft R Server provide a more direct ODBC connection.
干杯,
Rich Calaway
Rich Calaway
Microsoft R产品团队
Microsoft R Product Team
这篇关于Ms sql db连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!