stored procedure help

[oakpark5]

OK, got a problem. i'm calling a stored procedure from an ASP page, i call the procedure more than once. The first time it works perfectly, the second time it come back with an error saying it cannot find it. It is in the right place and all the code is correct, any reason for this occurence?

Software Engineer
Team Lead
damn bill gates, he has everything

 

[mrdenny]

There is nothing that the SQL Server would be doing that would make it say that. Check for typos in the name of the procedure, or the database that you are connecting to.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[oakpark5]

OK fixed that, thank you, next problem, this is a good one....

I set up a linked server between foxpro tables and a sql server db. I ran a couple tests and i used an update through a stored procedure and it works fine. I then moved it over to the live data and when it runs it gives an error saying the sql statement is too long? The test table was identical to the live table. Could it be something with permissions? The sql server and the fox pro tables are on the same server. Thanks in advance!

Software Engineer
Team Lead
damn bill gates, he has everything

 

[mrdenny]

humm...

i'm not sure about that one. I'm not farmiler with foxpro at all. I don't think it's a permissions issue. Does foxpro have a max lengh of the statement? Are you running the same version of foxpro on the test and live servers?

Denny

--Anything is possible. All it takes is a little research. (Me)