Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2003 Server
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement