psexec and osql within autoit

[williamk]

Having Problems getting PSEXEC to execute within Autoit.

I can run the following on the remote machine with no problems:

ShellExecuteWait('C:\Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe', '-S DATA -d Logs -U sa -P password -n -Q "insert into t_File_Transfers (Tran_date,Process,Source_File,Destination_File,SF_Date,DF_Date,copy_flag) values('''& $systime &''',''Kronos Demographic Data to AS 400'',''AS400.TXT'',''AS400 - KRONOSHR'','''& $lstdate &''','''&$yyyymd1&''','''& $cpyflag&''')')

However if I try to run it from my local machine with PSEXEC it either runs but does not work or I get an "Unable to execute the external program" error. The variations I have tried to run are:

ShellExecuteWait('C:\Windows\psexec.exe', '\\zrk C:\ Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe -S DATA -d Logs -U sa -P password -n -Q "insert into t_File_Transfers (Tran_date,Process,Source_File,Destination_File,SF_Date,DF_Date,copy_flag) values('''& $systime &''',''Kronos Demographic Data to AS 400'',''AS400.TXT'',''AS400 - KRONOSHR'','''& $lstdate &''','''&$yyyymd1&''','''& $cpyflag&''')')

This runs but the osql command does not do the insert.

I have also tried:

RunWait(@Comspec & "/C" & 'C:\Windows\psexec.exe \\zrkdata osql.exe -S ZRKDATA -d Logs -U sa -P password -n -Q "insert into t_File_Transfers (Tran_date,Process,Source_File,Destination_File,SF_Date,DF_Date,copy_flag) values('''& $systime &''',''Kronos Demographic Data to AS 400'',''AS400.TXT'',''AS400 - KRONOSHR'','''& $lstdate &''','''&$yyyymd1&''','''& $cpyflag&''')')

This gives me the error mentioned above.

I figure there must be some small mistake in my syntax or something special required for PSEXEC that I don't know about. Can someone help?