Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Ryan Lubke" <rlubke at SYBASE dot COM>
Subject: Re: sp_serverinfo error and MS SQL 7.0
Date: Oct 26 1999 1:12PM


Can you point me to some information on that patch.  I've been digging here
and there, but haven't been able to find it as of yet.

Thanks for any help you can provide.

Ryan Lubke
----- Original Message -----
From: Wechsler, Steven M 
To: SybPerl Discussion List 
Sent: Monday, October 25, 1999 14:53
Subject: sp_serverinfo error and MS SQL 7.0

> OK, we've been successfully connecting to SQL Server 7.0 for several
> now, using DB-Library with Sybperl (we're using the patched MS-SQL Server
> rather than the fixed version of Sybperl).
> However, whenever we connect, we get an error message saying:
> Msg 2812, Level 16, State 62
> Server 'servername',
>         Could not find stored procedure 'sp_serverinfo'.
> It appears that either DB-Library or Sybperl is running this sp_serverinfo
> command.  However, even without a successful run of sp_serverinfo,
> everything elase appears to work fine.
> Sybooks makes two mentions of sp_serverinfo, but only in passing (i.e.
> it is mentioning what stored procedures access a different procedure).  A
> search of Usenet turned up similarly useless information.
> Any idea what causes this error, and if there's a way to suppress it?  I
> know, I could modify the error handler to specifically ignore this message
> on connecting, but sometimes I prefer to use nsql's built-in error
> Thanks,
> Steve
> --
> Steve Wechsler/Senior DB Administrator/Sanford C. Bernstein & Co.
> "Never underestimate the power of human stupidity" - Lazarus Long
> Support the Anti-SPAM amendment: