General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2003 Server
Hi Borislav
Thank you for your advice
I think i had found the solution.
---------------------------------------------------------------
* Original Code
qhandle = SQLSTRINGCONNECT(;
'driver=SQL server;' + ;
'Server=(local);' +;
'database=master;' + ;
'uid=SA;' + ;
'pwd=SA;' + ;
'trusted_connection=YES')
IF SQLEXEC(qhandle,'SELECT * From SysDatabase','Qmaster') < 0
.....
ENDIF
---------------------------------------------------------------
* After ( Work Fine )
=SQLEXEC(qhandle,'USE MASTER')
IF SQLEXEC(qhandle,'SELECT * FROM SysDatabase','QMASTER') < 0
....
ENDIF
I didn't put coding "=SQLEXEC(qhandle,'USE MASTER')" before next SQLEXEC execution.
But some of machine are working fine. Don't know why.
Thank you and have good day.
Regards
Nicholas
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only