Recent content by jasonp45

The following insert query took ~8 mins on 1 million rows, going from an SQL table to another SQL table on a linked server: INSERT INTO [LinkedServer].[LinkedDatabase].[dbo].[LinkedTable] SELECT * FROM [LocalDatabase].[dbo].[LocalTable] However, creating an SSIS package and specifying 'Fast...

Got it! This is the command-line syntax: "C:\Program Files\GnuPG\gpg.exe" --passphrase "My passphrase" -o "C:\MyFile.txt" -d "C:\MyFile.pgp" Here is a VBScript example: Option Explicit Dim bWaitOnReturn: bWaitOnReturn = True Dim iWindowStyle: iWindowStyle = 7 'Minimized; active window stays...

Got it! This is the command-line syntax: "C:\Program Files\GnuPG\gpg.exe" --passphrase "My passphrase" -o "C:\MyFile.txt" -d "C:\MyFile.pgp" Here is a VBScript example: Option Explicit Dim bWaitOnReturn: bWaitOnReturn = True Dim iWindowStyle: iWindowStyle = 7 'Minimized; active window stays...

I'm trying to decrypt a GPG/PGP file using GPG via the command line. This works: "C:\Program Files\GnuPG\gpg.exe" -o "C:\MyFile.txt" -d "C:\MyEncryptedFile.pgp" However the command-window prompts me for my passphrase. I plan on scripting this and calling an InputBox to prompt for the...

I got it to output to a file like so: "C:\Program Files\GNU\GnuPG\gpg.exe" -d "C:\MiFile.pgp" > "C:\MyFile.txt" Now the only piece of the puzzle is passing the passphrase as a parameter via command-line.

Yeah I suppose it is more appropriately a GPG question, though I'm not sure if there's a forum for that? However my thought was that if anyone had implemented it via command-line they'd do so via either VBScript or a DOS batch file, and since I'm doing the former this seemed the place to post...

I have a PGP-encrypted file which I download and decrypt on my machine (currently via the GPG Windows GUI). Call the file 'MyFile.gpg'. I want to automate the decryption of this file. However I can't seem to locate a reference detailing the command-line syntax necessary, though I did find the...

I've installed OpenSSH successfully, and it works fine for my user account (Domain Administrators group). However when I add a new Domain User, then add this to the OpenSSH 'passwd' file, login via SFTP client fails. If I add this user to the Domain Administrators group their SFTP login works...

I'm on 64-bit and I've found that the old MSComDlg.CommonDialog object can only be invoked under 32-bit. I can use the Word dialog but of course that requires installing Word, and creating the Word.Application object is slow. What I'd like to know is how (or if) I can invoke a file-open/browse...

There is a secure FTP site I connect to (using FileZilla client). Many months ago I clicked 'Always trust' on their certificate in the FileZilla interface; now I can no longer connect. I know the site still works because I can connect from another (XP) machine...on that machine I get the...

I solved this by the way, in case anyone's interested: Option Explicit Dim oExpSchTsk Set oExpSchTsk = New cExport_Scheduled_Tasks oExpSchTsk.Export_Scheduled_Tasks Set oExpSchTsk = Nothing WScript.Quit Class cExport_Scheduled_Tasks '<Initialization> Private Array_XML_Aggregate 'as String...

I can access the clipboard via the IE object, but this requires interaction. Since I have AutoIt installed I found that I can write to the clipboard like this: Private Sub Write_to_Clipboard(sClipboard_Text) Dim oAutoIt 'as Object = AutoItX3.Control Set oAutoIt =...

You have to put [User] in brackets as well: Insert Into [User] ([User First Name],... As mentioned, 'User' is a reserved word for Access SQL.

I'm trying to list the names of the Scheduled Tasks on my 64-bit Win 2008 server so I can export them. I discovered that I can easily export them as XML files, all at once (in which case they can't be imported on another machine), or individually by name with the following command-line syntax...

dm4ever: THANK YOU! That is exactly correct, and I never would've thought to try it that way. tsuji: thanks, I knew my implementation was a bit sloppy (and the utilization is even uglier); that will help me clean it up a bit. skie: the dictionary object looks quite useful and a bit clearer...