proc.cpp

用vc6.0编写的SQL Server扩展存储过程

#include <stdafx.h>

#define XP_NOERROR              0
#define XP_ERROR                1
#define MAXCOLNAME				25
#define MAXNAME					25
#define MAXTEXT					255

char fwmkey[65]="0123456789012345678901234567890123456789012345678901234567891234";

#ifdef __cplusplus
extern "C" {
#endif

RETCODE __declspec(dllexport) xp_decode(SRV_PROC *srvproc);

#ifdef __cplusplus
}
#endif

RETCODE __declspec(dllexport) xp_decode(SRV_PROC *srvproc)
{
	DBCHAR *jiamicode;
	char   jiemicode[17]="";

    if (srv_rpcparams(srvproc) != 2)
	{
        // Send error message and return
        //
        return (XP_ERROR);
	}

	//得到加密码
	jiamicode=(char*)srv_paramdata(srvproc,1);
	if (jiamicode==NULL)
		return XP_ERROR;
	char temp[17]={0};
	memcpy(temp,jiamicode,16);
	
	decoder(temp,jiemicode,fwmkey);

	if (FAIL==srv_paramsetoutput(srvproc, 2,(unsigned char*)jiemicode, 17, FALSE))
    {
		return (XP_ERROR);    
	}
	
	return (XP_NOERROR);
}