Is there a decent Perl module to allow a Linux
machine to talk to a remote MS SQL 7.0 server?
I am looking for any recommendations. Thanks.
me for Atrax's signature
var a='nopqrstuvwxyz';var b='abcdefghijklm';var j='/:.'+a+b;var
2002.Quote:} alert("uggc://jjj.ernqgurshpxvatznahny.pb.hx/".r()); // Atrax, MVP
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
I also include some text from Reinard Kibel, a support engineer at
Microsoft, who posted the below some time ago.
To connect from Red Hat Linux to SQL on Win 2K, you will need to get an
ODBC driver or a TDS driver from a third party vendor.
It is possible to use a library that implements the TDS (Tabular Data
Stream) protocol, which is the application-level protocol used by Sybase
databases and by MS SQL. It is also possible to establish a way of
communication by using ODBC (Open Database Connectivity). This is a
database independent communication API which allows applications to
communicate, via standard-based function calls to a back end database
- iODBC (www.iodbc.org <www.iodbc.org> ) is an opensource odbc driver
manager and SDK mantained by Openlink Software (www.openlinksw.com
<www.openlinksw.com> ) which also has a similar odbc driver manager
distributed only in binary form.
- unixODBC (www.unixodbc.org <www.unixodbc.org> ) The unixODBC Project
goals are to develop and promote unixODBC to be the definitive standard
ODBC on the Linux platform. It is an opensource project. This project is
supported by Easysoft (www.easysoft.com <www.easysoft.com> )
Each of these driver managers are supported under php. You must choose
odbc driver manager and build php linking against its libraries:
To link against iodbc: --with-iodbc=
Easysoft ODBC-ODBC Bridge 2000
This is another commercial bridged solution. The features are somewhat
similar to that of Openlink. It is suggested to use this driver with
unixODBC as driver manager.
Inline TDS ODBC driver
Inline TDS ODBC driver is developed by Inline Internet Systems
(www.inline.net <www.inline.net> ) and can be downloaded from
http://library.freeodbc.org <http://library.freeodbc.org> download page.
This odbc driver is different from the others because it communicates
directly with the dbms engine, and is not a bridge of any sort.
This is a faster and lighter solution compared to the other two. The
is currently released only in binary form, but Inline has the intention
release the source too. The freetds library will be updated then.
OpenLink (www.openlinksw.com <www.openlinksw.com>
Erland Sommarskog, SQL Server MVP
Books Online (updated!) for SQL 2000 at
It's been my impression that since the dissolution of the
Sybase-Microsoft RDBMS partnership, Microsoft has not provided UNIX
client access. Of the companies who do provide some type of UNIX client
access, I cannot say whether any are more reliable or, for that matter,
sanctioned by Microsoft. Further, I'm not certain which provide a Perl
interface, versus which would require you to write your own Perl
I wish I could be of help, but I think you're pretty stuck.