Stack Overflow
Stack Overflow

Questions tagged [sqldmo]

SQL Distributed Management Objects (SQL-DMO) is a collection of COM objects that are designed for programming all aspects of managing Microsoft SQL Server.

SQL Distributed Management Objects (SQL-DMO) is a collection of COM objects that are designed for programming all aspects of managing Microsoft SQL Server.

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

27 questions
0
votes
1 answer

Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5}

I was working with SQL DMO class for some query execution in VB.NET code, and I am getting following error {"Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154…
DareDevil
  • 5,249
  • 6
  • 50
  • 88
0
votes
1 answer

Migrating from SQL DMO to SQL SMO (SQL Server 2012)

I am migrating the SQL DMO logic to a SQL SMO logic and I am not sure how to achieve the same functionality for a few of the attributes. This is the DMO: oBCP = New SQLDMO.BulkCopy2 With oBCP .ImportRowsPerBatch = ImportRowsPerBatch …
benak
  • 1
  • 2
0
votes
0 answers

how to manually register a 32 bit version of SqlDmo.dll?

I am making my first Crystal report but I am getting the error Retrieving the COM class factory for component with CLSID {10020100-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154. My Code…
user4102564
  • 33
  • 1
  • 10
0
votes
2 answers

SQL Comparing two Stored procedures between databases

I have two version of same database and need to campare some objects between them (stored procedures, views etc.) Actually ?m using SQLDMO-SQLSMO to retrieve the Text of each object then I perform a text comparison. This is efective but take a long…
Juan Pablo Gomez
  • 5,203
  • 11
  • 55
  • 101
0
votes
3 answers

How to make app fully SQL Server 2005 compatible?

We have an application that use MSSQL, when we move to 2005, basically we recommend to our client to apply the backward compatibility package and that’s it, but somebody ask me what to do to be 100% compatible on 2005. I was thinking on 1.…
rigg
0
votes
1 answer

Is there a way to specify a domain to look at when using SQLDMO to list SQL servers?

Pardon me if this is a basic question, but I'm just starting to delve into using SQLDMO and I've not been able to find a specific answer to what I'm looking for. The scenario is this: I am trying to list the running SQL Servers in a combo box, but…
Matt Dewey
  • 137
  • 1
  • 1
  • 11
0
votes
1 answer

SQLDMO - [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '*'

I'm currently in charge of maintaining a legacy software. Currently I'm having problem with SQLDMO as following: //This function is used to create sql query for drop and create table Function GenerateScript(ByVal pObjectType As String, ByVal…
Doan Cuong
  • 2,594
  • 4
  • 22
  • 39
0
votes
1 answer

SQL Server 2008 doesn't use backup device path when running powershell script from prompt

I made a script that backups all of the databases of my remote server. When I run the script from the PowerShell ISE interface, the path that I determine in the backup device works fine, but when I run it from the prompt, the path I set is ignored,…
Pascal
  • 2,944
  • 7
  • 49
  • 78
0
votes
1 answer

Error when creating a SQL Server 2008 R2 database using VBS (SQL DMO)

I used to run a script in VBS using SQL-DMO to create a new database. This was done for SQL Server 2000 however this is no longer working under SQL Server 2008 R2. Script is like this: Const C_SQL_UID = "sa" Const C_SQL_PWD = "sa" Const C_SQL_SERVER…
JackoBongo
  • 87
  • 3
  • 12
0
votes
2 answers

SQL Server EnumParameters Method on StoredProcedure object in SQL Server 2008 SQL-DMO

Hello all you wonderfully helpful people, What is the alternative to EnumParameters in SQL Server 2008? This MSDN article mentions that this method is going away, so what should be used…
Paul
0
votes
1 answer

Error R6034 in MSACCESS.EXE followed by Run-time error '-2147023782 (8007045a)'

I have these error messages when I start MS-Access application (has VBA code). When I click OK in the first error message and debug in the second, the debugger opens up and points to the line that says: "Set oServer = New SQLDMO.SQLServer" I realise…
mikimr
  • 311
  • 3
  • 8
  • 18
0
votes
1 answer

Using COM objects in a T4 template?

I'm new to Visual Studio's T4 template engine, and I'm wondering how I can use COM objects to build templates. Specifically, SQL-DMO (to generate classes from stored procedures on a SQL 2000 server, SNO is not an option). Have any of you guys done…
Chris McCall
  • 10,317
  • 8
  • 49
  • 80
1
2