(SQL Server) Determine File Type

Demonstrates how to determine the type of file. Possible types are:

• 1: Regular file
• 2: Directory
• 3: Symbolic Link
• 4: Windows shortcut
• 99: Something else
• 0: File not found
• -1: Unable to check because of directory permissions or other error.

Note: This example requires Chilkat v9.5.0.77 or greater.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Call the FileType method to determine the file type.
    -- (Note: FileType is a method, not a property.)

    DECLARE @fac int
    -- Use "Chilkat_9_5_0.FileAccess" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.FileAccess', @fac OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @fileType int
    EXEC sp_OAMethod @fac, 'FileType', @fileType OUT, 'qa_data/shortcuts/chilkat_pkcs7_shortcut.xml'

    PRINT 'fileType = ' + @fileType

    -- Possible fileType values are:
    -- 1: Regular file
    -- 2:  Directory
    -- 3: Symbolic Link
    -- 4: Windows shortcut
    -- 99: Something else
    -- 0: File not found
    -- -1: Unable to check because of directory permissions or other error.

    EXEC @hr = sp_OADestroy @fac


END
GO