>This code:
>
>
>
>iResult = SQLEXEC(._iSQLConnHandle, [EXEC sp_GetVehicle @vehiclekey=1], sTableName)
>
>
>generates the error "Could not find stored procedure 'EXEC sp_GetVehicle @vehiclekey=1'"
>
>I can run this from SQL console:
>
>
>EXEC sp_GetVehicle 1
>
>
>
>Anyone know what I'm doing wrong?
>
>Thanks
Are you sure that this SP in the database you're setting a connection to? Is it possible to have it in the wrong database?
If it's not broken, fix it until it is.
My Blog