Share via

_SiteConfig::PutSQLScript Method

  • Article

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

Note

This object is obsolete. Use SiteConfigFreeThreaded instead.

Use this method to put the specified SQL script file into the Administration database.

HRESULT _SiteConfig::PutSQLScript(
  BSTR sResource,
  BSTR sScriptName,
  BSTR sScriptContents
);

Sub PutSQLScript(
    sResource As String,
    sScriptName As String,
    sScriptContents As String
)

Parameters

  • sResource
    [C++]

    [in] A BSTR that contains the name of the resource associated with the SQL script file.

    [Visual Basic]

    A String that contains the name of the resource associated with the SQL script file.

  • sScriptName
    [C++]

    [in] A BSTR that contains the name of the SQL script file.

    [Visual Basic]

    A String that contains the name of the SQL script file.

  • sScriptContents
    [C++]

    [in] A BSTR that contains the SQL script file contents.

    [Visual Basic]

    A String that contains the SQL script file contents.

Return Value

[C++]

This method returns an HRESULT indicating whether it completed successfully. See the Error Values section for more details.

[Visual Basic]

None.

Error Values

[C++]

This method returns S_OK (0x00000000) to indicate success and standard COM HRESULT error values to indicate failure. For more information about standard COM errors, see Standard COM Errors. Additional information may be available using the global Err object, which can be accessed using the API function GetErrorInfo. In particular, the GetDescription method of the IErrorInfo interface may return a text description of the error.

[Visual Basic]

This method sets the Number property of the global Err object to S_OK (&H00000000) to indicate success and to standard COM error values to indicate failure. For more information about standard COM errors, see Standard COM Errors. Additional information may be available using the global Err object. In particular, the Description property may contain a text description of the error.

All ADO, SQL, and ODBC errors will also be returned by this method.

Remarks

The Initialize method must be called before this method can be used.

Example

' sMySQLFileName.sql, sMyRes and sMyContents are strings.
' oSiteConfig is a SiteConfig object.
oSiteConfig.PutSQLScript(sMyRes, "sMySQLFileName.sql" ,sMyContents )

See Also

Other Resources

SiteConfig Object