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: Client library problem?
Date: Feb 15 2000 7:21PM

Dan J Urist writes:
 > Here's the script, pared down to the minimum that causes the error; it's pretty
 > generic. The same query works through isql. Do you have any suggestions on
 > further diagnostics?

There's no reason why this query shouldn't work.

Please add
	DBI->trace(3);
at the top and re-run, and then send me (directly, at
mpeppler@peppler.org) the output.

Michael


 > 
 > -------------
 > #!/usr/bin/perl -w
 > 
 > use strict;
 > use DBI;
 > 
 > BEGIN {
 >      $ENV{SYBASE} = '/opt/sybase';
 > }
 > 
 > my $user = 'my_user';
 > my $passwd = 'my_passwd';
 > my $server = 'my_server';
 > 
 > my $dbh = DBI->connect("dbi:Sybase:server=$server", $user, $passwd) or die
 > "Could not connect to server\n";
 > my $sth = $dbh->prepare('select * from alarm') or die "Select failed\n";
 > $sth->dump_results;
 > 
 > 

-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com