|
4/4 |
1999/11/20-22 [Computer/SW/Database] UID:16926 Activity:nil |
11/19 Anyone know of an easy way to use perl to query an SQL server? (If so, then the follow up question is how.) -emarkp \_ Use the DBI module. \_ Use the DBD modules. \_ If this is an M$ SQL 7.0 server, you can try the FreeTDS stuff which is at http://freetds.org or .com or .net or something. |
4/4 |
|
freetds.org Contribute 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 DataStream) protocol used by these databases for their own clients. It supports many different flavors of the protocol and supports several APIs to access it. Additionally FreeTDS works with other software such as Perl and PHP, providing access from those languages as well. There is also a native (type 4) JDBC driver available for platform-independent Java clients (including Java Server Pages applications), with support for most of the JDBC 1 API and portions of the JDBC 2 API. It has been used by Unix/Linux webservers to present data stored in SQL Server to the web, for porting SQL Server database code from NT to Unix, to import data into SQL Server from a Unix source, and to provide database access on those platforms such as realtime systems that have no native drivers. |