sybperl-l Archive

From: Matthew dot Persico at Lazard dot com
Subject: Re: trying to get sybperl up and running
Date: Jul 22 2002 1:22PM

Table designation syntax in a query is

     database.owner.table

If 'zones' is your database, you need another dot, as in

          zones..contact

If 'zones' is your user, check the grants on the table.

You'll find it to your advantage to run any sql which is misbehaving in ISQL
before posting. You'll be able to diagnose your problems faster.

HTH
--
Matthew Persico
Vice President
Lazard
30 Rockefeller Plaza
New York, NY 10020, USA
Phone Number: 212 632 8255
Fax Number: 212 332 5904
Email: matthew.persico@lazard.com


                                                                                                                  
                                                                                                                  
                                               To:     "SybPerl Discussion List"         
             "Ronan O'Ciosoig"                 cc:                                                                
                              Subject:     trying to get sybperl up and running                  
             Sent by:                                                                                             
             owner-SYBPERL-L@list.cren.                                                                           
             net                                                                                                  
                                                                                                                  
             22 Jul 2002 10:09 AM                                                                                 
             Please respond to                                                                                    
             SYBPERL-L                                                                                            
                                                                                                                  
                                                                                                                  



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).



L