FreeTDS
Encyclopedia
FreeTDS is a free software
programming library, a re-implementation of the Tabular Data Stream
protocol. It can be used in place of Sybase's db-lib or ct-lib libraries. It also includes an ODBC library. It allows many open source applications such as Perl
and PHP
(or any C
or C++
program) to connect to Sybase ASE
or Microsoft SQL Server
.
FreeTDS is a source code
library, not a program in and of itself. Users generally compile
the library from source and link another program to the library to allow the other program to use the FreeTDS API. It is licensed under terms of the GNU Lesser General Public License
.
For scripting languages, FreeTDS is used in conjunction with a module for that language such as DBD::Sybase in Perl
, Python-Sybase for Python
, or Ruby DBI for Ruby
jTDS is a Java implementation of FreeTDS, available on Sourceforge
. jBCP extends jTDS to include Sybase Bulk Copy Program
(BCP) extensions.
Free software
Free software, software libre or libre software is software that can be used, studied, and modified without restriction, and which can be copied and redistributed in modified or unmodified form either without restriction, or with restrictions that only ensure that further recipients can also do...
programming library, a re-implementation of the Tabular Data Stream
Tabular Data Stream
Tabular Data Stream is an application layer protocol, used to transfer data between a database server and a client. It was initially designed and developed by Sybase Inc...
protocol. It can be used in place of Sybase's db-lib or ct-lib libraries. It also includes an ODBC library. It allows many open source applications such as Perl
Perl
Perl is a high-level, general-purpose, interpreted, dynamic programming language. Perl was originally developed by Larry Wall in 1987 as a general-purpose Unix scripting language to make report processing easier. Since then, it has undergone many changes and revisions and become widely popular...
and PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
(or any C
C (programming language)
C is a general-purpose computer programming language developed between 1969 and 1973 by Dennis Ritchie at the Bell Telephone Laboratories for use with the Unix operating system....
or C++
C++
C++ is a statically typed, free-form, multi-paradigm, compiled, general-purpose programming language. It is regarded as an intermediate-level language, as it comprises a combination of both high-level and low-level language features. It was developed by Bjarne Stroustrup starting in 1979 at Bell...
program) to connect to Sybase ASE
Adaptive Server Enterprise
Adaptive Server Enterprise is Sybase Corporation's flagship enterprise-class relational model database server product. ASE is predominantly used on the Unix platform but is also available for Windows.-History:...
or Microsoft SQL Server
Microsoft SQL Server
Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...
.
FreeTDS is a source code
Source code
In computer science, source code is text written using the format and syntax of the programming language that it is being written in. Such a language is specially designed to facilitate the work of computer programmers, who specify the actions to be performed by a computer mostly by writing source...
library, not a program in and of itself. Users generally compile
Compile
Compile may refer to:* Compile , a Japanese video game company founded in 1983 that specialized in shoot 'em up and computer puzzle game genres...
the library from source and link another program to the library to allow the other program to use the FreeTDS API. It is licensed under terms of the GNU Lesser General Public License
GNU Lesser General Public License
The GNU Lesser General Public License or LGPL is a free software license published by the Free Software Foundation . It was designed as a compromise between the strong-copyleft GNU General Public License or GPL and permissive licenses such as the BSD licenses and the MIT License...
.
For scripting languages, FreeTDS is used in conjunction with a module for that language such as DBD::Sybase in Perl
Perl
Perl is a high-level, general-purpose, interpreted, dynamic programming language. Perl was originally developed by Larry Wall in 1987 as a general-purpose Unix scripting language to make report processing easier. Since then, it has undergone many changes and revisions and become widely popular...
, Python-Sybase for Python
Python (programming language)
Python is a general-purpose, high-level programming language whose design philosophy emphasizes code readability. Python claims to "[combine] remarkable power with very clear syntax", and its standard library is large and comprehensive...
, or Ruby DBI for Ruby
Ruby (programming language)
Ruby is a dynamic, reflective, general-purpose object-oriented programming language that combines syntax inspired by Perl with Smalltalk-like features. Ruby originated in Japan during the mid-1990s and was first developed and designed by Yukihiro "Matz" Matsumoto...
jTDS is a Java implementation of FreeTDS, available on Sourceforge
SourceForge
SourceForge Enterprise Edition is a collaborative revision control and software development management system. It provides a front-end to a range of software development lifecycle services and integrates with a number of free software / open source software applications .While originally itself...
. jBCP extends jTDS to include Sybase Bulk Copy Program
Bulk Copy Program
Bulk Copy Program is a command-line tool used to import or export data against a Microsoft SQL Server or Sybase database.The tool is often more efficient than more recent GUI-based applications, such as DTS, to import and extract data.-Common Uses:...
(BCP) extensions.