You've to write SQL Server Extended SP's in C/C++ not VFP.

>Hi,
>
>As anyone here ever tried (and succeeded) writing SQL Server Strored Procedures using VFP? Any version of VFP would do.
>
>For example, here are the requisites (according to BOL) of writing such procedures:
>
>Must have a prototype with the following structure:
>SRVRETCODE xp_extendedProcName (SRVPROC *);
>
>Use the following compiled library:
>Opends60.lib
>
>Finally, use a header file (I know this is possible but the code in it is pure C):
>Srv.h
>
>Here's the code in this header file:
>
>...
>
>typedef long DBINT;
>typedef char DBCHAR;
>typedef unsigned char DBBINARY;
>typedef unsigned char DBBIT;
>typedef double DBFLT8;
>
>typedef struct srv_datetime
>{ // Format for SRVDATETIME
> long dtdays; // number of days since 1/1/1900
> unsigned long dttime; // number 300th second since mid
>} DBDATETIME;
>
>typedef struct srv_money
>{ // Format for SRVMONEY
> long mnyhigh;
> unsigned long mnylow;
>} DBMONEY;
>
>...
>
>SRV_CONFIG* srv_getconfig( SRV_SERVER * server );
>SRV_SERVER* srv_getserver( SRV_PROC * srvproc );
>BOOL srv_got_attention( SRV_PROC * srvproc );
>void* srv_eventdata( SRV_PROC * srvproc );
>
>...
>
>
>Thanks a lot,
>
>SC