Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: Sybperl to MS SQL Server help
Date: Jul 3 2002 2:42PM
On Wed, 2002-07-03 at 06:06, Henson, David A wrote:
> Are you setting the TDS version, I have a script which sets the following:
Just a reminder - setting LD_LIBRARY_PATH has NO effect on the current
(running) process - only on children of the process where
LD_LIBRARY_PATH is set.
> -----Original Message-----
> From: Lee Wenzler [mailto:Lee.Wenzler@Roanoke.com]
> Sent: 02 July 2002 21:46
> To: SybPerl Discussion List
> Subject: RE: Sybperl to MS SQL Server help
> I built the DBD::Sybase and tried it. I can connect ok with a sybase
> server, but when I put in the server name of the MS SQL server (with the
> interface file set to TLI TCP transport for the JOBS server name.
> $dbh = DBI->connect("dbi:Sybase:server=JOBS", $user, $password);
> I get this error:
> DBI->connect(server=JOBS) failed: OpenClient message: LAYER = (5) ORIGIN
> = (3) SEVERITY = (5) NUMBER = (6)
> Message String: ct_connect(): network packet layer: internal net library
> error: Net-Library operation terminated due to disconnect
> at ./jobs.pl line 761
> I'm not sure how the FreeTDS gets pulled into all this.
> Lee Wenzler
> Publishing Systems Manager
> The Roanoke Times
> >-----Original Message-----
> >From: Michael Peppler [mailto:email@example.com]
> >Sent: Tuesday, July 02, 2002 4:02 PM
> >To: SybPerl Discussion List
> >Subject: Re: Sybperl to MS SQL Server help
> >On Tue, 2002-07-02 at 12:53, Lee Wenzler wrote:
> >> Dang, this is way too hard. This all started when I tried to connect
> >> a MS SQL server using Sybperl. I can get the FreeTDS stuff to work as
> >> far as the make check passing the login & logout, & change db tests,
> >> I'm lost after that. After not getting that to work, I tried to get
> >> unixODBC drivers to work. I've gone thru all the FAQs and keep
> >> deeper and deeper into this hole. Am I making this more complicated
> >> it needs to be (please say yes)??
> >I think so - though I'm no specialist on this.
> >I suggest that you forget about ODBC. Instead try building DBD::Sybase,
> >and use that with FreeTDS. I believe that this works reasonably well.
> >Michael Peppler / firstname.lastname@example.org / http://www.mbay.net/~mpeppler
> >email@example.com / ZetaTools, Inc / http://www.zetatools.com
> >ZetaTools: Call perl functions as Sybase stored procedures!
Michael Peppler / firstname.lastname@example.org / http://www.mbay.net/~mpeppler
email@example.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!