Importing DLLs during runtime

[normanchong]

Hi,

I'm currently developing an application for checking and doing some
configurations for another application. During those checks, I have to
access SQLServer to get configuration-info like MaxServerMemory ,
MaxDegreeOfPara llelism, etc

I added the references for
- Microsoft.SqlSe rver.Connection Info and
- Microsoft.SqlSe rver.Smo
to my project and then imported the namespaces
- Microsoft.SqlSe rver.Management .Smo and
- Microsoft.SqlSe rver.Management .Common
and used their classes 'Server' and 'ServerConnecti on' to do the job

Everythink works fine, but the problem is, that the DLLs
- Microsoft.SqlSe rver.Replicatio n and
- Microsoft.SqlSe rver.BatchParse r
are now needed (and added to my project)

This wouldn't be a problem, but I wondered what happens when SQLServer
is not installed and the DLLs are missing.
Long story short: I want to get rid of the imports and do some kind of
DLL-Late-Binding, so I can react to missing DLLs within my program.
I tried to use the 'DLLImport' but I don't know much about that...So
can anyone tell me how to get the 2 classes I need (Server,
ServerConnectio n)?

P.S.: I'm a newbie, so keep your answers (and perhaps examples) as
simple as possible ;-)

[rowe_newsgroups]

I tried to use the 'DLLImport' but I don't know much about that...

http://msdn.microsoft.com/library/de...indowsAPIs.asp

Thanks,

Seth Rowe

no*********@fre enet.de wrote:

Hi,

I'm currently developing an application for checking and doing some
configurations for another application. During those checks, I have to
access SQLServer to get configuration-info like MaxServerMemory ,
MaxDegreeOfPara llelism, etc

I added the references for
- Microsoft.SqlSe rver.Connection Info and
- Microsoft.SqlSe rver.Smo
to my project and then imported the namespaces
- Microsoft.SqlSe rver.Management .Smo and
- Microsoft.SqlSe rver.Management .Common
and used their classes 'Server' and 'ServerConnecti on' to do the job

Everythink works fine, but the problem is, that the DLLs
- Microsoft.SqlSe rver.Replicatio n and
- Microsoft.SqlSe rver.BatchParse r
are now needed (and added to my project)

This wouldn't be a problem, but I wondered what happens when SQLServer
is not installed and the DLLs are missing.
Long story short: I want to get rid of the imports and do some kind of
DLL-Late-Binding, so I can react to missing DLLs within my program.
I tried to use the 'DLLImport' but I don't know much about that...So
can anyone tell me how to get the 2 classes I need (Server,
ServerConnectio n)?

P.S.: I'm a newbie, so keep your answers (and perhaps examples) as
simple as possible ;-)

[GhostInAK]

On 5 Oct 2006 01:02:31 -0700, no*********@fre enet.de wrote:

First off, DllImport Will Fail, those two files are .NET assemblies -
not Win32 DLLs.

Second off, use the imports. The app will toss an exception if the
required DLLs are missing and you can then correct the problem.

-Boo

>Hi,

I'm currently developing an application for checking and doing some
configuratio ns for another application. During those checks, I have to
access SQLServer to get configuration-info like MaxServerMemory ,
MaxDegreeOfPar allelism, etc

I added the references for
- Microsoft.SqlSe rver.Connection Info and
- Microsoft.SqlSe rver.Smo
to my project and then imported the namespaces
- Microsoft.SqlSe rver.Management .Smo and
- Microsoft.SqlSe rver.Management .Common
and used their classes 'Server' and 'ServerConnecti on' to do the job

Everythink works fine, but the problem is, that the DLLs
- Microsoft.SqlSe rver.Replicatio n and
- Microsoft.SqlSe rver.BatchParse r
are now needed (and added to my project)

This wouldn't be a problem, but I wondered what happens when SQLServer
is not installed and the DLLs are missing.
Long story short: I want to get rid of the imports and do some kind of
DLL-Late-Binding, so I can react to missing DLLs within my program.
I tried to use the 'DLLImport' but I don't know much about that...So
can anyone tell me how to get the 2 classes I need (Server,
ServerConnecti on)?

P.S.: I'm a newbie, so keep your answers (and perhaps examples) as
simple as possible ;-)

[normanchong]

GhostInAK schrieb:

On 5 Oct 2006 01:02:31 -0700, no*********@fre enet.de wrote:

First off, DllImport Will Fail, those two files are .NET assemblies -
not Win32 DLLs.

That's right - sorry, DllImport = stupid idea (Like I wrote: I'm a
newbie ;-) )

Second off, use the imports. The app will toss an exception if the
required DLLs are missing and you can then correct the problem.

When I start my application without those dlls, a dialog with the
exception-message appears but that doesn't seem to be the best
solution...Isn' t there a way to bind the assemblies during runtime?
I tried to use
Reflection.Asse mbly.load(Micro soft.SqlServer. Replication) but it
doesn't seem that I can access the classes 'Server' and
'ServerConnecti on' with this. So I used
Reflection.Asse mbly.load(Micro soft.SqlServer. Smo) but that threw an
exception...

I wondered why I need the .Replication.dl l \ BatchParser.dll because
the two assemblies refer to .Smo.dll \ .ConnectionInfo .dll ?!?