StrataFrame Forum
Back
Login
Login
Home
»
Enterprise Server - V1
»
Issues
»
Error when calling sproc with varchar OUTPUT parameter
Error when calling sproc with varchar OUTPUT parameter
Post Reply
Like
3
Error when calling sproc with varchar OUTPUT parameter
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Greg McGuffey
Greg McGuffey
posted 18 Years Ago
ANSWER
HOT
Topic Details
Share Topic
Group: Forum Members
Posts: 2K,
Visits: 6.6K
I'm getting an error when I attempt to call a stored procedure that has an output parameter that is a varchar. It reports that the size is invalid with a value of 0. However, the size is clearly set in code and the code runs fine when connected directly.
I've attached a sample solution that highlights this problem. Just read the Readme.txt for details on how to run the tests.
This is a show stopper for my project, which I'm attempting to release for beta testing.
Thanks!
Attachments
TestESCallingSproc.zip
(
294 views,
735.00 KB
)
Reply
Like
3
Replies
Greg McGuffey
Greg McGuffey
posted 18 Years Ago
ANSWER
Post Details
Share Post
Group: Forum Members
Posts: 2K,
Visits: 6.6K
I just updated my client, putting new enterprise dll in the SF folder in Common Files and in the GAC. I double checked that the server was updated. I restarted IIS, just to be sure. I'm still getting same error.
Reply
Like
3
StrataFrame Team
S
StrataFrame Team
posted 18 Years Ago
ANSWER
Post Details
Share Post
S
Group: StrataFrame Developers
Posts: 3K,
Visits: 2.5K
Then it looks like we posted the wrong DLL. Let me get the latest one for you.
Reply
Like
3
StrataFrame Team
S
StrataFrame Team
posted 18 Years Ago
ANSWER
Post Details
Share Post
S
Group: StrataFrame Developers
Posts: 3K,
Visits: 2.5K
OK, try this one on the server.
Attachments
MicroFour StrataFrame Enterprise.zip
(
303 views,
20.00 KB
)
Reply
Like
2
Greg McGuffey
Greg McGuffey
posted 18 Years Ago
ANSWER
Post Details
Share Post
Group: Forum Members
Posts: 2K,
Visits: 6.6K
That did the trick! Thanks Ben!
Reply
Like
2
Greg McGuffey
Greg McGuffey
posted 18 Years Ago
ANSWER
Post Details
Share Post
Group: Forum Members
Posts: 2K,
Visits: 6.6K
Should I update this DLL on my client too?
Reply
Like
2
Trent Taylor
Trent Taylor
posted 18 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
Yes. Put this on your client as well.
Reply
Like
2
Greg McGuffey
Greg McGuffey
posted 18 Years Ago
ANSWER
Post Details
Share Post
Group: Forum Members
Posts: 2K,
Visits: 6.6K
OK, will do. Thanks again!
Reply
Like
2
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Error when calling sproc with varchar OUTPUT parameter
Greg McGuffey
-
18 Years Ago
Hi Greg, A thought: should the last statement be a Select rather than...
Peter Jones
-
18 Years Ago
SQL Server allows you to set the value of a single variable using the...
Greg McGuffey
-
18 Years Ago
Try this to see if it resolves your problem. This will need to replace...
Trent L. Taylor
-
18 Years Ago
No joy. I'm getting the same error :crying:
Greg McGuffey
-
18 Years Ago
Did you replace the assembly within the \bin folder and recycle the...
StrataFrame Team
-
18 Years Ago
I only updated the server, but after reading this post...
Greg McGuffey
-
18 Years Ago
Well, the problem was that the value was being serialized, but after...
StrataFrame Team
-
18 Years Ago
I just updated my client, putting new enterprise dll in the SF folder...
Greg McGuffey
-
18 Years Ago
Then it looks like we posted the wrong DLL. Let me get the latest one...
StrataFrame Team
-
18 Years Ago
OK, try this one on the server.
StrataFrame Team
-
18 Years Ago
That did the trick! Thanks Ben! :D
Greg McGuffey
-
18 Years Ago
Should I update this DLL on my client too?
Greg McGuffey
-
18 Years Ago
Yes. Put this on your client as well.
Trent L. Taylor
-
18 Years Ago
OK, will do. Thanks again!
Greg McGuffey
-
18 Years Ago
Post Reply
Like
3
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search