Further to the below, I also tried creating the ADODB object via COM and 
it worked fine, so its obv. an issue with the ADO components 
somewhere...GREAT.

Thanks, Jeremy

-----Original Message-----
From: "vss" <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Mon, 12 Nov 2001 13:54:46 +1300
Subject: [DUG]:  SQL Error

> Hi all.
> 
> I am using an ADO stored proc. comp. and calling a standard stored proc
> that has an integer as the first param, and a string as the second
> param, 
> and it returns an integer.
> 
> I can all it ok if the values are zero and blank, BUT as soon as I use 
> values I get : - "Arguments of the wrong type, are out of acceptable,
> or 
> inconflict with one another"
> 
> I then run the Stored proc with the same values in query Analyzer and
> it 
> runs fine.
> I have also added "Set no count" into the stored proc. also, but I
> still 
> get the error.
> I then tried executing the SQL statement in an ADOQuery comp. and got
> the 
> same result.
> 
> Can anyone help ?
> I am running D5 with the ado update and SP1 on SQL Server 2k.
> 
> Thanks, Jeremy Coulter
> 
> 
> -----------------------------------------------------------------------
> ----
>     New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
>                   Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED] 
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/


---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/

Reply via email to