Solved

SQL-Server Stored Procedure

Posted on 1998-07-03
3
169 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

752 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