Oddly, I checked in my Sybase server and "sp_server_info" is a standard system stored
procedure. But "Sp_SeRvEr_InFo" is not.
I am so baffled?! I never called this stored procedure. This bit of SQL has run
thousands of times successfully. What does this mean? Is it some nearly random call
coded inside the Merant ODBC driver written by an NT programmer that doesn't realize
Sybase is case sensitive?
At 03:37 PM 10/13/00 -0400, Peter Theobald wrote:
>I have a small bit of SQL that runs in a loop. It runs successfully several hundred
>times and then I get this bizarre error:
>
>================================================
>ODBC Error Code = 37000 (Syntax error or access violation)
>
>[MERANT][ODBC Sybase driver][SQL Server]Stored procedure 'Sp_SeRvEr_InFo' not found.
>Specify owner.objectname or use sp_help to check whether the object exists (sp_help
>may produce lots of output).
>
>SQL = "delete from QLangLabels where labelname='ADNationalPressYN' and language='de'
>and EventArea='MEWE'"
>================================================
>
>You can see from the SQL that it is a simple statement deleting one record. I never
>call any Stored Procedure. I do not have any Triggers. I never even *heard* of the
>stored procedure "Sp_SeRvEr_InFo".
>
>---------------------------------------------------------------------------
>Peter Theobald, Chief Technology Officer
>LiquidStreaming http://www.liquidstreaming.com
>[EMAIL PROTECTED]
>Phone 1.212.545.1232 x204 Fax 1.212.545.0938
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
