That is the funny part there is no counts or variables named count in the stored procedure. I just tested a few other sp's on the same database and I'm receiving the exact same error. It can't be a exec permissions issue on the sp's as I've setup the ODBC connection using the 'sa' account ??? I've checked the sp syntax and it is fine .... (*starts to scratch head*).
> Even just the COUNT part? > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Rod Higgins > Sent: Friday, 11 July 2003 5:28 PM > To: CFAussie Mailing List > Subject: [cfaussie] RE: SQL Server ODBC error > > > Hi Steve, > > I actually calling a stored procedure. The procedure is about 1500 lines > or so, so I won't post it. > > Thanks > Rod > > > > Show the query your using > > > > Steve > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Rod Higgins > > Sent: Friday, 11 July 2003 4:18 PM > > To: CFAussie Mailing List > > Subject: [cfaussie] SQL Server ODBC error > > > > > > Hi, > > > > Don't know if this is a common error or not, cant find much about it via > > google ... > > > > ODBC Error Code = 07001 (Wrong number of parameters) > > > > [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error > > > > Hint: The cause of this error is usually that your query contains a > > reference to a field which does not exist. You should verify that the > > fields included in your query exist and that you have specified their > > names correctly. > > > > The error appears when calling a stored procedure. The procedure works > > from iSQL (and perfectly on Sybase before I ported it) and I have made > > sure all input parameters are passed correctly to the procedure from > > within the cf template. I updated the ODBC drivers by upgrading MDAC to > > 2.71 sp1. The only reference to this error I can find from google is using > > double quotes in the query/sp. I have checked and there is no use of > > double quotes in the sp?? > > > > Config CF4.52 Ent, Win2k sp3, SQL 2000 sp3 > > > > any help appreciated > > > > thanks > > Rod > > > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
