Perl -> MSSQL

Perl -> MSSQL

Post by Scott Mosema » Fri, 05 Jul 2002 06:07:53

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.

Scott Moseman


Perl -> MSSQL

Post by Atrax » Fri, 05 Jul 2002 09:53:25

I'm reasonably sure I saw an article on this at recently...

function String.prototype.r(){// Javascript rot13 en/decipherment. run
me for Atrax's signature
        var a='nopqrstuvwxyz';var b='abcdefghijklm';var j='/:.'+a+b;var
k='/:.'+b+a;var l='';
x=0;x<this.length;x++){l+=k.charAt(j.indexOf(this.charAt(x)));}return l;

Quote:}       alert("uggc://jjj.ernqgurshpxvatznahny.pb.hx/".r()); // Atrax, MVP


*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!


Perl -> MSSQL

Post by Erland Sommarsko » Fri, 05 Jul 2002 18:56:32

[posted and mailed, please reply in news]

> Is there a decent Perl module to allow a Linux
> machine to talk to a remote MS SQL 7.0 server?

I have some confused scribblings on the topic on

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
   management system.

   - iODBC ( <> ) is an opensource odbc driver
   manager and SDK mantained by Openlink Software (
   <> ) which also has a similar odbc driver manager
   distributed only in binary form.
   - unixODBC ( <> ) 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 ( <> )
   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=  
   openlink:       --with-openlink=        
   unixodbc:       --with-unixodbc=        

   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
   ( <> ) and can be downloaded from <>  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.

   Related Links
   OpenLink ( <>

Erland Sommarskog, SQL Server MVP

Books Online (updated!) for SQL 2000 at


1. Unix/Perl-->NT/MSSQL

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.
Scott Nichol

2. win2k advanced server + sql server standard edition

3. HELP>>HELP>>Using an Index for an MSSQL database

4. ADO Connections

5. MSSQL - DB Limitations >>>

6. Is there an SQL statement that will do this?

7. cgi-->SQL/PERL-->SQL*PLUS processing..

8. Connecting to MSSQL from UNIX (perl, C)?

9. Using MSSQL::Sqllib in Perl

10. Problem with fetching data from mssql through perl/odbc

11. perl and mssql server 6.0

12. @@identity, perl and mssql 7.0