Christof:

See my original post below:

I get the error below from the SQL Server Query Analyzer. I tried that after having problems with VFP.

VFP SQLEXEC() returns a nesting level exceeded error after freezing for a while.

I put the script that creates the procedure at the end of this message.

Thanks

Bill


<<
When I run a stored procedure that takes parameters and updates a table on my machine here, it works fine.

Running the same procedure at the client, I get
connectioncheckfordata
General Network Error
Connection Broken

When I run a script that just updates the same table for the same fields at the client, it runs OK, but when I run the SP with passed parameters, it crashes.

I googled it and saw one answer that said "network problems" but nothing specific.

Any clues?

<<


<
it runs OK, but when I run the SP with passed parameters, it crashes.

What do you mean with "crashes"? Does VFP suddenly disappear, do you get a C5 error, does SQLEXEC() return -1, do you get an error message, is SQL stopping?

Do you get any sort of error message or error code? When execution fails, you can use AERROR() to retrieve error details. Please note that with ODBC errors AERROR can return more than one error at once.

What happens when you run the same stored procedures with parameters in Query Analyzer or SQL Management Studio?
--
Christof
<<

IF OBJECT_ID('dbo.sp_updatemsmast') IS NOT NULL
DROP PROCEDURE dbo.sp_updatemsmast
GO
CREATE PROCEDURE sp_updatemsmast
@id_col INT,
@userid CHAR(4),
@deanum CHAR(10),
@hinum CHAR(15),
@memnum CHAR(15),
@company CHAR(35),
@contact CHAR(20),
@title CHAR(20),
@address1 CHAR(30),
@address2 CHAR(30),
@city CHAR(20),
@addrstate CHAR(10),
@zip CHAR(10),
@phone CHAR(20),
@email text,
@country CHAR(15),
@faxno CHAR(20),
@saleclass CHAR(5),
@memsince datetime,
@parentid INT,
@termdate datetime,
@division CHAR(30),
@msstatus CHAR(1),
@source CHAR(1)
AS
UPDATE msmast
SET deanum = @deanum,
hinum = @hinum,
memnum = @memnum,
company = @company,
contact = @contact,
title = @title,
address1 = @address1,
address2 = @address2,
city = @city,
addrstate = @addrstate,
zip = @zip,
phone = @phone,
email = @email,
country = @country,
faxno = @faxno,
saleclass = @saleclass,
memsince = @memsince,
division = @division,
termdate = @termdate,
parentid = @parentid,
msstatus = @msstatus,
source = @source,
lckstat = '',
lckdate = GETDATE(),
lckuser = @userid
WHERE id_col = @id_col
GO

Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.