Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  SQLServer and OLEDB

Author  Topic  schw Starting Member 1 Post Posted - 2005-08-08 : 09:02:24 Hi, I wonder if there is anyone that can help me with a very general problem. In my code I call spICommandText->SetCommandText(DBGUID_DEFAULT,bstrProcName); (where bstrProcName is "{CALL sp_procName;1 ?}") followed by the ICommandPrepare::Prepare(0). The problem is that it works with some SQL servers and doesnt with others. The error I get from Prepare method is DB_E_ERRORSINCOMMAND. When I change bstrProcName to "Exec sp_Test;1 ?" then it works. Can anyone tell me what is the difference and when I should use EXEC and when CALL statements? thanks a lot regards, schw