i have rectified your below given code as there were some spelling mistakes but result it same i.e. it is not connecting to sql server.
now i have disabled mcafee firewall also, just in case if that is creating any problems but still result is same.
>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)