Problem with DBD-Sybase 1.04 ...

From: Edward Smorodinsky (Edward.Smorodinsky_at_soros.com)
Date: 11/11/04


To: "'dbi-users@perl.org'" <dbi-users@perl.org>
Date: Thu, 11 Nov 2004 09:07:12 -0500

I have a problem running my perl application with the new DBD-Sybase 1.04 om
Windows NT Server. But application is running OK on Windows 2000, Windows
2003 Server and Windows XP.

I prepared simple test program:
#! /usr/local/bin/perl
#
# dbi-test.pl
#
use strict;
use DBI;

my ($dbh, $user, $pwd, $sth);
my $ServerName, $DatabaseName, $DSN);
my $rc;
my $data;

$ServerName = "AFSPS";
$DatabaseName = "afs_equity";
$user = "uuu";
$pwd = "pwd";
$DSN =
"DBI:Sybase(RaiseError=>1,PrintError=>0,AutoCommit=>1):database=$DatabaseNam
e;server=$ServerName";

$dbh = DBI->connect($DSN, $user, $pwd) || die $DBI::errstr;

$sth = $dbh->prepare("select * from accttype");

$sth->execute;
while ($data = $sth->fetch)
    {
    print STDOUT "@$data\n";
    }

$sth->finish;

#
# Disconnect
#
$rc = $dbh->disconnect;

On Windows NT Server I have the following:

        DBI connect('database=afs_equity;server=AFSPS','uuu',...) failed:
OpenClient
        message: LAYER = (5) ORIGIN = (3) SEVERITY = (5) NUMBER = (4)
        Server AFSPS, database
        Message String: ct_connect(): network packet layer: internal net
library error:
        Net-Lib protocol driver call to connect two endpoints failed
         at dbi-test.pl line 29

But as I mentioned before it works perfect with othe system. On all system I
am using the latest OpenClient Software which is a network-based in our
environment.
Also I am using perl 5.8.4 (ActiveState build 804, DBI 1.45, DBD-Sybase
1.04.

BTW, my application worked fine on Windows NT Server with DBI 1.14,
DBD-Sybase 0.94

  Edward Smorodinsky
   Senior System Administrator
   Soros Fund Management LLC
   888 Seventh Avenue
   New York, New York 10106
   eds@soros.com



Relevant Pages

  • SecurityFocus Microsoft Newsletter #154
    ... MICROSOFT VULNERABILITY SUMMARY ... ISS RealSecure Server Sensor SSL Denial Of Service Vulnerabi... ... Roger Wilco Remote Server Side Buffer Overrun Vulnerability ... available for Microsoft Windows operating systems. ...
    (Focus-Microsoft)
  • SecurityFocus Microsoft Newsletter #49
    ... Subject: SecurityFocus Microsoft Newsletter #49 ... Microsoft Windows NNTP Denial of Service Vulnerability ... Microsoft IIS SSI Buffer Overrun Privelege Elevation Vulnerability ... Microsoft ISA Server H.323 Memory Leak Denial of Service... ...
    (Focus-Microsoft)
  • ~~~~~~~~~~~~~~~ CANNOT FIND ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    ... cannot find server or dns error ... windows cannot find null ... windows cannot find the network path ... cannot find internet explorer on computer ...
    (comp.protocols.snmp)
  • Questions Relating to Administering Windows 2000 Server
    ... installed the network client on the target computer. ... Sarah has been attempting to install Windows 2000 ... Server for two days. ... Sarah has checked the cables and hard drives. ...
    (microsoft.public.cert.exam.mcse)
  • pqv¼Ò¹ÚÇÑ ²Þ@mBGRx
    ... O-009¹Ù¢Ã MS Windows 2000 Datacenter Server -2¸¸¿ø ... Main Application (Borland C++ Builder 6 Enterprise Edition) ... Y-166¢Ã Sex Starved Sluts 1 (Divx) ...
    (FreeBSD-Security)