Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
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:


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


-----Original Message-----
From: Lee Wenzler []
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 ./ 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 []
>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 / /
> / ZetaTools, Inc /
>ZetaTools: Call perl functions as Sybase stored procedures!