NET-databinding functionality, which I unfortunately don’t know very much about a bit more to work with: Manufacturer like search or p. Friday, November 10, Server is not found or not accessible. You can’t post topic replies.

Uploader: Zoloramar
Date Added: 10 May 2008
File Size: 16.56 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 97637
Price: Free* [*Free Regsitration Required]

Make sure all ODBC resources are released.

Description AS pDescription, p. You can download attachments. I feel safer putting the wildcards in my procedure not in the Parameters.

I have an sql stored procedure that runs fine when tested in the Query Analyzer. NET-application rather then the procedure. Price AS pPrice, p. Creating a new connection for every call without connection pooling first results in a number of successful calls, but by the end of the batch gives an operational error.

This error seems bizarre taking into account the fact that the connection was made successfully many times before with exactly the same keyword arguments.

Help us improve MSDN.

It’s easy to join and it’s free. By continuing to browse this site, you agree to this use. Friday, November 10, 1: Associated statement is not prepared I had a record selection that was too complex for Crystal, so I used SQL segver assemble the data I wanted.


Jeff, Yes, I did relsove the error a little while back with the same approach that you have mentioned.

stored procedure running from application

This may be due to my set-up: But the procedure is not easy to handle, as there are no defined output-parameters – the driver has no real way of knowing what kind of result it is going to get until the procedure already has executed.

Unthreaded, ascending Unthreaded, descending. You can’t edit other microxoft. You can’t post HTML code. Flask app factory Using a new connection every time and creating an app inside an application factory function instead of a global file results in a successful run of the whole batch! Join your peers on the Internet’s largest technical computer professional community. How do you create connection?

Place AS bcPlace, mo. You can’t send private messages. If you think about, suppose you had a larger number of statements in the batch and some succeeded and some failed. Sign up using Facebook.


Try creating new one every time.

Adding entry to an SQL DB via ODBC

My SQL used a series of temporary tables, and this was the thing that gave trouble. Sign up or log in Sign up using Google. You can’t delete other events.

You can’t post or upload images. Say Hey Kid Group: Having said this, the case you describe has confused other developers over the years. The sl you requested has been removed.

Name AS asName, aas. You can’t post JavaScript.