dbTalk Databases Forums  

Creating SQLDMO fails

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Creating SQLDMO fails in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bernd Maierhofer
 
Posts: n/a

Default Creating SQLDMO fails - 07-31-2009 , 01:59 AM






Not sure, if this is the right place, but...

In Inoosetup 5.3.2 I use - and usually this works ok:

try
SQLServer := CreateOleObject('SQLDMO.SQLServer');
except
RaiseException('Microsoft SQL server Connectivity Tools sind nicht
installiert.'#13#13'(' + GetExceptionMessage + ')');
end;


Yesterday this failed (Win2003, MSSQL2005 client connectivity installed by
me), although the installation was correct and my app could connect to
server.

Does this work ONLY if the server itself is also installed on the same
machine?

Any idea?

TIA Bernd

Reply With Quote
  #2  
Old   
Russell Fields
 
Posts: n/a

Default Re: Creating SQLDMO fails - 07-31-2009 , 12:26 PM






Bernd,

No, you do not need to be on the server, but you do need SQLDMO on your
client. For SQL Server 2005 SQLDMO is deprecated and is not part of the
standard client install. However, you can download the backward
compatibility package at
http://www.microsoft.com/downloads/d...displaylang=en
Look for: Microsoft SQL Server 2005 Backward Compatibility Components

Also, a FWIW from SQL Server 2000 installing SQLDMO without the client
tools.
http://support.microsoft.com/kb/248241

RLF

"Bernd Maierhofer" <bernd.maierhofer (AT) dato (DOT) at> wrote

Quote:
Not sure, if this is the right place, but...

In Inoosetup 5.3.2 I use - and usually this works ok:

try
SQLServer := CreateOleObject('SQLDMO.SQLServer');
except
RaiseException('Microsoft SQL server Connectivity Tools sind nicht
installiert.'#13#13'(' + GetExceptionMessage + ')');
end;


Yesterday this failed (Win2003, MSSQL2005 client connectivity installed by
me), although the installation was correct and my app could connect to
server.

Does this work ONLY if the server itself is also installed on the same
machine?

Any idea?

TIA Bernd

Reply With Quote
  #3  
Old   
Bernd Maierhofer
 
Posts: n/a

Default Re: Creating SQLDMO fails - 08-03-2009 , 06:30 AM



Ah, this is what I missed!

Thanks!

Bernd

"Russell Fields" <russellfields (AT) nomail (DOT) com> schrieb im Newsbeitrag
news:eQSbJQgEKHA.4824 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
Quote:
Bernd,

No, you do not need to be on the server, but you do need SQLDMO on your
client. For SQL Server 2005 SQLDMO is deprecated and is not part of the
standard client install. However, you can download the backward
compatibility package at
http://www.microsoft.com/downloads/d...displaylang=en
Look for: Microsoft SQL Server 2005 Backward Compatibility Components

Also, a FWIW from SQL Server 2000 installing SQLDMO without the client
tools.
http://support.microsoft.com/kb/248241

RLF

"Bernd Maierhofer" <bernd.maierhofer (AT) dato (DOT) at> wrote in message
news:%23EaE1xaEKHA.4704 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Not sure, if this is the right place, but...

In Inoosetup 5.3.2 I use - and usually this works ok:

try
SQLServer := CreateOleObject('SQLDMO.SQLServer');
except
RaiseException('Microsoft SQL server Connectivity Tools sind nicht
installiert.'#13#13'(' + GetExceptionMessage + ')');
end;


Yesterday this failed (Win2003, MSSQL2005 client connectivity installed
by me), although the installation was correct and my app could connect to
server.

Does this work ONLY if the server itself is also installed on the same
machine?

Any idea?

TIA Bernd


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.