Solved

SQL-Server Stored Procedure

Posted on 1998-07-03
3
165 Views
Last Modified: 2011-08-18
I call a stored procedure in MS SQL-SERVER.
Everything worked fine. I Installed SQL-Server Service Pack last week. Now the SP works fine from ISQL and aborts when it is called from Delphi. I get no error in Delphi.
What can I do to ensure proper execution of the SP?
0
Comment
Question by:ASchindler
3 Comments
 
LVL 10

Expert Comment

by:Jacco
ID: 1357073
Do you use the TStoredProc component?
Are there any parameters of the stored proc necessary?
Do you fill the parameters correctly?
Are the types of the parameters specified correctly in the component?
With the correct type?
Try renewing the TStoredProc component.
Do you use the same parameters from ISQL and Delphi. Maybe your storedproc generates a server exception with the parameters from Delphi.

More info is needed to give an answer to your question.

Regards
Jacco
0
 

Author Comment

by:ASchindler
ID: 1357074
I use a TQuery
There is one Parameter (INteger)
I assign the SQL Statment in Delphi
"EXPORT_ZNS_NENNUNGEN 97177"
I tried TStoredProc, TQuery, ODBCExpress Thstmt, Odbcexpress Query,... . I made a new Form in Delphi -
The Result was the same.
The Procedure Call is transfered to the SQL-Server (ich checked it by SQL Trace) but the Server canceles the Procedure without any Error Message.
I Evaluated the SQL Message (SQL_SUCCESS_WITH_INFO) but there was no hint why the procedure was aborted.
A week ago the Code works fine.
0
 
LVL 3

Accepted Solution

by:
AndreasSchindler earned 200 total points
ID: 1357075
The Procedure in MS-SQL Server transfers the Count of Each Select Statement to the Client. The installed ODBC Driver has a Problem with the count data from Sql Server SP2.
With SET NOCOUNT=ON in the procedure the Problm was solved.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PDF library for Delphi 2 104
Convert a string into a TDateTime 5 50
DBGrid or StringGrid ? 6 63
How to remove Recent Projects from Embarcadero C++ builder XE10. Berlin 2 30
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now