SQLDMO

[warlord]

I'm playing with the SQLDMO Interop to try to create an SQL database on a
server (sql 2000/2005) without as little user interaction as possible.
Logon, password and server name is about all I need.

Which I have got to work just fine and dandy - so long as the client running
it has SQL client or server installed.

How do I determine if SQLDMO is even available before I try to make any
calls to SQLDMO functions? Do I just search for a file or registry entry?
Any other suggestions?

W

[Michael Nemtsev]

Hello warlord,

Check for the existed sqldmo.dll ?!

wI'm playing with the SQLDMO Interop to try to create an SQL database
won a server (sql 2000/2005) without as little user interaction as
wpossible. Logon, password and server name is about all I need.
w>
wWhich I have got to work just fine and dandy - so long as the client
wrunning it has SQL client or server installed.
w>
wHow do I determine if SQLDMO is even available before I try to make
wany calls to SQLDMO functions? Do I just search for a file or
wregistry entry? Any other suggestions?
w>
wW
w>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[warlord]

That's kinda what I figured - just wondered if there was a more elegant way.

"Michael Nemtsev" <ne*****@msn.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

Hello warlord,

Check for the existed sqldmo.dll ?!

wI'm playing with the SQLDMO Interop to try to create an SQL database
won a server (sql 2000/2005) without as little user interaction as
wpossible. Logon, password and server name is about all I need.
wwWhich I have got to work just fine and dandy - so long as the client
wrunning it has SQL client or server installed.
wwHow do I determine if SQLDMO is even available before I try to make
wany calls to SQLDMO functions? Do I just search for a file or
wregistry entry? Any other suggestions?
wwW
w---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do
not cease to be insipid." (c) Friedrich Nietzsche

[Nicholas Paldino [.NET/C# MVP]]

This isn't the way to do it, since you can have the DLL on the machine,
and it might not be registered correctly.

Moreover, you can't determine where it is installed, or if that dll is
the one that is registered on the system.

To the OP, I assume that you are distributing your interop assembly with
your app. What I would do is try and create an instance of the class, and
wrap it in a try/catch statement, catching the exception that is thrown when
a COM class instance can not be created.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Michael Nemtsev" <ne*****@msn.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

Hello warlord,

Check for the existed sqldmo.dll ?!

wI'm playing with the SQLDMO Interop to try to create an SQL database
won a server (sql 2000/2005) without as little user interaction as
wpossible. Logon, password and server name is about all I need.
wwWhich I have got to work just fine and dandy - so long as the client
wrunning it has SQL client or server installed.
wwHow do I determine if SQLDMO is even available before I try to make
wany calls to SQLDMO functions? Do I just search for a file or
wregistry entry? Any other suggestions?
wwW
w---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do
not cease to be insipid." (c) Friedrich Nietzsche

[John B]

warlord wrote:

I'm playing with the SQLDMO Interop to try to create an SQL database on a
server (sql 2000/2005) without as little user interaction as possible.
Logon, password and server name is about all I need.

Which I have got to work just fine and dandy - so long as the client running
it has SQL client or server installed.

How do I determine if SQLDMO is even available before I try to make any
calls to SQLDMO functions? Do I just search for a file or registry entry?
Any other suggestions?

W

Why not just use the CREATE DATABASE DbName statement instead?

Just curious.

JB

[Michael Nemtsev]

Hello Nicholas Paldino [.NET/C# MVP],

NThis isn't the way to do it, since you can have the DLL on the
Nmachine, and it might not be registered correctly.
N>
NMoreover, you can't determine where it is installed, or if that
Ndll is the one that is registered on the system.
N>
NTo the OP, I assume that you are distributing your interop
Nassembly with your app. What I would do is try and create an
Ninstance of the class, and wrap it in a try/catch statement, catching
Nthe exception that is thrown when a COM class instance can not be
Ncreated.

Yep, sure. I was more pointed to the "if SQLDMO is *even available*" phrase,
but exactly try/catch is always only the good way to check that smth exists

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[warlord]

"John B" <jb******@yahoo.comwrote in message
news:44**********@news.iprimus.com.au...

warlord wrote:

>I'm playing with the SQLDMO Interop to try to create an SQL database on a
server (sql 2000/2005) without as little user interaction as possible.
Logon, password and server name is about all I need.

Which I have got to work just fine and dandy - so long as the client
running it has SQL client or server installed.

How do I determine if SQLDMO is even available before I try to make any
calls to SQLDMO functions? Do I just search for a file or registry
entry? Any other suggestions?

W

Why not just use the CREATE DATABASE DbName statement instead?

Just curious.

JB

I could do that but when you get into passing scripts to the server I find
you're not as in control of the process. You get into the whole success or
failure thing having to validate it got created not just that the script ran
successfully.

W

[warlord]

"Michael Nemtsev" <ne*****@msn.comwrote in message
news:17***************************@msnews.microsof t.com...

Hello Nicholas Paldino [.NET/C# MVP],

NThis isn't the way to do it, since you can have the DLL on the
Nmachine, and it might not be registered correctly.
NNMoreover, you can't determine where it is installed, or if that
Ndll is the one that is registered on the system.
NNTo the OP, I assume that you are distributing your interop
Nassembly with your app. What I would do is try and create an
Ninstance of the class, and wrap it in a try/catch statement, catching
Nthe exception that is thrown when a COM class instance can not be
Ncreated.

Yep, sure. I was more pointed to the "if SQLDMO is *even available*"
phrase, but exactly try/catch is always only the good way to check that
smth exists

I figured I'd try the try/catch to pick up on that but instead my little
test app didn't do anything but hang... I still got a few things to test in
it but if try/catch is the more elegant option I'll use it.

W