PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Robert Bresner" <rbresner at olf dot com>
Subject: Re: Connect to MS SQL with Sybperl ?
Date: Dec 4 1998 8:44PM

Another good point.

I'm using MS SQL 6.5
Perl 5_004.04
NT4 SP3
Sybase::Sybperl v1.25	06/27/97
Should I only be using Sybase::DBlib ?



Wechsler, Steven M wrote:
> 
> I was under the impression that you could use DB-Library but not CT-Library
> with MS SQL.  We use DB-Library here all the time.  Which are you using?
> 
> Steve
> --
> Steve Wechsler/Senior DB Administrator/Sanford C. Bernstein & Co.
> WechslerSM@bernstein.com
> "Never underestimate the power of human stupidity" - Lazarus Long
> Support the Anti-SPAM amendment: http://www.cauce.org
> 
> > -----Original Message-----
> > From: Robert Bresner [mailto:rbresner@olf.com]
> > Sent: Friday, December 04, 1998 11:34 AM
> > To: SybPerl Discussion List
> > Subject: Re: Connect to MS SQL with Sybperl ?
> >
> >
> > Good point. I'm using 6.5 ....
> > Anyone with a success story that could identify my mistakes ?
> >
> > Michael Peppler wrote:
> > >
> > > Robert Bresner writes:
> > >  > I'm dreaming, aren't I? Can't be done, can it?
> > >  > When I take a simple empty database script which
> > >  > we use daily to clean out a Sybase database, and
> > >  > try using it on a MS SQL database, I get
> > >  >   SYBASE ERROR: ( 20012 ) Unable to determine
> > Net-Library error ( Sev: 2 )
> > >  >   dblogin() failed at EmptyDB.pl line 87,  chunk 5.
> > >  >
> > >  > So I'm wondering, is it possible to fool SybPerl to connect
> > >  > to mssql ?
> > >
> > > Yes, for MS-SQL 6.5 and lower. For MS-SQL 7.0 I have heard
> > that MS has
> > > changed the protocol and that backwards compatibility is not
> > > maintained, so the Sybase libs won't work anymore (although I don't
> > > have any first hand experience of this...)
> > >
> > > Michael
> > > --
> > > Michael Peppler         -||-  Data Migrations Inc.
> > > mpeppler@mbay.net       -||-  http://www.mbay.net/~mpeppler
> > > Int. Sybase User Group  -||-  http://www.isug.com
> > > Sybase on Linux mailing list: ase-linux-list@isug.com
> >
> > --
> > ----------------------------------------
> > Robert Bresner          rbresner@olf.com
> > Open Link Financial    516-227-6600 x216
> > http://www.olf.com/    fax: 516-227-1799
> > ----------------------------------------
> > Opinions expressed are explicitly my own
> > "No more talking!  Cerebus has a SWORD!"
> >

-- 
----------------------------------------
Robert Bresner          rbresner@olf.com
Open Link Financial    516-227-6600 x216
http://www.olf.com/    fax: 516-227-1799
----------------------------------------
Opinions expressed are explicitly my own
"No more talking!  Cerebus has a SWORD!"