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