ODBC drivers will sometimes call system procedures in order to check on the databases' capabilities, etc. It does look like a driver bug - I'd contact Allaire, assuming you're using the driver provided with CF. -----Original Message----- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Friday, October 13, 2000 3:51 PM To: CF-Talk Subject: Re: ODBC Error: ?!? What in the world ?!? 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/[email protected]/ >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/[email protected]/ 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. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ 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.
