I did not solve this problem. Actually, parameter name is correct, but
what I found out that it is SQL error related to datetime conversion in
the table and I have not solved this problem yet.
I also notice when I run Stored Procedure apart from calling code with
provided date it runs perfectly, but as soon as I called it from code it
is nightmare I could not solve and I suspect it is related to SQL driver
settings or data type in the table.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Friday, July 11, 2008 9:21 AM
To: u2-users@listserver.u2ug.org
Subject: [?? Probable Spam] RE: [U2] re:passing parameters to stored
procedures
Did you solve this?
What comes to mind is that SQL might be taking the @ sign as a delimiter
or
some such and stripping the variable before it gets to the proc..
-Original Message-
Subject: [U2] re:passing parameters to stored procedures
I have created stored procedure to run and I have to pass date parameter
to
it. I'm getting error message saying ERROR [42000] [Microsoft][ODBC SQL
Server Driver][SQL Server]Procedure 'ProcedureName' expects parameter
'@FirstDay', which was not supplied. I implicitly assign parameter value
and
type and checked the name to be identical and there is still an error
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
