CodeIgniter and SQLSRV Driver.

[eluser]adanyc[/eluser]
Hi guys, I'm having many problems in code igniter and I would like u could help me.
I have the following stored procedure created in SQL Server 2008.

Code:

CREATE PROCEDURE [dbo].[USP_CODEIGNITER_DEMO]        
@nAreId INT=NULL,
@cAreDescripcion VARCHAR(100)=NULL,
@error VARCHAR(100) OUTPUT        
AS        
BEGIN TRANSACTION          
BEGIN TRY
  BEGIN
   UPDATE AREA SET cAreDescripcion=@cAreDescripcion WHERE nAreId=@nAreId          
  END
            
  SET @error ='exito'          
  COMMIT TRANSACTION          
END TRY          

BEGIN CATCH          
ROLLBACK TRANSACTION          
SET @error =ERROR_MESSAGE()          
END CATCH

This stored make an update in one table I have.

My PHP code is this:

Code:

function update_usuarios() {      
        $nAreId='767';
        $cAreDescripcion='mydescripcion';
        $error = ""; // I tested it whith null also
        $query = $this->db->query("USP_CODEIGNITER_DEMO ?,?,?", array(
            $nAreId,
            $cAreDescripcion,
            $error
                ));        
        return $error;
    }

In my view I only wanna print my output resul from my sql stored procedure, of 'exito' or 'error' from my action.

I give u my model code too:

Code:

function index() {
        $data['datax'] =   $this->usuarios_model->update_usuarios();
        $this->load->view('usuarios_view', $data);
    }

Sorry 4 my bad english, I'm from Peru.
Thanxs 4 all.
I hope ur help.
CYA