Up Prev Next
From: Lee Wenzler <Lee dot Wenzler at Roanoke dot com>
Subject: RE: Sybperl to MS SQL Server help
Date: Jul 2 2002 8:45PM
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.
Publishing Systems Manager
The Roanoke Times
>From: Michael Peppler [mailto:firstname.lastname@example.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
>> 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 / email@example.com / http://www.mbay.net/~mpeppler
>firstname.lastname@example.org / ZetaTools, Inc / http://www.zetatools.com
>ZetaTools: Call perl functions as Sybase stored procedures!