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: "Henson, David A" <david dot a dot henson at citigroup dot com>
Subject: RE: Sybperl to MS SQL Server help
Date: Jul 3 2002 1:06PM

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}";

Which seems to work with any ASE or MSSQL version, as 4.2 is the common
denominator.

D


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