troubleshooting Question

Passing parameter to a sql store procedure

Avatar of bfuchs
bfuchsFlag for United States of America asked on
Microsoft AccessMicrosoft SQL ServerMicrosoft SQL Server 2005
24 Comments1 Solution2474 ViewsLast Modified:
Hi All,

I am trying to convert an access ADP continuous form that should be based on a parametized store procedure rather then just a view, and will be using a control on the form to pass the filter that is being build dynamically (according to users input) as a parameter to the store procedure, instead of using the server filter property of the form.

Now this worked amazingly fast, its just that I came across a major issue as follows,
when the filter string gets longer than approx. 500 characters, it does not get transferred properly to the server, resulting on the app hanging, and on the server side its constantly trying to execute the truncated sql statement...

therefore I am looking for a work around of this limitation..
ASKER CERTIFIED SOLUTION
Bitsqueezer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 24 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 24 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros