Custom BSFN works on clients but not on the server

[timhui]

We have a custom BSFN set as C/S and is assigned to a custom DLL which is C/S as well.

No problem or error at all in building packages and deploying packages.

It is called by an UBE. When running the UBE locally, everything works fine. However, when submitting the UBE to the server, UBE erred out right on the BSFN call.

We finally found the following logged message in the DLL log file in the environment base foundation full package OBJ directory on the server -

b59exstp.obj : error LNK2001: unresolved external symbol _SQLDisconnect@4
b59exstp.obj : error LNK2001: unresolved external symbol _SQLFreeHandle@8
b59exstp.obj : error LNK2001: unresolved external symbol _SQLExecDirect@12
b59exstp.obj : error LNK2001: unresolved external symbol _SQLBindParameter@40
b59exstp.obj : error LNK2001: unresolved external symbol _SQLPrepare@12
b59exstp.obj : error LNK2001: unresolved external symbol _SQLConnect@28
b59exstp.obj : error LNK2001: unresolved external symbol _SQLSetEnvAttr@16
b59exstp.obj : error LNK2001: unresolved external symbol _SQLAllocHandle@12
d:\jdedwardsoneworld\ddp\b7334\packages\KITCHELLDV\bin32\KITCHELL.dll : warning LNK4088: image being generated due to /FORCE option; image may not run

We did include SQL.h and SQLEXT.h header files in the b59exstp.h file.

Could anyone provide some answer/solution to the problem? Thanks in advance!