what I understand is optional parameters are better handled if the datatype
is VARIANT.
Probably thats the reason why you are getting type mismatch.

----- Original Message -----
From: "Howard Pinsley" <HPinsleyKAYESCHOLER.COM>
To: <DCOMDISCUSS.MICROSOFT.COM>
Sent: Tuesday, October 02, 2001 11:47 AM
Subject: VBScript Enigma

> I never seem to get a handle on the limitations of VBScript. I have been
> given a component that implements a dual interface where one of the
methods
> is defined as follows:
>
> HRESULT ConnectSQL(
> [in, out] BSTR* errMsg,
> [in, out, optional] BSTR* connectStr,
> [in, out, optional] BSTR* dsnUID,
> [in, out, optional] BSTR* dsnPWD,
> [in, out, optional] BSTR* dsnName,
> [out, retval] VARIANT_BOOL* );
>
> I have no problems calling this method with early binding. Here is what's
> driving me crazy with vbscript/late binding.
>
> Here objMailer has successfully been created with WScript.CreateObject:
>
> Succeeds
> =======
> If (objMailer.ConnectSQL("","DRIVER={SQL Server};SERVER=...")) Then ...
>
> but
>
> Fails
> ====
> connectStr = "DRIVER={SQL Server};SERVER=..."
> If (Not objMailer.ConnectSQL("",connectStr)) Then ...
> yields type mismatch error 0x800A000D
>
> I can pass a string constant but not a variable (which is by definition a
> variant) containing a string? I could swear I could do this before.
>
> Incidentally, I get the same type mismatch errror if I attempt to use a
> variable for the first BSTR parameter.
> errMsg=""
> If (Not objMailer.ConnectSQL(errMsg,"DRIVER={SQL Server};SERVER=..."))
Then
> ...
>
> What is the explanation for this? Why can I pass string constants but not
> variables. Also, the intent of the first parameter is to provide for an
> output error message. Is there no way to get this with a VBScript client?
> I'm wondering if this is because the BSTR's are all declared with [,out].
> The vendor has defined the interface this way even though only the first
> parameter should (I believe) really be declared as such.
>
> TIA
>
> ----------------------------------------------------------------
> Users Guide http://discuss.microsoft.com/archives/mailfaq.asp
> contains important info. Save time, search the archives at
> http://discuss.microsoft.com/archives/index.html .
> To unsubscribe, mailto:DCOM-signoff-requestDISCUSS.MICROSOFT.COM
>

----------------------------------------------------------------
Users Guide http://discuss.microsoft.com/archives/mailfaq.asp
contains important info. Save time, search the archives at
http://discuss.microsoft.com/archives/index.html .
To unsubscribe, mailto:DCOM-signoff-requestDISCUSS.MICROSOFT.COM

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]