Click here to Skip to main content
15,891,017 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
When I try to run the sql script for encryption, it takes too long to execute the script and I am forced to cancel the query.
However, other gpg commands like list--keys, --import-keys work perfectly.

Here is my script:
SQL
select @encrypt = '"c:\Program Files (x86)\GNU\GnuPG\gpg2.exe" -e -r '+ @key+' ' + @sPath+'filename.txt'
exec master..xp_cmdshell @encrypt 


What I have tried:

I guess it is waiting for a user input but how do i make sure about that?
Posted
Comments
RedDk 16-Jun-16 13:25pm    
How long is too long? I suggest sampling. Use less data. Do you encounter the same problems as previous?
Member 12573208 16-Jun-16 14:24pm    
The file which I am trying to encrypt contains just one line. It shows query executing... for like an hour. but when i run the command from dos cmd, the same file is encrypted in less than a sec.
Member 12573208 20-Jun-16 10:57am    
Resolved the issue. thnx!!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900