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: 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:
> 
> 	$ENV{TDSVER}=42;
> 	$ENV{SYBASE}="/usr/local/freetds";
> 	
> $ENV{LD_LIBRARY_PATH}="/usr/local/freetds/lib:$ENV{LD_LIBRARY_PATH}";

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.

Michael


> -----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:mpeppler@peppler.org]
> >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
> to
> >> 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,
> but
> >> 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
> getting
> >> deeper and deeper into this hole. Am I making this more complicated
> than
> >> 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
> >--
> >Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
> >mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
> >ZetaTools: Call perl functions as Sybase stored procedures!
> 
-- 
Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!