RE: Power outage, lost connection info and saved sql

Thanks, Norm. I didn't see a strings executable in the link you sent, but SysInternals has one that worked quite well. Hopefully I won't need it anymore!

Michael

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Norman Dunbar
Sent: Tuesday, April 24, 2012 2:21 AM
To: [email protected]
Subject: Re: [toad] Power outage, lost connection info and saved sql

Morning Michael,

On 23/04/12 22:36, Michael Staszewski wrote:
> Hi Wendy. I've received your .err file offline and unfortunately am able
> to get nothing from it. If I open the file in Notepad++ I can clearly
> see many statements in there, but the file is binary and I'm not sure
> how to terminate the file properly by stripping the trailing nulls (the
> corruption) in such a way that Toad can still load the file without
> error. We use Delphi's built-in component streaming functionality for
> this so it's not a file format that I fully understand.

I'm thinking, if you can see statements in the file, then perhaps you 
can use the Linux/Unix "strings" command to strip out all of the crud 
leaving only the text?

strings wendys_file > wendys.txt

You may get some crud in there as well as the valid SQL, but it's bound 
to be better than nothing?

If you like, send it to me and I'll run it through strings for you.


Or, you can download the GNU Utilities for Windows and get all sorts of 
Linux/Unix commands on your Windows box! I use these on my work laptop 
frequently.

http://gnuwin32.sourceforge.net/



-- 
Cheers,
Norm. [TeamT]


------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/