sql store procedure error 8179

Article View: borland.public.cppbuilder.database.ado

Article #1103

Back to borland.public.cppbuilder.database.ado Previous Next

#1103

From: Julian Lliteras
Date: Tue, 28 Dec 2004 14:02

29 lines
1685 bytes

Hi,

I get a TADOConnection and TADOQuery to execute an stored procedure and
retrieve result. I do something like:

query->SQL->Add("exec PROC_TEST
'A',0,0,0264207,'01/01/2005','07/01/2005','DB'");
query->Open();

This make an timeout error. But if I do query->Prepared = true first, and
get next sentences within a sql trace:

declare @P1 int
set @P1=1
exec sp_prepare @P1 output, NULL, N'exec PROC_TEST
''A'',0,0,0264207,''01/01/2005'',''07/01/2005'',''DB''
', 1
select @P1

This raise next error:
Servidor: mensaje 8179, nivel 16, estado 2, procedimiento sp_prepare, l�nea
3

If I execute the proc_test with exact values in the ms sql editor it runs
ok!
What's the problem?

Thanks again.
Julian

Technical Details

Message-ID: <41d16752@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,437365060e1bf950,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII
From: "Julian Lliteras" <yartax@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: sql store procedure error 8179
Date: Tue, 28 Dec 2004 15:02:06 +0100
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 213.96.91.217
Message-ID: <41d16752@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1104242514 213.96.91.217 (28 Dec 2004 06:01:54 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail