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/