---
product: Chilkat
product_version: 11.7.0
language: sqlserver
language_label: SQL Server
class: Zip
license: bundle
deprecated: false
reference_html: https://www.chilkatsoft.com/refdoc/sqlserver_ZipRef.html
---
# Chilkat Zip — SQL Server — v11.7.0

> Chilkat 11.7.0 · language=sqlserver · class=Zip
> Other versions: replace `11.7.0` in this URL. Other languages: `https://www.chilkatsoft.com/ai-docs/v/11.7.0/<lang>/classes/Zip.md`.
> Language-wide rules (install, unlock, error model, strings/bytes): `https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/guide.md`.

## Purpose

**Create, read, modify, encrypt, and extract ZIP archives.**

`Chilkat.Zip` provides a comprehensive API for working with ZIP archives from files, memory, `BinData`, embedded resources, and Windows self-extracting EXEs. It can create new archives, open existing ZIPs, add files or in-memory data, inspect entries, extract selectively, and write the final archive to disk or memory.

**Create ZIP archives**

Add files, directories, strings, byte arrays, `BinData`, and `StringBuilder` content.

**Open ZIPs from many sources**

Open archives from disk, memory, `BinData`, embedded Windows resources, or Chilkat-created self-extracting EXEs.

**Control stored paths**

Use options such as `AppendFromDir`, `DiscardPaths`, `PathPrefix`, and `saveExtraPath`.

**Extract selectively**

Extract all files, matching entries, newer files, or flatten all output into a single directory.

**Encryption support**

Work with WinZip-compatible AES encryption and legacy Zip 2.0 password protection.

**Large archive support**

ZIP64 is used automatically when older ZIP limits are exceeded.

**Important:** Many methods update the in-memory ZIP object first. The archive is not written until a method such as `WriteZip`, `WriteZipAndClose`, `WriteBd`, or `WriteToMemory` is called.

