SQL DMO Support in SQL Server 2005...

Hi,
We have a C++ application that uses the raw SQL DMO COM interfaces to connect to the SQL Server 2000. When this application tries to connect to SQL Server 2005, it failed to connect for obvious reasons. I tried to use the latest SQL DMO interfaces and, to my surprise, in the June CTP, I didn't find any header files that contains the COM interface definitions for the latest SQL DMO. Is this something that MS forgot to include in the install ?

SQLDMO documentation in June CTP says that the SQL DMO header files will be found under 90\Tools\DevTools\Include. I did a complete install of the June CTP and I don't have DevTools and its child directories on my box. Am I missing something?

Any help would be appreciated?

Thanks,
SH

[752 byte] By [Saaketh] at [2008-1-27]

«« VBA Syntax
»» DateTimePicker appears above msgbox when msgbox opened from ValueChanged event

# 1

This seems indeed to be a bug. I will see if we can provide a work around.

MichielWories at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server SMO/DMO...

# 2

As the header has not been changed since SQL Server 2000, it should be safe to use that header. Note that the latest CTP (post June) has significant updates to SQL-DMO. I recommend using that version.

MichielWories at 2007-9-9 >

# 3

Thanks for the update.

I copied the SQL Server 2000's SQL DMO files and I was able to work with them.

I installed the September CTP and to my surprise the sqldmo header files are not still there. I hope that you're going to fix this in the RTM.

Cheers,
SH

Saaketh at 2007-9-9 >

# 4

From what I can read MS have discontinued SQL-DMO and replaced it with SMO for .net only. 2005 B2 had a sqldmo.dll for 9.0 but this has gone.
It would be nice to know what the real story is!

Bdy at 2007-9-9 >

# 5

SQL Server 2005 will ship a backward compatiblity redist that allows installation and redistribution of SQL-DMO. This version of DMO updates previous versions DMO (if installed) and allows clients to work with SQL Server 2005.

MichielWories at 2007-9-9 >

# 6

I am trying to access a SQL 2005 server (with compatibility package installed) from a windows 2003 server with MSDE 2000 installed and when using the DMO interface I get the following error:To connect to this server you must use SQL server management studio or SQL server management objects (SMO)
Errnum=55555

The DMO and DTS is enabled on the 2005 sql server, what else can be wrong, the same function on the server hosting the sql 2005 locally works.

this is the code sample:

Set oServer = CreateObject("SQLDMO.SQLServer")
oServer.LoginSecure = True

oServer.Connect txtPrimServ.Text

oServer.ExecuteImmediate "use DB1"

oServer.DisConnect

Set oServer = Nothing

giuseppec at 2007-9-9 >

# 7

I installed the backward compatibility part of SQL2005, but I still did not found sqldmo.h header file (even devtools sub directory is non-existent). Any help would be appreciated.

Cheese at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech