Re: [Mssqlcompressed-users] Prevent Backslash Escaping

[Clay L. <cl...@le...>]

Tim,

There is a new version of the application that fixes the blackslash escaping
issue.  The \s, \p, and \\ are no longer escape sequences, and the only
escaping is ";;" (to allow for ";" in parameters).

-Clay

2009/8/9 Clay Lenhart <cl...@le...>

> The short answer is that msbp (not .Net) is converting \s to ";", and this
> is by design (well, questionable design ;) )
>
> The args are semicolon separated, so to be able to include a semicolon, you
> use "\s".  To get what you want you have to escape the backslash, eg "\\s".
>
>
> "\s", "\p" and "\\" are special in msbp.  Since \s and \p occur commonly in
> paths, I have a think of an alternative, perhaps \: for semicolon for
> example.
>
> This command is what you want:
> msbp.exe backup "db(instancename=sqlexpress;database=salonware)"
> "zip64(level=7;filename=salonware.bak)" "local(path=c:\documents and
> settings\timb\desktop\\salonwaretest.bak.7z)"
>
> Cheers,
> Clay
>
>
>
> ---------- Forwarded message ----------
> From: Tim Bushell <ti...@tl...>
> Date: 2009/8/6
> Subject: [Mssqlcompressed-users] Prevent Backslash Escaping
> To: mss...@li...
>
>
> Hi there,
>
> I just downloaded version 1.1 and was running some tests with it.
>
> Can you recommend any way to prevent the backslash escaping that .NET is
> doing?
>
> Here is why I ask:
>
> When I run following command, the output file is invalid because the \s
> for the file name is being interpreted as an escaped semicolon.  If I
> change the \s to \S then the file is created as intended.
>
>  >msbp.exe backup "db(instancename=sqlexpress;database=salonware)"
> "zip64(level=7;filename=salonware.bak)" "local(path=c:\documents and
> settings\timb\desktop\salonwaretest.bak.7z)"
> Connecting: Data Source=.\sqlexpress;Initial Catalog=master;Integrated
> Security=SSPI;Asynchronous Processing=true;
> local:
>        path=c:\documents and settings\timb\desktop;alonwaretest.bak.7z
> zip64: level = 7, filename=salonware.bak
> Backup started
>
>
> --
> Tim Bushell
> IT Manager
> TLS - Connecting Voices
> Phone: (519) 964-3121
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Mssqlcompressed-users mailing list
> Mss...@li...
> https://lists.sourceforge.net/lists/listinfo/mssqlcompressed-users
>
>