sybperl-l Archive

From: "Ronan O'Ciosoig" <ronanoc at mac dot com>
Subject: trying to get sybperl up and running
Date: Jul 22 2002 2:09PM

It seems I can connect to a Sybase server but not get to the information 
I want. I can execute system commands but not other ones.


When I run the following commands I get the results that follow


		$sql_command = "select * from zones.contact";
		$dbh->dbcmd($sql_command);
		$dbh->dbsqlexec;

		while($dbh->dbsqlresults != NO_MORE_RESULTS) {
		  while(@data = $dbh->dbnextrow) {
		    print "@data";
		  }
		}


 >Server 'TIGER', Line 1
 >        zones.contact not found. Specify owner.objectname or use 
sp_help to check whether the object exists (sp_help may produce lots >of 
output).
 >DB-Library error:
 >        General SQL Server error: Check messages from the SQL Server.
 >Can't locate auto/Sybase/DBlib/dbsqlresult.al in @INC (@INC contains: 
/usr/local/lib/perl5/5.6.1/i686-linux /usr/local/lib/perl5/5.6.1 
 >/usr/local/lib/perl5/site_perl/5.6.1/i686-linux 
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl .) 
at test_sybperl.pl line 56
 >

Although commands like
$sql_command = "sp_helpdb zones";
or
$sql_command = "sp_who";

produce results.

I have done a search for dbsqlresult.al and found nothing.


Anyone have an idea on what this might be?
I am using Linux 7.2 and connecting to an NT server running Sybase.

Thanks. Ronan (Ireland).