For an extended overview, see [Zip Class Overview](https://www.chilkatsoft.com/zip_class_overview.asp).

## Object creation, unlocking and error handling

**Object Creation**

```sql
DECLARE @hr int
DECLARE @zip int
EXEC @hr = sp_OACreate 'Chilkat.Zip', @zip OUT
IF @hr <> 0
BEGIN
    PRINT 'Failed to create ActiveX component'
    RETURN
END

-- ... use @zip ...

EXEC @hr = sp_OADestroy @zip
```

T-SQL uses the Chilkat ActiveX through the OLE Automation stored procedures. They must be enabled once on the server (`EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE;`), and the Chilkat ActiveX registered must match the bitness of the SQL Server instance (64-bit for a 64-bit SQL Server). To bind to a specific major version of Chilkat, append the major version number to the ProgID, such as `sp_OACreate 'Chilkat.Zip.11'` for Chilkat v11.\*.\*.

`sp_OACreate` returns an object token (an `int`) that is passed as the first argument of every `sp_OAMethod`, `sp_OAGetProperty` and `sp_OASetProperty` call, and released with `sp_OADestroy`. Objects returned by methods (such as an `HttpResponse` or `JsonObject`) are also tokens received through an `int` OUT parameter; they must likewise be destroyed, and the OUT parameter is `NULL` when the method fails to return an object. Objects passed as arguments are passed by their token. When an OLE Automation procedure itself fails (non-zero `@hr`), `sp_OAGetErrorInfo` describes the error.

Data types: strings are `nvarchar(4000)`; integers, booleans (1 or 0) and object tokens are `int`; dates are `datetime`. In the signatures on this page, `@success`, `@iResult`, `@sResult` and the like are the OUT variables receiving a method's return value, `@iValue` / `@sValue` receive or supply a property value, and the remaining `@` variables are the method's arguments in order.

A string returned through an OUT parameter is limited to 4000 characters. For longer values, retrieve the result as a result set into a table variable instead of an OUT parameter, for example `DECLARE @tmp TABLE (outputLine ntext)` followed by `INSERT INTO @tmp EXEC sp_OAGetProperty @zip, 'LastErrorText'`. See [string length limitations for strings returned by sp_OAMethod calls](https://www.chilkatsoft.com/sql_server_nvarchar_max_limitation.asp).

Methods that pass or return raw byte arrays are not shown on this page, because `varbinary(max)` values cannot be exchanged through `sp_OAMethod` (see [varbinary(max) limitation](https://www.chilkatsoft.com/sql_server_varbinary_max_limitation.asp)). Use the `BinData`-based alternatives (methods ending in *Bd*) or the base64 / hex string-encoded variants instead. Binary *properties* (such as `LastBinaryResult`) can be retrieved as a result set into a table variable, as shown in their signatures. Asynchronous (*\*Async*) methods and event callbacks are not available from SQL Server.

Call `Global.UnlockBundle` once at the start of the program, before using this or any other Chilkat class. Any string unlocks a fully functional 30-day trial; a purchased unlock code is used in production. See `guide.md` for the exact code in SQL Server.

How failure is reported depends on the method's return type and is stated in the note under each method below. In every case the diagnostic text is in the `LastErrorText` property of the object whose method was called.

## Members common to every Chilkat class

Documented once per language in `common-members.md`; listed here so this page is self-contained.

| Property | Signature | Access | Meaning |
|---|---|---|---|
| `DebugLogFilePath` | `EXEC sp_OAGetProperty @zip, 'DebugLogFilePath', @sValue OUT EXEC sp_OASetProperty @zip, 'DebugLogFilePath', @sValue` | read/write | If set to a file path, this property logs the LastErrorText of each Chilkat method or property call to the specified file. |
| `LastBinaryResult` | `INSERT INTO @tmp EXEC sp_OAGetProperty @zip, 'LastBinaryResult'` | read-only | This property is mainly used in SQL Server stored procedures to retrieve binary data from the last method call that returned binary data. |
| `LastErrorHtml` | `EXEC sp_OAGetProperty @zip, 'LastErrorHtml', @sValue OUT` | read-only | Provides HTML-formatted information about the last called method or property. |
| `LastErrorText` | `EXEC sp_OAGetProperty @zip, 'LastErrorText', @sValue OUT` | read-only | Provides plain text information about the last called method or property. |
| `LastErrorXml` | `EXEC sp_OAGetProperty @zip, 'LastErrorXml', @sValue OUT` | read-only | Provides XML-formatted information about the last called method or property. |
| `LastMethodSuccess` | `EXEC sp_OAGetProperty @zip, 'LastMethodSuccess', @iValue OUT EXEC sp_OASetProperty @zip, 'LastMethodSuccess', @iValue` | read/write | Indicates the success or failure of the most recent method call: `1` means success, `0` means failure. |
| `LastStringResult` | `EXEC sp_OAGetProperty @zip, 'LastStringResult', @sValue OUT` | read-only | In SQL Server stored procedures, this property holds the string return value of the most recent method call that returns a string. |
| `LastStringResultLen` | `EXEC sp_OAGetProperty @zip, 'LastStringResultLen', @iValue OUT` | read-only | The length, in characters, of the string contained in the LastStringResult property. |
| `VerboseLogging` | `EXEC sp_OAGetProperty @zip, 'VerboseLogging', @iValue OUT EXEC sp_OASetProperty @zip, 'VerboseLogging', @iValue` | read/write | If set to `1`, then the contents of LastErrorText (or LastErrorXml, or LastErrorHtml) may contain more verbose information. |
| `Version` | `EXEC sp_OAGetProperty @zip, 'Version', @sValue OUT` | read-only | Version of the component/library, such as "10.1.0" |

## Member index

| Member | Kind | Signature |
|---|---|---|
| `AbortCurrent` | property, read/write | `EXEC sp_OAGetProperty @zip, 'AbortCurrent', @iValue OUT EXEC sp_OASetProperty @zip, 'AbortCurrent', @iValue` |
| `AppendFromDir` | property, read/write | `EXEC sp_OAGetProperty @zip, 'AppendFromDir', @sValue OUT EXEC sp_OASetProperty @zip, 'AppendFromDir', @sValue` |
| `AutoRun` | property, read/write | `EXEC sp_OAGetProperty @zip, 'AutoRun', @sValue OUT EXEC sp_OASetProperty @zip, 'AutoRun', @sValue` |
| `AutoRunParams` | property, read/write | `EXEC sp_OAGetProperty @zip, 'AutoRunParams', @sValue OUT EXEC sp_OASetProperty @zip, 'AutoRunParams', @sValue` |
| `AutoTemp` | property, read/write | `EXEC sp_OAGetProperty @zip, 'AutoTemp', @iValue OUT EXEC sp_OASetProperty @zip, 'AutoTemp', @iValue` |
| `CaseSensitive` | property, read/write | `EXEC sp_OAGetProperty @zip, 'CaseSensitive', @iValue OUT EXEC sp_OASetProperty @zip, 'CaseSensitive', @iValue` |
| `ClearArchiveAttribute` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ClearArchiveAttribute', @iValue OUT EXEC sp_OASetProperty @zip, 'ClearArchiveAttribute', @iValue` |
| `ClearReadOnlyAttr` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ClearReadOnlyAttr', @iValue OUT EXEC sp_OASetProperty @zip, 'ClearReadOnlyAttr', @iValue` |
| `Comment` | property, read/write | `EXEC sp_OAGetProperty @zip, 'Comment', @sValue OUT EXEC sp_OASetProperty @zip, 'Comment', @sValue` |
| `DecryptPassword` | property, read/write | `EXEC sp_OAGetProperty @zip, 'DecryptPassword', @sValue OUT EXEC sp_OASetProperty @zip, 'DecryptPassword', @sValue` |
| `DiscardPaths` | property, read/write | `EXEC sp_OAGetProperty @zip, 'DiscardPaths', @iValue OUT EXEC sp_OASetProperty @zip, 'DiscardPaths', @iValue` |
| `Encryption` | property, read/write | `EXEC sp_OAGetProperty @zip, 'Encryption', @iValue OUT EXEC sp_OASetProperty @zip, 'Encryption', @iValue` |
| `EncryptKeyLength` | property, read/write | `EXEC sp_OAGetProperty @zip, 'EncryptKeyLength', @iValue OUT EXEC sp_OASetProperty @zip, 'EncryptKeyLength', @iValue` |
| `EncryptPassword` | property, read/write | `EXEC sp_OAGetProperty @zip, 'EncryptPassword', @sValue OUT EXEC sp_OASetProperty @zip, 'EncryptPassword', @sValue` |
| `ExeDefaultDir` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeDefaultDir', @sValue OUT EXEC sp_OASetProperty @zip, 'ExeDefaultDir', @sValue` |
| `ExeFinishNotifier` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeFinishNotifier', @iValue OUT EXEC sp_OASetProperty @zip, 'ExeFinishNotifier', @iValue` |
| `ExeIconFile` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeIconFile', @sValue OUT EXEC sp_OASetProperty @zip, 'ExeIconFile', @sValue` |
| `ExeNoInterface` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeNoInterface', @iValue OUT EXEC sp_OASetProperty @zip, 'ExeNoInterface', @iValue` |
| `ExeSilentProgress` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeSilentProgress', @iValue OUT EXEC sp_OASetProperty @zip, 'ExeSilentProgress', @iValue` |
| `ExeTitle` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeTitle', @sValue OUT EXEC sp_OASetProperty @zip, 'ExeTitle', @sValue` |
| `ExeUnzipCaption` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeUnzipCaption', @sValue OUT EXEC sp_OASetProperty @zip, 'ExeUnzipCaption', @sValue` |
| `ExeUnzipDir` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeUnzipDir', @sValue OUT EXEC sp_OASetProperty @zip, 'ExeUnzipDir', @sValue` |
| `ExeWaitForSetup` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeWaitForSetup', @iValue OUT EXEC sp_OASetProperty @zip, 'ExeWaitForSetup', @iValue` |
| `ExeXmlConfig` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ExeXmlConfig', @sValue OUT EXEC sp_OASetProperty @zip, 'ExeXmlConfig', @sValue` |
| `FileCount` | property, read-only | `EXEC sp_OAGetProperty @zip, 'FileCount', @iValue OUT` |
| `FileName` | property, read/write | `EXEC sp_OAGetProperty @zip, 'FileName', @sValue OUT EXEC sp_OASetProperty @zip, 'FileName', @sValue` |
| `HasZipFormatErrors` | property, read-only | `EXEC sp_OAGetProperty @zip, 'HasZipFormatErrors', @iValue OUT` |
| `IgnoreAccessDenied` | property, read/write | `EXEC sp_OAGetProperty @zip, 'IgnoreAccessDenied', @iValue OUT EXEC sp_OASetProperty @zip, 'IgnoreAccessDenied', @iValue` |
| `MaxDate` | property, read/write | `EXEC sp_OAGetProperty @zip, 'MaxDate', @sValue OUT EXEC sp_OASetProperty @zip, 'MaxDate', @sValue` |
| `MaxUncompressSize` | property, read/write | `EXEC sp_OAGetProperty @zip, 'MaxUncompressSize', @iValue OUT EXEC sp_OASetProperty @zip, 'MaxUncompressSize', @iValue` |
| `MinDate` | property, read/write | `EXEC sp_OAGetProperty @zip, 'MinDate', @sValue OUT EXEC sp_OASetProperty @zip, 'MinDate', @sValue` |
| `NumEntries` | property, read-only | `EXEC sp_OAGetProperty @zip, 'NumEntries', @iValue OUT` |
| `OemCodePage` | property, read/write | `EXEC sp_OAGetProperty @zip, 'OemCodePage', @iValue OUT EXEC sp_OASetProperty @zip, 'OemCodePage', @iValue` |
| `OverwriteExisting` | property, read/write | `EXEC sp_OAGetProperty @zip, 'OverwriteExisting', @iValue OUT EXEC sp_OASetProperty @zip, 'OverwriteExisting', @iValue` |
| `PasswordProtect` | property, read/write | `EXEC sp_OAGetProperty @zip, 'PasswordProtect', @iValue OUT EXEC sp_OASetProperty @zip, 'PasswordProtect', @iValue` |
| `PathPrefix` | property, read/write | `EXEC sp_OAGetProperty @zip, 'PathPrefix', @sValue OUT EXEC sp_OASetProperty @zip, 'PathPrefix', @sValue` |
| `PwdProtCharset` | property, read/write | `EXEC sp_OAGetProperty @zip, 'PwdProtCharset', @sValue OUT EXEC sp_OASetProperty @zip, 'PwdProtCharset', @sValue` |
| `TempDir` | property, read/write | `EXEC sp_OAGetProperty @zip, 'TempDir', @sValue OUT EXEC sp_OASetProperty @zip, 'TempDir', @sValue` |
| `UncommonOptions` | property, read/write | `EXEC sp_OAGetProperty @zip, 'UncommonOptions', @sValue OUT EXEC sp_OASetProperty @zip, 'UncommonOptions', @sValue` |
| `Zipx` | property, read/write | `EXEC sp_OAGetProperty @zip, 'Zipx', @iValue OUT EXEC sp_OASetProperty @zip, 'Zipx', @iValue` |
| `ZipxDefaultAlg` | property, read/write | `EXEC sp_OAGetProperty @zip, 'ZipxDefaultAlg', @sValue OUT EXEC sp_OASetProperty @zip, 'ZipxDefaultAlg', @sValue` |
| `AddBd` | method | `EXEC sp_OAMethod @zip, 'AddBd', @success OUT, @pathInZip, @bd` |
| `AddEmpty` | method | `EXEC sp_OAMethod @zip, 'AddEmpty', @success OUT, @isDir, @pathInZip` |
| `AddEncoded` | method | `EXEC sp_OAMethod @zip, 'AddEncoded', @success OUT, @pathInZip, @encoding, @data` |
| `AddFile` | method | `EXEC sp_OAMethod @zip, 'AddFile', @success OUT, @localPath, @saveExtraPath` |
| `AddNoCompressExtension` | method | `EXEC sp_OAMethod @zip, 'AddNoCompressExtension', NULL, @fileExtension` |
| `AddSb` | method | `EXEC sp_OAMethod @zip, 'AddSb', @success OUT, @pathInZip, @sb, @charset` |
| `AddString` | method | `EXEC sp_OAMethod @zip, 'AddString', @success OUT, @pathInZip, @content, @charset` |
| `AppendFiles` | method | `EXEC sp_OAMethod @zip, 'AppendFiles', @success OUT, @filePattern, @recurse` |
| `AppendFilesEx` | method | `EXEC sp_OAMethod @zip, 'AppendFilesEx', @success OUT, @filePattern, @recurse, @saveExtraPath, @archiveOnly, @includeHidden, @includeSystem` |
| `AppendZip` | method | `EXEC sp_OAMethod @zip, 'AppendZip', @success OUT, @zipPath` |
| `CloseZip` | method | `EXEC sp_OAMethod @zip, 'CloseZip', NULL` |
| `DeleteEntry` | method | `EXEC sp_OAMethod @zip, 'DeleteEntry', @success OUT, @entry` |
| `EntryAt` | method | `EXEC sp_OAMethod @zip, 'EntryAt', @success OUT, @index, @entry` |
| `EntryById` | method | `EXEC sp_OAMethod @zip, 'EntryById', @success OUT, @id, @entry` |
| `EntryMatching` | method | `EXEC sp_OAMethod @zip, 'EntryMatching', @success OUT, @pattern, @entry` |
| `EntryOf` | method | `EXEC sp_OAMethod @zip, 'EntryOf', @success OUT, @pathInZip, @entry` |
| `ExcludeDir` | method | `EXEC sp_OAMethod @zip, 'ExcludeDir', NULL, @dirName` |
| `ExtractExe` | method | `EXEC sp_OAMethod @zip, 'ExtractExe', @success OUT, @exePath, @dirPath` |
| `GetDirectoryAsXML` | method | `EXEC sp_OAMethod @zip, 'GetDirectoryAsXML', @sResult OUT` |
| `GetExeConfigParam` | method | `EXEC sp_OAMethod @zip, 'GetExeConfigParam', @sResult OUT, @name` |
| `GetMaxUncompressedSize` | method | `EXEC sp_OAMethod @zip, 'GetMaxUncompressedSize', @sResult OUT` |
| `IsNoCompressExtension` | method | `EXEC sp_OAMethod @zip, 'IsNoCompressExtension', @success OUT, @fileExtension` |
| `IsPasswordProtected` | method | `EXEC sp_OAMethod @zip, 'IsPasswordProtected', @success OUT, @zipPath` |
| `NewZip` | method | `EXEC sp_OAMethod @zip, 'NewZip', @success OUT, @zipPath` |
| `OpenBd` | method | `EXEC sp_OAMethod @zip, 'OpenBd', @success OUT, @binData` |
| `OpenEmbedded` | method | `EXEC sp_OAMethod @zip, 'OpenEmbedded', @success OUT, @exeFilename, @resourceName` |
| `OpenZip` | method | `EXEC sp_OAMethod @zip, 'OpenZip', @success OUT, @zipPath` |
| `QuickAppend` | method | `EXEC sp_OAMethod @zip, 'QuickAppend', @success OUT, @zipPath` |
| `RemoveNoCompressExtension` | method | `EXEC sp_OAMethod @zip, 'RemoveNoCompressExtension', NULL, @fileExtension` |
| `SetCompressionLevel` | method | `EXEC sp_OAMethod @zip, 'SetCompressionLevel', NULL, @level` |
| `SetExclusions` | method | `EXEC sp_OAMethod @zip, 'SetExclusions', NULL, @excludePatterns` |
| `SetExeConfigParam` | method | `EXEC sp_OAMethod @zip, 'SetExeConfigParam', NULL, @paramName, @paramValue` |
| `Unzip` | method | `EXEC sp_OAMethod @zip, 'Unzip', @iResult OUT, @dirPath` |
| `UnzipInto` | method | `EXEC sp_OAMethod @zip, 'UnzipInto', @iResult OUT, @dirPath` |
| `UnzipMatching` | method | `EXEC sp_OAMethod @zip, 'UnzipMatching', @iResult OUT, @dirPath, @pattern, @verbose` |
| `UnzipMatchingInto` | method | `EXEC sp_OAMethod @zip, 'UnzipMatchingInto', @iResult OUT, @dirPath, @pattern, @verbose` |
| `UnzipNewer` | method | `EXEC sp_OAMethod @zip, 'UnzipNewer', @iResult OUT, @dirPath` |
| `VerifyPassword` | method | `EXEC sp_OAMethod @zip, 'VerifyPassword', @success OUT` |
| `WriteBd` | method | `EXEC sp_OAMethod @zip, 'WriteBd', @success OUT, @binData` |
| `WriteExe` | method | `EXEC sp_OAMethod @zip, 'WriteExe', @success OUT, @exeFilename` |
| `WriteZip` | method | `EXEC sp_OAMethod @zip, 'WriteZip', @success OUT` |
| `WriteZipAndClose` | method | `EXEC sp_OAMethod @zip, 'WriteZipAndClose', @success OUT` |

Deprecated members are listed at the end of this file with their replacements; do not use them in new code.

## Properties

### Zip.AbortCurrent

`Chilkat 11.7.0 · sqlserver · Zip · AbortCurrent · property · read/write · since 9.5.0.58`

```sql
EXEC sp_OAGetProperty @zip, 'AbortCurrent', @iValue OUT
EXEC sp_OASetProperty @zip, 'AbortCurrent', @iValue
```

Stops the currently executing operation when set to `1`.

- Used to cancel long-running operations such as compression or extraction.
- Can be triggered from another thread.
- Automatically resets to `0` after the operation stops.

### Zip.AppendFromDir

`Chilkat 11.7.0 · sqlserver · Zip · AppendFromDir · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'AppendFromDir', @sValue OUT
EXEC sp_OASetProperty @zip, 'AppendFromDir', @sValue
```

Specifies a base directory when adding files to the ZIP.

- This portion of the path is **not included** in stored ZIP entry paths.
- Useful for controlling relative paths inside the archive.

For example, to add all files under `c:/abc/123/myAppDir`, this property could be set to `c:/abc/123`, and `myAppDir/*` would be passed to `AppendFiles`.

The path stored in the ZIP would begin with `myAppDir/`.

### Zip.AutoRun

`Chilkat 11.7.0 · sqlserver · Zip · AutoRun · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'AutoRun', @sValue OUT
EXEC sp_OASetProperty @zip, 'AutoRun', @sValue
```

`(Windows only, for creating self-extracting EXE's)`

Specifies the name of an executable inside a self-extracting EXE that runs automatically after extraction.

### Zip.AutoRunParams

`Chilkat 11.7.0 · sqlserver · Zip · AutoRunParams · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'AutoRunParams', @sValue OUT
EXEC sp_OASetProperty @zip, 'AutoRunParams', @sValue
```

`(Windows only, for creating self-extracting EXE's)`

Command-line arguments passed to the `AutoRun` executable.

### Zip.AutoTemp

`Chilkat 11.7.0 · sqlserver · Zip · AutoTemp · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'AutoTemp', @iValue OUT
EXEC sp_OASetProperty @zip, 'AutoTemp', @iValue
```

`(Windows only, for creating self-extracting EXE's)`

If `1`, the EXE being created will automatically select and create a temporary directory for unzipping.

This property is often used together with `AutoRun` to create a self-extracting EXE that automatically unzips to a temporary directory and runs a setup program, such as `setup.exe`, without user interaction.

**Note:** To create a self-extracting EXE with no user interaction, set the following properties:

> `ExeSilentProgress = 0`  
> `ExeNoInterface = 1`  
> `ExeFinishNotifier = 0`

The default value is `0`.

### Zip.CaseSensitive

`Chilkat 11.7.0 · sqlserver · Zip · CaseSensitive · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'CaseSensitive', @iValue OUT
EXEC sp_OASetProperty @zip, 'CaseSensitive', @iValue
```

Controls whether filename matching is case-sensitive.

- Affects methods such as `EntryMatching` and `UnzipMatching`.
- Default: `0`

### Zip.ClearArchiveAttribute

`Chilkat 11.7.0 · sqlserver · Zip · ClearArchiveAttribute · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ClearArchiveAttribute', @iValue OUT
EXEC sp_OASetProperty @zip, 'ClearArchiveAttribute', @iValue
```

`(Windows only)`

If `1`, clears the Windows archive attribute after files are successfully added to the ZIP.

The archive attribute indicates that a file has changed since the last backup.

The default value is `0`.

### Zip.ClearReadOnlyAttr

`Chilkat 11.7.0 · sqlserver · Zip · ClearReadOnlyAttr · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ClearReadOnlyAttr', @iValue OUT
EXEC sp_OASetProperty @zip, 'ClearReadOnlyAttr', @iValue
```

If `1`, removes the read-only attribute from extracted files.

If `0`, the read-only attribute remains unchanged.

The default value is `0`.

### Zip.Comment

`Chilkat 11.7.0 · sqlserver · Zip · Comment · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'Comment', @sValue OUT
EXEC sp_OASetProperty @zip, 'Comment', @sValue
```

Sets or retrieves the global ZIP file comment.

The default value is the empty string.

### Zip.DecryptPassword

`Chilkat 11.7.0 · sqlserver · Zip · DecryptPassword · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'DecryptPassword', @sValue OUT
EXEC sp_OASetProperty @zip, 'DecryptPassword', @sValue
```

Password used to extract encrypted ZIP archives.

- Required to unzip encrypted entries.
- Encrypted ZIP files may still be opened without a password, but their contents cannot be extracted until the correct password is provided.

The default value is the empty string.

### Zip.DiscardPaths

`Chilkat 11.7.0 · sqlserver · Zip · DiscardPaths · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'DiscardPaths', @iValue OUT
EXEC sp_OASetProperty @zip, 'DiscardPaths', @iValue
```

If `1`, removes all directory path information when adding files.

Only filenames are stored in the ZIP.

The default value is `0`.

### Zip.Encryption

`Chilkat 11.7.0 · sqlserver · Zip · Encryption · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'Encryption', @iValue OUT
EXEC sp_OASetProperty @zip, 'Encryption', @iValue
```

Specifies encryption mode:

- `0` → No encryption
- `4` → WinZip-compatible AES encryption

**Important:** `Encryption` and `PasswordProtect` are mutually exclusive.

If `PasswordProtect = 1`, then `Encryption` should be `0`.

The default value is `0`.

### Zip.EncryptKeyLength

`Chilkat 11.7.0 · sqlserver · Zip · EncryptKeyLength · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'EncryptKeyLength', @iValue OUT
EXEC sp_OASetProperty @zip, 'EncryptKeyLength', @iValue
```

Specifies the AES encryption key length.

- Valid values: `128`, `192`, or `256`

The default value is `128`.

### Zip.EncryptPassword

`Chilkat 11.7.0 · sqlserver · Zip · EncryptPassword · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'EncryptPassword', @sValue OUT
EXEC sp_OASetProperty @zip, 'EncryptPassword', @sValue
```

Password used when creating encrypted ZIP archives.

The default value is the empty string.

### Zip.ExeDefaultDir

`Chilkat 11.7.0 · sqlserver · Zip · ExeDefaultDir · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeDefaultDir', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeDefaultDir', @sValue
```

`(Windows only, for creating self-extracting EXE's)`

Default extraction directory shown in the self-extracting EXE user interface.

The default value is the empty string.

### Zip.ExeFinishNotifier

`Chilkat 11.7.0 · sqlserver · Zip · ExeFinishNotifier · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeFinishNotifier', @iValue OUT
EXEC sp_OASetProperty @zip, 'ExeFinishNotifier', @iValue
```

`(Windows only, for creating self-extracting EXE's)`

If `1`, displays a completion dialog after extraction finishes.

The default value is `0`.

### Zip.ExeIconFile

`Chilkat 11.7.0 · sqlserver · Zip · ExeIconFile · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeIconFile', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeIconFile', @sValue
```

`(Windows only, for creating self-extracting EXE's)`

Path to an `.ico` file used as the EXE icon.

This feature is only available when the application creating the EXE is 32-bit.

The default value is the empty string.

### Zip.ExeNoInterface

`Chilkat 11.7.0 · sqlserver · Zip · ExeNoInterface · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeNoInterface', @iValue OUT
EXEC sp_OASetProperty @zip, 'ExeNoInterface', @iValue
```

`(Windows only, for creating self-extracting EXE's)`

If `1`, runs the self-extracting EXE without displaying the main user interface.

The default value is `0`.

### Zip.ExeSilentProgress

`Chilkat 11.7.0 · sqlserver · Zip · ExeSilentProgress · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeSilentProgress', @iValue OUT
EXEC sp_OASetProperty @zip, 'ExeSilentProgress', @iValue
```

`(Windows only, for creating self-extracting EXE's)`

Controls whether a progress dialog is shown during extraction.

If `ExeNoInterface = 0`, the progress bar appears within the main dialog and this property has no effect.

The default value is `0`.

### Zip.ExeTitle

`Chilkat 11.7.0 · sqlserver · Zip · ExeTitle · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeTitle', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeTitle', @sValue
```

`(Windows only, for creating self-extracting EXE's)`

Title displayed in the self-extracting EXE dialog.

The default value is the empty string.

### Zip.ExeUnzipCaption

`Chilkat 11.7.0 · sqlserver · Zip · ExeUnzipCaption · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeUnzipCaption', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeUnzipCaption', @sValue
```

`(Windows only, for creating self-extracting EXE's)`

Caption text displayed in the self-extracting EXE dialog.

The default value is the empty string.

### Zip.ExeUnzipDir

`Chilkat 11.7.0 · sqlserver · Zip · ExeUnzipDir · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeUnzipDir', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeUnzipDir', @sValue
```

`(Windows only, for creating self-extracting EXE's)`

Specifies a predefined extraction directory.

- Supports environment variables such as `%TEMP%`.
- UNC paths are not supported.

The default value is the empty string.

### Zip.ExeWaitForSetup

`Chilkat 11.7.0 · sqlserver · Zip · ExeWaitForSetup · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeWaitForSetup', @iValue OUT
EXEC sp_OASetProperty @zip, 'ExeWaitForSetup', @iValue
```

If `1`, waits for the AutoRun executable to finish before exiting.

If `0`, the self-extracting EXE may exit before the AutoRun executable completes.

The default value is `1`.

### Zip.ExeXmlConfig

`Chilkat 11.7.0 · sqlserver · Zip · ExeXmlConfig · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ExeXmlConfig', @sValue OUT
EXEC sp_OASetProperty @zip, 'ExeXmlConfig', @sValue
```

Allows for an XML config document to be used to specify all possible options for self-extracting EXEs. This property is a string containing the XML config document.

The XML should have this format:

\<SfxConfig>

\<ErrPwdTitle>Title for incorrect password dialog\</ErrPwdTitle>

\<ErrPwdCaption>Caption for incorrect password dialog\</ErrPwdCaption>

\<FinOkBtn>Text on finish notifier button\</FinOkBtn>

\<PwdOkBtn>Text on password challenge dialog's "OK" button.\</PwdOkBtn>

\<PwdCancelBtn>Text on password challenge dialog's Cancel button.\</PwdCancelBtn>

\<ErrInvalidPassword>Incorrect password error message.\</ErrInvalidPassword>

\<MainUnzipBtn>Text on main dialog's unzip button. **Note:** The `MainUnzipLabel` must also be set for this to take effect.\</MainUnzipBtn>

\<MainCloseBtn>Text on main dialog's quit/exit button. **Note:** The `MainUnzipLabel` must also be set for this to take effect.\</MainCloseBtn>

\<MainBrowseBtn>Text on main dialog's browse-for-directory button. **Note:** The `MainUnzipLabel` must also be set for this to take effect.\</MainBrowseBtn>

\<MainUnzipLabel>Caption displayed in main dialog.\</MainUnzipLabel>

\<AutoTemp>0 or 1 (Maps to the `AutoTemp` property)\</AutoTemp>

\<Cleanup>0 or 1 (If 1, extracted files are deleted after the `SetupExe` is run.)\</Cleanup>

\<Debug>0 or 1 (If 1, the EXE will not extract any files.)\</Debug>

\<Verbose>0 or 1 (If 1, verbose information is written to the log.)\</Verbose>

\<ShowFin>0 or 1 (Maps to the `ExeFinishNotifier` property)\</ShowFin>

\<ShowMain>0 or 1 (Maps to the `ExeNoInterface` property)\</ShowMain>

\<ShowProgress>0 or 1 (Maps to the `ExeSilentProgress` property)\</ShowProgress>

\<WaitForSetup>0 or 1 (Maps to the `ExeWaitForSetup` property)\</WaitForSetup>

\<Encryption>0 or 1 (1 = Yes, 0 = No)\</Encryption>

\<KeyLength>128\|192\|256\</KeyLength>

\<SetupExe>EXE to run after extracting. (Maps to the `AutoRun` property)\</SetupExe>

\<UnzipDir>Pre-defined unzip directory. (Maps to the `ExeUnzipDir` property. UNC paths, such as \\\\servername\\path, are not supported.)\</UnzipDir>

\<DefaultDir>Default unzip directory to appear in the main dialog. (Maps to the `ExeDefaultDir` property)\</DefaultDir>

\<IconFile>Icon file to be used (Maps to the `ExeIconFile` property)\</IconFile>

\<MainTitle>Maps to the `ExeTitle` property.\</MainTitle>

\<MainCaption>Maps to the `ExeUnzipCaption` property.\</MainCaption>

\<FinTitle>Title for the finish notifier dialog.\</FinTitle>

\<FinCaption>Caption for the finish notifier dialog.\</FinCaption>

\<ProgressTitle>Title for the progress dialog.\</ProgressTitle>

\<ProgressCaption>Caption for the progress dialog.\</ProgressCaption>

\<PwTitle>Title for the password challenge dialog.\</PwTitle>

\<PwCaption>Caption for the password challenge dialog.\</PwCaption>

\</SfxConfig>

A self-extracting EXE can be run from the command line with the `-log {logFilePath}` option to create a log with information for debugging.

### Zip.FileCount

`Chilkat 11.7.0 · sqlserver · Zip · FileCount · property · read-only`

```sql
EXEC sp_OAGetProperty @zip, 'FileCount', @iValue OUT
```

Number of files in the ZIP, excluding directory entries.

### Zip.FileName

`Chilkat 11.7.0 · sqlserver · Zip · FileName · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'FileName', @sValue OUT
EXEC sp_OASetProperty @zip, 'FileName', @sValue
```

Path of the ZIP file to be written or overwritten.

The default value is the empty string.

### Zip.HasZipFormatErrors

`Chilkat 11.7.0 · sqlserver · Zip · HasZipFormatErrors · property · read-only`

```sql
EXEC sp_OAGetProperty @zip, 'HasZipFormatErrors', @iValue OUT
```

Indicates whether minor ZIP format problems were detected when opening the ZIP archive.

### Zip.IgnoreAccessDenied

`Chilkat 11.7.0 · sqlserver · Zip · IgnoreAccessDenied · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'IgnoreAccessDenied', @iValue OUT
EXEC sp_OASetProperty @zip, 'IgnoreAccessDenied', @iValue
```

If `1`, files that cannot be read, written, or created due to filesystem permission errors are skipped.

If `0`, any access-denied error causes the ZIP operation to fail.

The default value is `1`.

### Zip.MaxDate

`Chilkat 11.7.0 · sqlserver · Zip · MaxDate · property · read/write · since 10.0.0`

```sql
EXEC sp_OAGetProperty @zip, 'MaxDate', @sValue OUT
EXEC sp_OASetProperty @zip, 'MaxDate', @sValue
```

Maximum last-modified timestamp for files processed during add or extract operations.

Files having modification timestamps later than this value are skipped.

Supports ISO 8601 date/time formats, including:

- `YYYY-MM-DD`  
  Example: `2024-07-31`
- `YYYY-MM-DDTHH:MM:SS±HH:MM`  
  Example: `2024-07-31T12:34:56+02:00`
- `YYYY-MM-DDTHH:MM:SSZ`  
  Example: `2024-07-31T12:34:56Z`

The default value is the empty string, meaning no maximum date restriction.

### Zip.MaxUncompressSize

`Chilkat 11.7.0 · sqlserver · Zip · MaxUncompressSize · property · read/write · since 9.5.0.96`

```sql
EXEC sp_OAGetProperty @zip, 'MaxUncompressSize', @iValue OUT
EXEC sp_OASetProperty @zip, 'MaxUncompressSize', @iValue
```

Prevents extraction of files larger than the specified uncompressed size.

A value of `0` means no size limit.

The default value is `0`.

### Zip.MinDate

`Chilkat 11.7.0 · sqlserver · Zip · MinDate · property · read/write · since 10.0.0`

```sql
EXEC sp_OAGetProperty @zip, 'MinDate', @sValue OUT
EXEC sp_OASetProperty @zip, 'MinDate', @sValue
```

Minimum last-modified timestamp for files processed during add or extract operations.

Supports ISO 8601 date/time formats, including:

- `YYYY-MM-DD`  
  Example: `2024-07-31`
- `YYYY-MM-DDTHH:MM:SS±HH:MM`  
  Example: `2024-07-31T12:34:56+02:00`
- `YYYY-MM-DDTHH:MM:SSZ`  
  Example: `2024-07-31T12:34:56Z`

The default value is the empty string, meaning no minimum date restriction.

### Zip.NumEntries

`Chilkat 11.7.0 · sqlserver · Zip · NumEntries · property · read-only`

```sql
EXEC sp_OAGetProperty @zip, 'NumEntries', @iValue OUT
```

Total number of entries in the ZIP, including both files and directories.

### Zip.OemCodePage

`Chilkat 11.7.0 · sqlserver · Zip · OemCodePage · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'OemCodePage', @iValue OUT
EXEC sp_OASetProperty @zip, 'OemCodePage', @iValue
```

Specifies the OEM code page used for ZIP filename encoding.

Defaults to the OEM code page of the current computer.

### Zip.OverwriteExisting

`Chilkat 11.7.0 · sqlserver · Zip · OverwriteExisting · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'OverwriteExisting', @iValue OUT
EXEC sp_OASetProperty @zip, 'OverwriteExisting', @iValue
```

If `1`, existing files are overwritten during extraction.

The default value is `1`.

### Zip.PasswordProtect

`Chilkat 11.7.0 · sqlserver · Zip · PasswordProtect · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'PasswordProtect', @iValue OUT
EXEC sp_OASetProperty @zip, 'PasswordProtect', @iValue
```

Indicates whether the ZIP uses legacy Zip 2.0 password protection.

This property is set automatically when a ZIP archive is opened by any of the `Open*` methods, such as `OpenZip`, `OpenFromMemory`, `OpenBd`, and related methods.

**Important:** `PasswordProtect` and `Encryption` are mutually exclusive.

If `PasswordProtect = 1`, then `Encryption` should be `0`.

The default value is `0`.

### Zip.PathPrefix

`Chilkat 11.7.0 · sqlserver · Zip · PathPrefix · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'PathPrefix', @sValue OUT
EXEC sp_OASetProperty @zip, 'PathPrefix', @sValue
```

Gets or sets a path prefix that is prepended to ZIP entry paths for files appended from the local filesystem.

This is useful when you want all extracted files to appear under a specific subdirectory.

This property affects only the following methods:

- `AppendFiles`
- `AppendFilesEx`
- `AddFile`
- `AppendOneFileOrDir`

The `PathPrefix` value is prepended to the stored ZIP path for each appended filesystem file.

For example, set PathPrefix to subdir/ so that files are stored in the ZIP with subdir/ prepended to their paths. When extracted, the files will be placed under the subdir directory.

This property does not affect entries added entirely from memory, such as entries added using:

- `AddString`
- `AddData`
- `AddBd`
- `AddSb`

For in-memory entries, the ZIP entry path is determined solely by the filename/path argument passed to the method.

The default value is the empty string.

### Zip.PwdProtCharset

`Chilkat 11.7.0 · sqlserver · Zip · PwdProtCharset · property · read/write · since 9.5.0.73`

```sql
EXEC sp_OAGetProperty @zip, 'PwdProtCharset', @sValue OUT
EXEC sp_OASetProperty @zip, 'PwdProtCharset', @sValue
```

Specifies the character encoding used to convert the decrypt password into its binary byte representation for legacy password-protected ZIP archives that use Zip 2.0 encryption.

The default value is `ansi`.

Other possible values include:

- `cp850`
- `cp437`
- Any supported Windows or OEM code page listed at the link below.

This property applies only to older Zip 2.0 password protection and is not used for AES-encrypted ZIP archives.

### Zip.TempDir

`Chilkat 11.7.0 · sqlserver · Zip · TempDir · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'TempDir', @sValue OUT
EXEC sp_OASetProperty @zip, 'TempDir', @sValue
```

Directory used for temporary files during ZIP operations.

When overwriting an existing ZIP file, a temporary file is used to avoid corrupting the original ZIP if an error occurs.

The default value depends on the runtime environment.

### Zip.UncommonOptions

`Chilkat 11.7.0 · sqlserver · Zip · UncommonOptions · property · read/write · since 9.5.0.84`

```sql
EXEC sp_OAGetProperty @zip, 'UncommonOptions', @sValue OUT
EXEC sp_OASetProperty @zip, 'UncommonOptions', @sValue
```

Advanced options for uncommon scenarios.

- `ForceZip64` → Forces ZIP64 format even when not required.

The default value is the empty string.

### Zip.Zipx

`Chilkat 11.7.0 · sqlserver · Zip · Zipx · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'Zipx', @iValue OUT
EXEC sp_OASetProperty @zip, 'Zipx', @iValue
```

If `1`, creates ZIPX archives using the most appropriate compression method for each file.

The default value is `0`.

### Zip.ZipxDefaultAlg

`Chilkat 11.7.0 · sqlserver · Zip · ZipxDefaultAlg · property · read/write`

```sql
EXEC sp_OAGetProperty @zip, 'ZipxDefaultAlg', @sValue OUT
EXEC sp_OASetProperty @zip, 'ZipxDefaultAlg', @sValue
```

Default compression algorithm used when creating ZIPX archives.

- Possible values include:
  - `deflate`
  - `ppmd`
  - `lzma`
  - `bzip2`
  - `deflate64`

The default value is `deflate`.

## Methods

### Zip.AddBd

`Chilkat 11.7.0 · sqlserver · Zip · AddBd · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'AddBd', @success OUT, @pathInZip, @bd
```

Adds the contents of a `BinData` object as a new entry in the ZIP archive.

- `pathInZip` specifies the filename and optional directory path stored within the ZIP.
- The bytes contained in `bd` become the contents of the ZIP entry.
- The entry is added to the in-memory ZIP object and is not written to disk until `WriteZip`, `WriteZipAndClose`, `WriteBd`, or `WriteToMemory` is called.

Returns 1 for success, 0 for failure.

### Zip.AddEmpty

`Chilkat 11.7.0 · sqlserver · Zip · AddEmpty · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'AddEmpty', @success OUT, @isDir, @pathInZip
```

Adds an empty file or directory entry to the ZIP archive.

- If `isDir = 1`, an empty directory entry is created.
- If `isDir = 0`, an empty file entry is created.
- `pathInZip` specifies the path stored in the ZIP archive.

This method is useful when directory structure entries must exist even if no files are present.

Returns 1 for success, 0 for failure.

### Zip.AddEncoded

`Chilkat 11.7.0 · sqlserver · Zip · AddEncoded · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'AddEncoded', @success OUT, @pathInZip, @encoding, @data
```

Adds encoded binary data as a ZIP entry.

- `encoding` specifies how `data` is encoded.
- Common encodings include `base64` and `hex`.
- The decoded binary bytes become the contents of the ZIP entry.

This method is useful when binary data already exists in textual encoded form.

Returns 1 for success, 0 for failure.

### Zip.AddFile

`Chilkat 11.7.0 · sqlserver · Zip · AddFile · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'AddFile', @success OUT, @localPath, @saveExtraPath
```

Adds a file or directory from the local filesystem to the ZIP archive.

- If `localPath` is an absolute path and `saveExtraPath = 1`, the stored ZIP path includes the relative directory structure.
- If `saveExtraPath = 0`, only the filename is stored.
- If `localPath` is already relative, the relative path is stored as-is regardless of `saveExtraPath`.

This method adds a reference to the file or directory in the local filesystem. The file data is not immediately read or compressed.

The actual file contents are consumed only when a `Write*` method is called, such as:

- `WriteZip`
- `WriteZipAndClose`
- `WriteBd`
- `WriteToMemory`

This allows files and data entries to be accumulated in the in-memory ZIP object prior to writing the final ZIP archive.

Returns 1 for success, 0 for failure.

### Zip.AddNoCompressExtension

`Chilkat 11.7.0 · sqlserver · Zip · AddNoCompressExtension · method`

```sql
EXEC sp_OAMethod @zip, 'AddNoCompressExtension', NULL, @fileExtension
```

Adds a file extension to the internal "no-compression" list.

Files having these extensions are stored without compression because they are already compressed or because compression would provide little benefit.

For example:

- `.zip`
- `.jpg`
- `.png`
- `.gz`

The extension may be specified with or without the leading dot.

Additional extensions remain active for the lifetime of the Zip object unless removed with `RemoveNoCompressExtension`.

### Zip.AddSb

`Chilkat 11.7.0 · sqlserver · Zip · AddSb · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'AddSb', @success OUT, @pathInZip, @sb, @charset
```

Adds the contents of a `StringBuilder` object as a text entry in the ZIP archive.

- The text is converted to bytes using the specified `charset`.
- `pathInZip` specifies the filename stored in the ZIP.

Returns 1 for success, 0 for failure.

### Zip.AddString

`Chilkat 11.7.0 · sqlserver · Zip · AddString · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'AddString', @success OUT, @pathInZip, @content, @charset
```

Adds a string as a text file entry in the ZIP archive.

- The string is converted to bytes using the specified `charset`.
- `pathInZip` specifies the path stored within the ZIP archive.

This method is useful for dynamically generating text files directly in memory.

Returns 1 for success, 0 for failure.

### Zip.AppendFiles

`Chilkat 11.7.0 · sqlserver · Zip · AppendFiles · method`

```sql
EXEC sp_OAMethod @zip, 'AppendFiles', @success OUT, @filePattern, @recurse
```

Adds one or more files matching a wildcard pattern.

- The wildcard character `*` matches zero or more characters.
- If `recurse = 1`, subdirectories are processed recursively.
- If `recurse = 0`, only the current directory is searched.

For example:

> `AppendFiles("c:/temp/*.txt", 0)`

This method only updates the in-memory ZIP object. The ZIP file itself is not written until a `Write*` method is called.

Returns 1 for success, 0 for failure.

### Zip.AppendFilesEx

`Chilkat 11.7.0 · sqlserver · Zip · AppendFilesEx · method`

```sql
EXEC sp_OAMethod @zip, 'AppendFilesEx', @success OUT, @filePattern, @recurse, @saveExtraPath, @archiveOnly, @includeHidden, @includeSystem
```

Advanced version of `AppendFiles` with additional filtering and path options.

- `saveExtraPath` controls whether the extra leading path information from the `filePattern` is preserved in the ZIP.
- `archiveOnly` applies only on Windows and limits processing to files having the archive attribute set.
- `includeHidden` controls whether hidden files are included.
- `includeSystem` controls whether files with the System attribute are included.

This method adds references to files in the in-memory ZIP object. No ZIP file is written until a `Write*` method is called.

Returns 1 for success, 0 for failure.

### Zip.AppendZip

`Chilkat 11.7.0 · sqlserver · Zip · AppendZip · method`

```sql
EXEC sp_OAMethod @zip, 'AppendZip', @success OUT, @zipPath
```

**Note:** This method is currently not working and will be fixed in v11.5.0

Adds all entries from another existing ZIP archive into the current ZIP object.

The `zipPath` argument specifies the path of a ZIP file located in the local filesystem.

All entries from the specified ZIP archive are appended to the current in-memory ZIP object.

The ZIP archive itself is not rewritten until a `Write*` method is called.

This method is useful for merging the contents of multiple ZIP archives into a single ZIP.

Returns 1 for success, 0 for failure.

### Zip.CloseZip

`Chilkat 11.7.0 · sqlserver · Zip · CloseZip · method`

```sql
EXEC sp_OAMethod @zip, 'CloseZip', NULL
```

Closes the currently open ZIP archive and clears all entries from the Zip object.

This method has the same effect as calling `NewZip` without specifying a filename.

### Zip.DeleteEntry

`Chilkat 11.7.0 · sqlserver · Zip · DeleteEntry · method`

```sql
EXEC sp_OAMethod @zip, 'DeleteEntry', @success OUT, @entry
```

Removes a ZIP entry from the current ZIP object.

The ZIP file itself is not rewritten until a `Write*` method is called.

Returns 1 for success, 0 for failure.

### Zip.EntryAt

`Chilkat 11.7.0 · sqlserver · Zip · EntryAt · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'EntryAt', @success OUT, @index, @entry
```

Retrieves the ZIP entry at the specified zero-based index.

- The first entry is at index `0`.
- The matching entry is returned in the supplied `ZipEntry` object.

Returns 1 for success, 0 for failure.

### Zip.EntryById

`Chilkat 11.7.0 · sqlserver · Zip · EntryById · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'EntryById', @success OUT, @id, @entry
```

Finds a ZIP entry by its unique EntryID.

The matching entry is returned in the supplied `ZipEntry` object.

Returns 1 for success, 0 for failure.

### Zip.EntryMatching

`Chilkat 11.7.0 · sqlserver · Zip · EntryMatching · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'EntryMatching', @success OUT, @pattern, @entry
```

Finds the first ZIP entry whose stored path matches a wildcard pattern.

- The wildcard character `*` matches zero or more characters.
- The comparison is performed against the full stored ZIP path.

Returns 1 for success, 0 for failure.

### Zip.EntryOf

`Chilkat 11.7.0 · sqlserver · Zip · EntryOf · method · since 11.0.0`

```sql
EXEC sp_OAMethod @zip, 'EntryOf', @success OUT, @pathInZip, @entry
```

Finds a ZIP entry whose stored path exactly matches `pathInZip`.

The matching entry is returned in the supplied `ZipEntry` object.

Returns 1 for success, 0 for failure.

### Zip.ExcludeDir

`Chilkat 11.7.0 · sqlserver · Zip · ExcludeDir · method`

```sql
EXEC sp_OAMethod @zip, 'ExcludeDir', NULL, @dirName
```

Adds a directory name to the exclusion list used by recursive append operations.

- All directories having the specified name are skipped.
- The comparison is case-insensitive.
- Call multiple times to exclude multiple directory names.

This affects methods such as `AppendFiles` and `AppendFilesEx`.

### Zip.ExtractExe

`Chilkat 11.7.0 · sqlserver · Zip · ExtractExe · method · since 9.5.0.44`

```sql
EXEC sp_OAMethod @zip, 'ExtractExe', @success OUT, @exePath, @dirPath
```

Extracts files from a Chilkat-created self-extracting EXE.

- Files are extracted into `dirPath`.
- Subdirectories are automatically created as needed.
- If the EXE is encrypted, `DecryptPassword` must be set before extraction.

Returns 1 for success, 0 for failure.

### Zip.GetDirectoryAsXML

`Chilkat 11.7.0 · sqlserver · Zip · GetDirectoryAsXML · method`

```sql
EXEC sp_OAMethod @zip, 'GetDirectoryAsXML', @sResult OUT
```

Returns the ZIP directory structure as an XML document.

The returned XML contains information about the entries currently contained within the ZIP archive, including files and directories.

This method is useful for inspecting ZIP contents without extracting files.

Returns the XML document as a string.

Returns `NULL` on failure

### Zip.GetExeConfigParam

`Chilkat 11.7.0 · sqlserver · Zip · GetExeConfigParam · method`

```sql
EXEC sp_OAMethod @zip, 'GetExeConfigParam', @sResult OUT, @name
```

`(Windows only, for creating self-extracting EXE's)`

Returns the value of a configuration parameter embedded within a self-extracting EXE.

The `name` argument should be one of the XML tag names described in the `ExeXmlConfig` property documentation.

For example:

- `MainTitle`
- `MainCaption`
- `SetupExe`

Returns the parameter value as a string.

Returns `NULL` on failure

### Zip.GetMaxUncompressedSize

`Chilkat 11.7.0 · sqlserver · Zip · GetMaxUncompressedSize · method · since 9.5.0.96`

```sql
EXEC sp_OAMethod @zip, 'GetMaxUncompressedSize', @sResult OUT
```

Returns the largest uncompressed file size contained within the ZIP archive.

The size is returned as a string rather than an integer because the value may exceed the range of a 32-bit integer.

This method is useful when:

- Checking for extremely large files before extraction
- Estimating required disk space
- Detecting unusually large compressed entries

Returns the size as a decimal string.

Returns `NULL` on failure

### Zip.IsNoCompressExtension

`Chilkat 11.7.0 · sqlserver · Zip · IsNoCompressExtension · method`

```sql
EXEC sp_OAMethod @zip, 'IsNoCompressExtension', @success OUT, @fileExtension
```

Checks whether a file extension is contained in the internal "no-compression" extension list.

Files having extensions in this list are stored without compression because they are typically already compressed.

The extension may be specified with or without the leading dot.

For example, both of the following are valid:

- `.jpg`
- `jpg`

Returns `1` if the extension exists in the list, otherwise returns `0`.

### Zip.IsPasswordProtected

`Chilkat 11.7.0 · sqlserver · Zip · IsPasswordProtected · method`

```sql
EXEC sp_OAMethod @zip, 'IsPasswordProtected', @success OUT, @zipPath
```

Checks whether a ZIP archive uses legacy Zip 2.0 password protection.

The `zipPath` argument specifies the path of a ZIP file in the local filesystem.

This method checks only for traditional Zip 2.0 password protection.

Returns `1` if the ZIP archive is password protected, otherwise returns `0`.

### Zip.NewZip

`Chilkat 11.7.0 · sqlserver · Zip · NewZip · method`

```sql
EXEC sp_OAMethod @zip, 'NewZip', @success OUT, @zipPath
```

Initializes a new empty ZIP archive.

- If another ZIP archive is currently open, it is closed.
- All existing in-memory ZIP entries are discarded.
- The `FileName` property is set to `zipPath`.

No ZIP file is actually created until a `Write*` method is called.

This method resets the Zip object to a clean empty state.

Returns 1 for success, 0 for failure.

### Zip.OpenBd

`Chilkat 11.7.0 · sqlserver · Zip · OpenBd · method · since 9.5.0.66`

```sql
EXEC sp_OAMethod @zip, 'OpenBd', @success OUT, @binData
```

Opens a ZIP archive contained entirely within a `BinData` object.

This method allows ZIP archives to be processed entirely in memory without requiring a filesystem file.

When a ZIP archive is opened:

- `PasswordProtect` is automatically set if legacy Zip 2.0 encryption is detected.
- `Encryption` is automatically set if strong encryption is detected.
- A value of `4` for `Encryption` indicates WinZip-compatible AES encryption.

Returns 1 for success, 0 for failure.

### Zip.OpenEmbedded

`Chilkat 11.7.0 · sqlserver · Zip · OpenEmbedded · method`

```sql
EXEC sp_OAMethod @zip, 'OpenEmbedded', @success OUT, @exeFilename, @resourceName
```

`(Windows only)`

Opens a ZIP archive embedded as a resource within a Windows executable.

- `exeFilename` specifies the EXE file path.
- `resourceName` specifies the embedded resource name containing the ZIP data.

This method is useful when ZIP archives are packaged within Windows applications.

Returns 1 for success, 0 for failure.

### Zip.OpenZip

`Chilkat 11.7.0 · sqlserver · Zip · OpenZip · method`

```sql
EXEC sp_OAMethod @zip, 'OpenZip', @success OUT, @zipPath
```

Opens a ZIP archive from the local filesystem.

The `zipPath` argument specifies the path of the ZIP file to open.

Encrypted ZIP archives may be opened without providing a password, but encrypted entries cannot be extracted until the correct password is provided using `DecryptPassword`.

When the ZIP archive is opened:

- `PasswordProtect` is automatically set if legacy Zip 2.0 encryption is detected.
- `Encryption` is automatically set if strong encryption is detected.
- `Encryption = 4` indicates WinZip-compatible AES encryption.

Returns 1 for success, 0 for failure.

### Zip.QuickAppend

`Chilkat 11.7.0 · sqlserver · Zip · QuickAppend · method`

```sql
EXEC sp_OAMethod @zip, 'QuickAppend', @success OUT, @zipPath
```

Efficiently appends additional entries to an existing ZIP archive.

The `zipPath` argument specifies the path of an existing ZIP archive in the local filesystem.

This method avoids rewriting existing entries.

- Existing ZIP entries remain unchanged.
- New entries are appended to the end of the ZIP archive.
- The ZIP central directory is updated accordingly.

This method is typically faster than rebuilding the entire ZIP archive.

Returns 1 for success, 0 for failure.

### Zip.RemoveNoCompressExtension

`Chilkat 11.7.0 · sqlserver · Zip · RemoveNoCompressExtension · method`

```sql
EXEC sp_OAMethod @zip, 'RemoveNoCompressExtension', NULL, @fileExtension
```

Removes a file extension from the internal "no-compression" extension list.

After removal, files having this extension may be compressed normally.

The extension may be specified with or without the leading dot.

### Zip.SetCompressionLevel

`Chilkat 11.7.0 · sqlserver · Zip · SetCompressionLevel · method`

```sql
EXEC sp_OAMethod @zip, 'SetCompressionLevel', NULL, @level
```

Sets the compression level for all file and data entries currently contained within the ZIP object.

- `0` → No compression
- `9` → Maximum compression

The default compression level is `6`.

**Important:** This method should be called after files or data entries have already been added to the ZIP object.

The compression level cannot be changed for mapped entries originating from an already-open ZIP archive.

### Zip.SetExclusions

`Chilkat 11.7.0 · sqlserver · Zip · SetExclusions · method`

```sql
EXEC sp_OAMethod @zip, 'SetExclusions', NULL, @excludePatterns
```

Specifies a collection of wildcard exclusion patterns used when adding files to the ZIP archive.

Each pattern may use the wildcard character `*` to match zero or more characters.

Files matching any exclusion pattern are skipped.

### Zip.SetExeConfigParam

`Chilkat 11.7.0 · sqlserver · Zip · SetExeConfigParam · method`

```sql
EXEC sp_OAMethod @zip, 'SetExeConfigParam', NULL, @paramName, @paramValue
```

`(Windows only, for creating self-extracting EXE's)`

Sets a configuration parameter embedded within a self-extracting EXE created by `WriteExe` or `WriteExe2`.

The `paramName` should be one of the XML configuration tag names described in the `ExeXmlConfig` property documentation.

For example:

> `SetExeConfigParam("MainUnzipBtn","Extract")`

This changes the text displayed on the self-extractor's main unzip button.

### Zip.Unzip

`Chilkat 11.7.0 · sqlserver · Zip · Unzip · method`

```sql
EXEC sp_OAMethod @zip, 'Unzip', @iResult OUT, @dirPath
```

Extracts all files and directories from the ZIP archive.

- `dirPath` specifies the destination directory.
- Subdirectories are automatically created as needed.

Returns the number of files extracted.

Returns `-1` if a failure occurs.

### Zip.UnzipInto

`Chilkat 11.7.0 · sqlserver · Zip · UnzipInto · method`

```sql
EXEC sp_OAMethod @zip, 'UnzipInto', @iResult OUT, @dirPath
```

Extracts all files into a single directory.

All directory path information stored within the ZIP archive is ignored.

If multiple files have the same filename, later extracted files overwrite earlier ones.

Returns the number of files extracted, or `-1` on failure.

### Zip.UnzipMatching

`Chilkat 11.7.0 · sqlserver · Zip · UnzipMatching · method`

```sql
EXEC sp_OAMethod @zip, 'UnzipMatching', @iResult OUT, @dirPath, @pattern, @verbose
```

Extracts only entries whose stored paths match a wildcard pattern.

- The wildcard character `*` matches zero or more characters.
- If no wildcard is used, an exact filename match is required.

Subdirectories are automatically created as needed.

Returns the number of files extracted, or `-1` on failure.

### Zip.UnzipMatchingInto

`Chilkat 11.7.0 · sqlserver · Zip · UnzipMatchingInto · method`

```sql
EXEC sp_OAMethod @zip, 'UnzipMatchingInto', @iResult OUT, @dirPath, @pattern, @verbose
```

Extracts matching entries into a single directory while ignoring all stored ZIP path information.

Matching behavior is identical to `UnzipMatching`.

If duplicate filenames occur, later extracted files overwrite earlier ones.

Returns the number of files extracted, or `-1` on failure.

### Zip.UnzipNewer

`Chilkat 11.7.0 · sqlserver · Zip · UnzipNewer · method`

```sql
EXEC sp_OAMethod @zip, 'UnzipNewer', @iResult OUT, @dirPath
```

Extracts only files that:

- Do not already exist
- Or have older modification timestamps than the ZIP entry

Subdirectories are automatically created as needed.

Returns the number of files extracted, or `-1` on failure.

### Zip.VerifyPassword

`Chilkat 11.7.0 · sqlserver · Zip · VerifyPassword · method`

```sql
EXEC sp_OAMethod @zip, 'VerifyPassword', @success OUT
```

Verifies that the current `DecryptPassword` value is correct for the currently opened ZIP archive.

This method allows password validation before attempting extraction.

Returns `1` if the password is valid, otherwise returns `0`.

### Zip.WriteBd

`Chilkat 11.7.0 · sqlserver · Zip · WriteBd · method · since 9.5.0.66`

```sql
EXEC sp_OAMethod @zip, 'WriteBd', @success OUT, @binData
```

Writes the ZIP archive to a `BinData` object instead of a filesystem file.

The generated ZIP archive exists entirely in memory.

The ZIP data written by this method may later be opened using `OpenBd`.

Returns 1 for success, 0 for failure.

### Zip.WriteExe

`Chilkat 11.7.0 · sqlserver · Zip · WriteExe · method`

```sql
EXEC sp_OAMethod @zip, 'WriteExe', @success OUT, @exeFilename
```

`(Windows only, for creating self-extracting EXE's)`

Creates a Windows self-extracting executable (EXE).

The generated EXE contains both the extraction logic and the ZIP archive data.

There are no limitations on:

- Total ZIP size
- Individual file size
- Number of files

The generated EXE supports the following command-line arguments:

- `-log logFileName`
- `-unzipDir unzipDirectoryPath`
- `-pwd password`
- `-ap autoRunParams`

Returns 1 for success, 0 for failure.

See also:

- [More information about self-extracting executables.](http://www.cknotes.com/?p=351)

### Zip.WriteZip

`Chilkat 11.7.0 · sqlserver · Zip · WriteZip · method`

```sql
EXEC sp_OAMethod @zip, 'WriteZip', @success OUT
```

Saves the Zip to a file and implictly re-opens it so further operations can continue. Use WriteZipAndClose to write and close the Zip. There is no limitation on the size of files that may be contained within a .zip, the total number of files in a .zip, or the total size of a .zip. If necessary, WriteZip will use the ZIP64 file format extensions when 4GB or file count limitations of the old zip file format are exceeded.

Returns 1 for success, 0 for failure.

### Zip.WriteZipAndClose

`Chilkat 11.7.0 · sqlserver · Zip · WriteZipAndClose · method`

```sql
EXEC sp_OAMethod @zip, 'WriteZipAndClose', @success OUT
```

Saves the Zip to a file and closes it. On return, the Zip object will be in the state as if NewZip had been called. There is no limitation on the size of files that may be contained within a .zip, the total number of files in a .zip, or the total size of a .zip. If necessary, WriteZip will use the ZIP64 file format extensions when 4GB or file count limitations of the old zip file format are exceeded.

Returns 1 for success, 0 for failure.

## Events and callbacks

This binding has no event callbacks.

## Deprecated members — do not use in new code

| Member | Kind | Deprecated in | Use instead |
|---|---|---|---|
| `AppendBd` | method | before 11.6.1 | `AddBd` |
| `AppendDataEncoded` | method | before 11.6.1 | `AddEncoded` |
| `AppendNew` | method | before 11.6.1 | `AddEmpty` |
| `AppendNewDir` | method | before 11.6.1 | `AddEmpty` |
| `AppendOneFileOrDir` | method | before 11.6.1 | `AddFile` |
| `AppendSb` | method | before 11.6.1 | `AddSb` |
| `AppendString` | method | before 11.6.1 | `AddString` |
| `AppendString2` | method | before 11.6.1 | `AddString` |
| `FirstEntry` | method | before 11.6.1 | `EntryAt` |
| `FirstMatchingEntry` | method | before 11.6.1 | `EntryMatching` |
| `GetEntryByID` | method | before 11.6.1 | `EntryById` |
| `GetEntryByIndex` | method | before 11.6.1 | `EntryAt` |
| `GetEntryByName` | method | before 11.6.1 | `EntryOf` |
| `GetExclusions` | method | before 11.6.1 | — |
| `SetPassword` | method | before 11.6.1 | — |

## Related classes

[`BinData`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/BinData.md), [`StringArray`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/StringArray.md), [`StringBuilder`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/StringBuilder.md), [`ZipEntry`](https://www.chilkatsoft.com/ai-docs/v/11.7.0/sqlserver/classes/ZipEntry.md)

