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