SQLDMO.SQLServer2

[JBaileys]

I am getting an error with code:
Type 'SQLDMO.SQLServer2' is not defined.

I have a reference to MS SQLDMO library.

Code looks like:
Dim objServer As SQLDMO.SQLServer2
Dim objDatabase As SQLDMO.Database2
Dim ServerName As String = Me.txtServerName.Text
Dim DatabaseName As String = Me.txtDatabase.Text

' Connect to the specified sql server
objServer = New SQLDMO.SQLServer2

 

[ThatRickGuy]

What namespace is SQLDMO in? I'm guessing it's not in the default namespace meaning that it's either something you built, or a 3rd party control. Do you have a reference to the DLL that contains it?

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[JBaileys]

The reference is:
Microsoft SQLDMO Object library - Microsoft SQL Server\80\tools\binn\sqldmo.dll

Thanks,

JB

 

[ThatRickGuy]

Quick question, do you have SQL Server 8 installed on the machine in question?

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[JBaileys]

We are running sql server 2000 (sp3a). Version 8.00.818

 

[ThatRickGuy]

Have you Imported the base namespace? or is SQLDMO the base namespace?

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.