473,320 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problems running stored procedures

I have two similar stored procedures which I'm running. One runs and
one doesn't. I can run both with no problems in SQL Enterprise (7.0
standard) and have checked the permissions and am happy with them.
Whilst the statements in each sp are different, I'm calling them in
exactly the same way (using Delphi 5 Windows 2000). I don't get any
trappable errors.

I ran a trace on what was happening and I get two different set of
results. This is what I'm trying to get my head around.

Client Trace (runs)

1 09:09:44 Log started for: Swift Client Import Utility
2 09:09:48 SQL Prepare: MSSQL - :1 =
dbo.CBFAUpdateSwiftClient;1
3 09:09:48 SQL Misc: MSSQL - Set stored procedure on or off
4 09:09:48 SQL Data In: MSSQL - Param = 1, Name = Result, Type
= fldINT32, Precision = 0, Scale = 0, Data = NULL
5 09:09:48 SQL Misc: MSSQL - Set statement type
6 09:09:48 SQL Execute: MSSQL - :Result =
dbo.CBFAUpdateSwiftClient;1
7 09:09:48 SQL Stmt: MSSQL - Close
8 09:09:53 SQL Connect: MSSQL - Disconnect NEW
9 09:09:53 SQL Connect: MSSQL - Disconnect NEW
10 09:09:53 SQL Connect: MSSQL - Disconnect PASSTHRU

Enquiry Trace (Doesn't run)

1 09:08:21 Log started for: Swift Client Import Utility
2 09:08:24 SQL Prepare: MSSQL - :1 =
dbo.CBFAUpdateSwiftEnquiries;1
3 09:08:24 SQL Execute: MSSQL - :Result =
dbo.CBFAUpdateSwiftEnquiries;1
4 09:08:50 SQL Prepare: MSSQL - :1 =
dbo.CBFAUpdateSwiftEnquiries;1
5 09:08:50 SQL Misc: MSSQL - Set stored procedure on or off
6 09:08:50 SQL Data In: MSSQL - Param = 1, Name = Result, Type
= fldINT32, Precision = 0, Scale = 0, Data = NULL
7 09:08:50 SQL Misc: MSSQL - Set statement type
8 09:08:50 SQL Execute: MSSQL - :Result =
dbo.CBFAUpdateSwiftEnquiries;1
9 09:08:50 SQL Vendor: MSSQL - dbrpcinit
10 09:08:50 SQL Vendor: MSSQL - dbrpcexec
11 09:08:50 SQL Vendor: MSSQL - dbsqlok
12 09:08:50 SQL Vendor: MSSQL - dbresults
13 09:08:50 SQL Vendor: MSSQL - dbnumcols
14 09:08:50 SQL Vendor: MSSQL - dbcount
15 09:08:50 SQL Stmt: MSSQL - Close
16 09:08:50 SQL Vendor: MSSQL - dbdead
17 09:08:50 SQL Vendor: MSSQL - dbcancel
18 09:08:56 SQL Connect: MSSQL - Disconnect NEW
19 09:08:56 SQL Connect: MSSQL - Disconnect NEW
20 09:08:56 SQL Connect: MSSQL - Disconnect PASSTHRU
21 09:08:56 SQL Vendor: MSSQL - dbdead
22 09:08:56 SQL Vendor: MSSQL - dbfreelogin
23 09:08:56 SQL Vendor: MSSQL - dbclose

I would have thought that these would be nearly identical. They call
sp's on the same servers in the same way, so the call to do this
should (in my mind) be the same.

I can post the sp's if anyone thinks they are of relevance.

I can of course set up these stored procedures to run at a certain
time, but I'd like to try and understand this a little more.

Thanks in advance.

Ryan
Jul 20 '05 #1
1 4220
Ryan (ry********@hotmail.com) writes:
I have two similar stored procedures which I'm running. One runs and
one doesn't. I can run both with no problems in SQL Enterprise (7.0
standard) and have checked the permissions and am happy with them.
Whilst the statements in each sp are different, I'm calling them in
exactly the same way (using Delphi 5 Windows 2000). I don't get any
trappable errors.

I ran a trace on what was happening and I get two different set of
results. This is what I'm trying to get my head around.


There wasn't a wealth of information in your posting, but at least
I could conclude that you are using DB-Library, directly or indirectly.
Not that I know Delphi, but maybe you should investigate some other
client library. Not that DB-Library is bad, but unfortunately Microsoft
is not developing it any more, and you don't full support for new and
improved data types in SQL 7 and later with DB-Library.

One thing I notice is that there is a call to dbdead in the log. Possibly
this indicates that the procedure runs into a fatal error which causes
a crash on the SQL Server side.

One thing to try is to run the procedures from command-line ISQL,
because this utility also uses DB-Library, so you get the same settings
as you do with your Delphi app.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jeremy | last post by:
Hi, I am having a problem running an sql stored procedure with ADO/ASP. If I hard code a select statement, the code works, but when I try to use a stored procedure it bombs. Here is my code: ...
2
by: Ellen Graves | last post by:
I am having a lot of problems with DB2 8.3.1 on RH Linux AS2.1. Installing and running stored procedures is problematic. Stored procedures I have used for years on V7 on WinNT are now failing...
3
by: Rhino | last post by:
I've spent the last couple of hours trying to figure out how to debug a Java stored procedure and am just going in circles. The last straw came when I got "Cannot open input stream for default"...
0
by: ben | last post by:
We have been able to restore a database backup made on DB 7.2 in DB2 8.1. But now, while trying to rebuild the stored procedures which reside in our database, we receive the following error : ...
5
by: Tim Marshall | last post by:
I was following the thread "Re: Access Treeview - Is it Safe Yet?" with interest and on reading the post describing Lauren Quantrell's SmartTree, I've run into something I don't understand: Stored...
1
by: sasachi sachi sachi | last post by:
Hi there, I have a data manipulation process written in a Nested Stored procedure that have four levels deeper. When I run these individual procedures individually they all seems to be fine....
4
by: nishi57 | last post by:
I hope I can get some help regarding this issue, which has been going on for a while. I have a desktop user who is having problem running "Stored Procedures". The DB2 Connect application works fine...
7
by: pbd22 | last post by:
Hi. I really need some advice on fine-tuning a stored procedure that is the meat of the search logic on my site. Customers are allowed to save searches, which dumps the search logic in a table...
5
by: Claudio M. E. Bastos Iorio | last post by:
Hi, anyone using VS2008 (final) on windows Vista? I have a problem. The ASP.NET web site administration tool on any site created by VS2008, running on Vista, is not working as it should. I can...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.