Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Tim Holt <holt at roguewave dot com>
Subject: RE: Microsfot SQL 7 and Sybperl
Date: Mar 9 1998 5:25PM

This happens to be a pretty important issue for me.  We are currently
"tunneling" in from our external web server to our MS-SQL (6) server
(inside our firewall) to access customer data.  We are doing this by
first, setting up a fake server entry in our Sybase server's interface
file, and then second, doing encrypted port tunneling to get that port
connected to our MS-SQL server's port.  I hope that makes sense.  Then,
we use Sybperl in all of our CGI scripting.  We can use it for
connecting to true local databases on our Sybase server (on our external
web machine), and also to the internal MS-SQL server.  If MS-SQL 7 &
Sybase won't "talk", then our fine little hack won't work anymore.

I hate to think about moving away from using the Sybperl package.  It's
never ever let us down.  But, does anyone have a suggested path to use
one API for Sybase and MS-SQL, where they "talk" differently?  Are we
talking DBD/DBI here?

Tim Holt, Web Software Guy
Rogue Wave Software

-----Original Message-----
From: Michael Peppler []
Sent: Monday, March 09, 1998 7:23 AM
Subject: Re: Microsfot SQL 7 and Sybperl

Henrik Edlund wrote:
> There are rumors that the next version of MS-SQL (version 7) will have
> changed protocol. It will no longer work with the Sybase protocol.
> Anyone know if this is true and if it's true, will Sybperl support it
> will Sybperl stay Sybase-only?

Sybperl links against the Sybase libraries, so by definition it
will only support the Sybase protocol, and any common backwards
compatible subset of the MS version of TDS.

Changing the protocol in MS-SQL 7.x would be a typical MS thing
to do - you'd need to use the MS tools & libs to use the thing.

I don't remember if the agreement between Sybase and MS states
that the servers *must* understand a common subset of the protocol
(currently the subset is the version of TDS that was used with
MS/Sybase 4.2).

Michael Peppler         -||-  Data Migrations Inc.    -||-
Int. Sybase User Group  -||-