Interop.SQLDMO.dll Problem

Interop.SQLDMO.dll Problem

• Matt Falzon

  "and was a error". What was the exact error message
  
  
  

• pvulcan

  Setting it from Any CPU to x86 did the trick. Just in case someone else is having this same issue the Build tab is the Compile tab and from there you have to click the Advanced Compile Options button and then you can change the Platform target. But all that matters to me is that it did the trick. Thanks for your reply nobugz.....
  

• darkwarrior0404

  0x80040154 = Class not registered. Your server doesn't have SQL DMO installed. I'm not quite sure how you get it, try installing the SQL server client. Post at one of the SQL server forums to get a better answer.
  
  
  

• Toni Greco

  ok me too calling to COM with methods.
  working in my local.but not working on server.and was a error.

  and not working COM object when i calling to COM object(SQLDMO.dll)

  can i do

  
  
  

• Dakota03

  Hmm, the only thing that jumps out is "XP64 workstation". .NET 2.0 supports 64-bit operating systems, not sure about 1.1. COM and sqldmo.dll almost surely don't like running in 64-bit mode. The registry, where COM gets its class registration info, is shadowed for 32-bit apps. You'd easily run into a case where sqldmo.dll is properly registered for 32-bit apps but not for 64-bit apps.
  
  Try forcing .NET to run in 32-bit mode. Project + properties, Build tab, Platform target. Change it from "Any CPU" to "x86". Do the same for the Release configuration.
  
  
  

• Jarrado

  Interop.SQLDMO.dll is a COM callable wrapper (CCW), it shouldn't be registered. It is not an ActiveX component that has the DllRegisterServer entry point, it translates .NET calls to COM interface method calls.
  
  
  

• a.d.m

  I'm getting the same exact error when referencing the SQLDMO. Here are a few more details. I've created a very simple project in Visual Studio .NET 2003 and created the exact same project in Visual Studio .NET 2005. In VS.NET 2003 it works fine. In VS.NET 2005 I get the "Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154" error.

  The project I've created has a reference to the Microsoft SQLDMO 8.0 COM component, a form with a button, and one line of code in the button's click event. The line of code is:

  Dim oSQLServer As New SQLDMO.SQLServer

  When this line runs in 2005 I get the error, when it runs in 2003 it works fine. I'm running this on the same XP64 workstation and I'm trying to connect to a SQL 2000 database running service pack 4.

  Any ideas

  Thanks

  
  

• SQLServer2050

  when program running is a error =

  Retrieving the COM class factory for compnent with CLSID{10020200-E260-11CF-AE68-00AA004A34D5} failed due to the following error:80040154

  
  
  
• Interop.SQLDMO.dll Problem