Hello! I'm new to VB. Started with

[dianal]

Hello!
I'm new to VB. Started with building ready made examples.

Dim m_xmlDoc As MSXML2.DOMDocument
Dim m_SQLServer As New SQLDMO.SQLServer2
...
Private Function GetTableElement(ByRef tbl As SQLDMO.Table2) As IXMLDOMElement

I got a complile time error "Can't find project or library".
VB suggested to find MS XML 4.0 and MS SQLDMO Object Library.
I have listed in Project/References only MS XML 3.0.
How to get MS XML 4.0 (and possibly newer SQLDMO Object Library)?

Thanks!

 

[madlarry]

Change the DomDocument declaration to:

Dim m_xmlDoc as DOMDocument30

This will use the MSXML3 library to create a Dom document. MSXML4 is only in beta at the moment.

I'm not sure about the SQLDMO library.

Madlarry

 

[woyler]

http://www.microsoft.com/downloads/release.asp?ReleaseID=29163

 

[dianal]

Hello,
I did, but it gain complains about IXMLDOMElement.
May be I found too advanced example.

Thanks!

 

[madlarry]

When you reference all of the XML objects (Nodes, Elements etc) don't specify the server in front of the object (i.e. MSXML2.IXMLDOMElement) just reference the object and remove the server name (i.e. IXMLDOMElement), you won't be referencing the MSXML2 library then.

Madlarry