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/