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