相关推荐: 在Mac上用ruby连接sqlserver的最佳方法 Ruby From Other Languages linux下mssqlserver中文内容网页显示问题请教 FreeTDS和tiny_tds的关系 windows使用Tiny_tds连接SQLEXPRESS 数据库 rails通过freetds连接sqlserver Ruby on Rails(Ubuntu64位12.04)连接sql-server2005说明 ruby 常用gem安装错误解决方案
推荐群组: D语言
更多相关推荐
Ruby
1. FreeTDS(TDS协议的一种开源实现方式)


FreeTDS  is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.


Technically speaking, FreeTDS is an open source implementation of the TDS (Tabular Data Stream) protocol used by these databases for their own clients. It supports many different flavors of the protocol and three APIs to access it. Additionally FreeTDS works with other software such as Perl and PHP, providing access from those languages as well.

If you are looking for a Java implementation, we refer you to the  jTDS project  on SourceForge.


注意: 没有说 FreeTDS支持windows, 也没有说可以访问mysql或oracle.
 
 
2. tiny_tds(可以理解为FreeTDS的ruby版本实现, java版本的实现叫jTDS)
 
TinyTDS - A modern, simple and fast FreeTDS library for Ruby using DB-Library.
The TinyTDS gem is meant to serve the extremely common use-case of connecting, querying and iterating over results to Microsoft SQL Server databases from ruby. Even though it uses FreeTDS’s DB-Library, it is NOT meant to serve as direct 1:1 mapping of that C API.
The benefits are speed, automatic casting to ruby primitives, and proper encoding support. It converts all SQL Server datatypes to native ruby objects supporting :utc or :local time zones for time-like types. To date it is the only ruby client library that allows client encoding options, defaulting to UTF-8, while connecting to SQL Server. It also properly encodes all string and binary data. The motivation for TinyTDS is to become the de-facto low level connection mode for the SQL Server adapter for ActiveRecord. For further details see the special thanks section at the bottom
注意: tiny_tds可以用于windows