Solved

SQL-Server Stored Procedure

Posted on 1998-07-03
3
167 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Downloading email attachments 2 73
Delphi 2 59
Convert MS Word document to a PDF file 9 80
Graphics32 under Delphi 10.1 Berlin 2 65
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

773 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