OK.
I accept that [Driver={SQL Server};Server=(vinodhome);Database=(vinod);UID=vinod;PWD=mypass;] is the right connection string:

ConnStr = [Driver={SQL Server};Server=(vinodhome);Database=(vinod);UID=vinod;PWD=mypass;]
lcSQLHandle = SQLStringConnect(ConnStr)
IF lcSQLHandle < 0
   AERROR(laError)
   MESSAGEBOX("Can not coonect to SQL Server. Reason: "+TRANSOFRM(laError[1,1])+" "+laError[1,2])
   RETURN
ENDIF

*** Get all Records from Table named zsample
IF SQLEXEC(lcSQLHandle, [SELECT * FROM ZSample],"crsZSample") < 0
   AERROR(laError)
   SQLDISCONECT(lcSQLHandle
   MESSAGEBOX("Can not execute SQL Statement. Reason: "+TRANSOFRM(laError[1,1])+" "+laError[1,2])
   RETURN
ENDIF

SELECT crsZSample
BROWSE NORMAL

This is SQL PassThough method.
I prefer to use Cursor Adapters to handle the date in SQL Server. But you must learn them yourself. I not say that you can't ask for help, but try to learn them and then ask. You have so ma many possibilities to manage the data with them, that I could not explain here (not so many English words in my vocabulary) :o)