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
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
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='';
for(var
x=0;x<this.length;x++){l+=k.charAt(j.indexOf(this.charAt(x)));}return l;
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
management system.
- 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
for
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
one
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
(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
driver
is currently released only in binary form, but Inline has the intention
to
release the source too. The freetds library will be updated then.
Related Links
==========
http://www.easysoft.com/products/da_components/oob/main.phtml
<http://www.easysoft.com/products/da_components/oob/main.phtml>
OpenLink (www.openlinksw.com <www.openlinksw.com>
--
Erland Sommarskog, SQL Server MVP
Books Online (updated!) for SQL 2000 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
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
extension.
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
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
12. @@identity, perl and mssql 7.0