README.rdoc in tiny_tds-0.4.3 vs README.rdoc in tiny_tds-0.4.4

- old
+ new

@@ -12,12 +12,13 @@ * TinyTds::Error - A wrapper for all exceptions. == New & Noteworthy -* Works with FreeTDS 0.83.dev +* Works with FreeTDS 0.91 * Tested on Windows using MiniPortile & RailsInstaller. +* New :host/:port connection options. Removes need for freetds.conf file. == Install Installing with rubygems should just work. TinyTDS is tested on ruby version 1.8.6, 1.8.7, 1.9.1, 1.9.2 as well as REE & JRuby. @@ -28,11 +29,11 @@ == FreeTDS Compatibility -TinyTDS is developed for FreeTDS 0.82 & 0.83.dev. It is tested with SQL Server 2000, 2005, 2008 and Azure using TDS Version 8.0. We utilize FreeTDS's db-lib client library. We compile against sybdb.h, undefine MSDBLIB and define SYBDBLIB which means that internally we conform to sybase API to db-lib. TinyTDS will work for both Sybase & Miscrosoft SQL Server. You do NOT need to compile FreeTDS with the "--enable-msdblib" option for our client to work properly. However, please make sure to compile FreeTDS with libiconv support for encodings to work at their best. Run "tsql -C" in your console and check for "iconv library: yes". +TinyTDS is developed for FreeTDS 0.82 & 0.91. It is tested with SQL Server 2000, 2005, 2008 and Azure using TDS Version 8.0. We utilize FreeTDS's db-lib client library. We compile against sybdb.h, undefine MSDBLIB and define SYBDBLIB which means that internally we conform to sybase API to db-lib. TinyTDS will work for both Sybase & Miscrosoft SQL Server. You do NOT need to compile FreeTDS with the "--enable-msdblib" option for our client to work properly. However, please make sure to compile FreeTDS with libiconv support for encodings to work at their best. Run "tsql -C" in your console and check for "iconv library: yes". == Data Types @@ -49,17 +50,19 @@ == TinyTds::Client Usage Connect to a database. - client = TinyTds::Client.new(:username => 'sa', :password => 'secret', :dataserver => 'mytds_box') + client = TinyTds::Client.new(:username => 'sa', :password => 'secret', :host => 'mydb.host.net') Creating a new client takes a hash of options. For valid iconv encoding options, see the output of "iconv -l". Only a few have been tested and highly recommended to leave blank for the UTF-8 default. * :username - The database server user. * :password - The user password. * :dataserver - The name for your server as defined in freetds.conf. +* :host - Used if :dataserver blank. Removes need for freetds.conf file. +* :port - Defaults to 1433. Only used if :host is used. * :database - The default database to use. * :appname - Short string seen in SQL Servers process/activity window. * :tds_version - TDS version. Defaults to 80, not recommended to change. * :login_timeout - Seconds to wait for login. Default to 60 seconds. * :timeout - Seconds to wait for a response to a SQL command. Default 5 seconds. @@ -220,26 +223,28 @@ == Using TinyTDS With Rails & The ActiveRecord SQL Server adapter. -As of version 2.3.11 & 3.0.3 of the adapter, you can specify a :dblib mode in database.yml and use TinyTDS as the low level connection mode. Make sure to add a :dataserver option to that matches the name in your freetds.conf file. The SQL Server adapter can be found using the link below. Also included is a direct link to the wiki article covering common questions when using TinyTDS as the low level connection mode for the adapter. +As of version 2.3.11 & 3.0.3 of the adapter, you can specify a :dblib mode in database.yml and use TinyTDS as the low level connection mode. The SQL Server adapter can be found using the link below. Also included is a direct link to the wiki article covering common questions when using TinyTDS as the low level connection mode for the adapter. http://github.com/rails-sqlserver/activerecord-sqlserver-adapter/wiki/Using-TinyTds == Using TinyTDS with Azure -TinyTDS is fully tested with the Azure platform. You must set the :azure => true connection option when connecting. This is needed to specify the default in the login packet since Azure has no notion of "USE [database]". You must use the latest FreeTDS 0.83.dev and it must be compiled with OpenSSL. +TinyTDS is fully tested with the Azure platform. You must set the :azure => true connection option when connecting. This is needed to specify the default database name in the login packet since Azure has no notion of "USE [database]". You must use the latest FreeTDS 0.91. FreeTDS must be compiled with OpenSSL too. == Development & Testing We use bundler for development. Simply run "bundle install" then "rake" to build the gem and run the unit tests. The tests assume you have created a database named "tinytdstest" accessible by a database owner named "tinytds". Before running the test rake task, you may need to define a pair of environment variables that help the client connect to your specific FreeTDS database server name and which schema (2000, 2005, 2008 or azure) to use. For example: $ rake TINYTDS_UNIT_DATASERVER=mydbserver TINYTDS_SCHEMA=sqlserver_2008 + or + $ rake TINYTDS_UNIT_HOST=mydb.host.net TINYTDS_SCHEMA=sqlserver_azure If you are compiling locally using MiniPortile (the default dev setup) and you do not have a user based freetds.conf file with your dataservers, you may have to configure the locally compiled freetds.conf file. You can find it at the ports/<platform>/freetds/<version>/etc/freetds.conf path locally to your repo. In this situation you may have to set the FREETDS environment variable too this full path. For help and support.