Hi Everyone

I´m trying to connect FOX DOS 2.6 with SQL Server 2000 but I receive the following error message:

DB-LIBRARY error 10040: Db-library network communciations layer not loaded.

The code I´m using is the following:

 
CLOSE ALL
CLEAR all
SET TALK OFF
SET LIBRARY TO SYS(2004)+"FPSQL.PLB"
PUBLIC errval
PUBLIC errmsg
PUBLIC Hndl
errval=0
errmsg=""
sourcename="test"
user="sa"
passwd=""
wait window "Intentando conexion"
Hndl=DBCONNECT(sourcename,user,passwd)
if Hndl>0
  wait wind "Conexi¢n exitosa"
else
  error=DBerror(0,@errmsg,@errval)
  wait windo SUBSTR(errmsg,1,70)+chr(13)+SUBSTR(errmsg,71,70)
endif
 
lval=DBExec(Hndl,"USE PUBS")
if lval=1
  wait wind "Instruccion SQl ejecutada"
else
  wait wind "No se ejecuto instruccion SQL"
endif
lval=DBExec(Hndl,"selet * from jobs")
if lval=1
  wait wind "Instruccion SQl ejecutada"
else
  wait wind "No se ejecuto instruccion SQL"
endif


Somebody knows what I´m doing wrong?. 

Thank you for your help.

Carlos

Carlos A. Miranda
E.I.S.lnc
President