Hi,

As Borislav has already pointed out it would seem that the connection to the sql server has failed for some reason. Adding the error handling should help point out whats going wrong.

Jon

>Dear All,
>
>I have problem with SQLEXEC.
>
>When I run bellow coding. It will prompt me error message as
>"Alias is not found" . But this coding is working fine on another machine which have same environment.
>
>QHANDLE= SQLSTRINGCONNECT(;
> 'driver=SQL server;' + ;
> 'Server=(local);' +;
> 'database=master;' + ;
> 'uid=SA;' + ;
> 'pwd=SA;' + ;
> 'trusted_connection=YES')
>
>
>=SQLEXEC(QHANDLE,'SELECT * FROM MASTER','QMASTER')
>SELECT QMASTER
>
>I'm running on Windows Xp Professional Edition Service Pack 2 ,
>Visual Foxpro 8.0 (SP1) ,MDAC 2.8, SQL Server 2000 (SP4)
>
>Please Advice. What's wrong ? any solution ?
>
>
>Regards
>Nicholas Lim