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: "Wechsler, Steven M" <WechslerSM at bernstein dot com>
Subject: RE: Connect to MS SQL with Sybperl ?
Date: Dec 4 1998 5:58PM

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!"
>