Hi,

I am using DSO objects to access the analysis service. I added COM
object as reference, which is at my 'C:\Program Files\Common Files\
Microsoft Shared\DSO\msmddo80.dll' with version:8.0.0.795. I apply
SP3a for both SQL Server 2000 and Analysis Server. In my code, I am
trying to assign DSO.DataSource.ConnectionString, but the compiler
complaint it cannot find this field. Here is the code:

Module Module1

Sub Main()
Dim a As DSO.DataSource
a.ConnectionStirng = "blah blah"
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
End Sub

End Module

Here is error message:

C:\test\ConsoleApplication1\Module1.vb(5): 'ConnectionStirng' is not a
member of 'DSO.DataSource'.


Any helps are apprecieted.

Thank you

you have typed: ConnectionStiRng
and not ConnectionStRing


"John Sayor" <js_2004 (AT) mailcan (DOT) com> wrote

js_2004 (AT) mailcan (DOT) com (John Sayor) wrote in message news:<be541a84.0411251216.7b63880b (AT) posting (DOT) google.com>...

Sorry, there is a typo. ConnectionStiring should be ConnectionString.
In Object broswer, the DSO.DataSource class only has there methods:

Clone(ByVal DSO._ICommon, [ByVal DSO.CloneOptions])
set_ConnectionString
set_Description
set_Name
set_Parent
_VtblGap7 _9()
get_CloseQuoateChar()
get_ConnectionString()
get_CustomProperties
get_Description()
get_IsReadOnly()
get_IsValid()
get_Name()
get_OpenQuoteChar()
get_Parent()
get_SupportedTxnDDL()
IsConnected
Update()