Related topics

Weird SQLDMO Problem
I'm trying to connect to a database using SQLDMO but for some reason I simply cannot do it using the sa login. If I set the LoginSecure property to True, which sets the connection using NT authentication, it works fine (this is in Windows 2000): Dim objServer as New SQLDMO.SQLServer objServer.

Lost SQLDMO ??!!!??
Actually in this case (after a little snooping in the registry on a Win2K Pro box), there is no such progid as "SQLDMO.QueryResults" (I do see a lot of *other* "SQLDMO.whatever" progids ;-)... Given the "QueryResults" part, I would assume this is not a "creatable" object, but rather an object returned to you via a

SQLDMO
Has anyone been able to successfully distribute the SQLDMO dependency dll's from SQL Server 2000? Is the distribution od SQLDMO without the server intentionally prevented by Microsoft? We have a utility app that references the SQLDMO and thus requires those files to been on the target install machine.

SQLDMO - QueryResults -Objekt schliesst Connection ?
Dim obj_Column_Def As SQLDMO.Column2 dim obj_View as SQLDMO.View2 DIm obj_ColResult1 as SQLDMO.SQLObjectList dim obj_View = Something... Set obj_ColResult1 = obj_View.ListColumns 'This won't work... Set obj_Column_Def = obj_ColResult1.Item("MyColumnInMyView") I'll get this error when the statement above.

Exporting SQL7 to Access with SQLDMO
MDAC does not install the Sqldmo.dll file or any of the many dependent DLLs associated with the Sqldmo.dll file. What MDAC does include is many of the related DLLs that a SQL-DMO client W95scm.dll From the preceding list of DLLs, the Sqldmo.dll is the only one that you need to register on the client computer.

sqlDMO programming
In my VB application, I used SQLDMO functions to get a list of SQL Servers in an local network. But when I made a setup package for my application, the SQLDMO functions does not work properly. Who can tell me which component should be include? I include sqldmo.dll,sqldmo.rll and make sqldmo.dll as self-register

SQLDMO Problem - please help
Narayana Vyas Kondreddi answer...@hotmail.com microsoft public sqlserver programming Why are you choosing SQL DMO for this? This can be achieved by using simple SQL commands. Are the source and target tables on the same server/same database? -- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ Is .NET important

Automating replication using sqldmo - correction
Ich habe beim Googeln etwas anderes gefunden (Auszug): "Installing the MSDE that ships with Office 2000 automatically installs sqldmo.dll, which implements SQL-DMO for use with SQL Server 7.0 and MSDE. However, Office 2000 doesn't include the SQL-DMO Help file, sqldmo.hlp. Fortunately, developers working with MSDE

Using The SQLDMO Object
From what I've learned, sqldmo gives a list of column objects for a table or view and the order of the column objects in that list from the order that was used in the original table/view DDL. It's definitely not the same order as what you see when you look at the table in Enterprise manager or via sp_help in Query

SQLDMO.Restore problem
Rashmi Dave[MS] rd...@online.microsoft.com microsoft public sqlserver programming For SQL-DMO to work, just registering the SQLDMO.dll is all that is required to use the SQL_DMO library. SQL Client does not have to be installed. Refer to Q248241 for more information Make sure all files given below are in the

SQLDMO, RESTORE and type mismatch
It relies on SQLDMO to do a lot of the lot work. Distributing SQLDMO means that the install package has an extra 2MB on top of every thing else. In addition to this if you do the SQLDMO 8.0 install on a SQL Server 7.0 client then Enterprise manager stops working, it requires more files that would then increase the

SQLDMO e VB
In case of any error it restores the database from the backup (also via SQLDMO). Problem is, when I want to do the Restore after an Error, the Restore fails with the following error message "Exclusive access could not be obtained". I have made sure that all ADO.NET Commands close their respective connections (via

Can't Access SQLDMO Registry2 Object
defaultu...@domain.com microsoft public sqlserver programming I got a problem accessing table data via SQLDMO and VB5. I can access table data via SQLDMO using the 'QueryResults' object. I can access a single data field using the GetColumnxxx method. So far, so nice. But there's a big problem(I'd say it's a

problem of deployment for SQLDMO
Net uses SQLDMO going through an interop, so I assume this is where the performance hit is coming from. How do I solve this? Move to SQL2005?! I was actually thinking of putting the BCP in a stored proc and calling that, removing all traces of SQLDMO. Any thoughts would be helpful. Thanks Pete --Code snippet below

Weird SQLDMO Problem
This package should include all dependency files as well (SQL DMO or other COM components). You could prepare installation using Package and Deployment Wizard from the Visual Studio 6. It should include SQL DMO automatically into prepared setup -- Val Mazur Microsoft MVP "Elmo Watson" <sputnik75043@nospam.

SQLDMO Problem
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\ Resources\xxxx Sqldmo.rll Localized resource file. The resource directory varies based on the national language of the instance of SQL Server client or server. For example, the directory 1033 is a decimal representation of the language identifier 0X0409,

SQLDMO ScriptTransfer scripts dependencies even when option is ...
Mark Olbert m...@arcabama.com microsoft public sqlserver programming I wrote a method in C# (Windows Forms) which uses SQLDMO to query the various database objects in a database and determine their dependencies. At least that's what it used to do yesterday. Today the same routine blows up with invalid cast

Incorrect SQLDMO_OBJECT_TYPE in SQLDMO.dll
MDAC does not install the Sqldmo.dll file or any of the many dependent DLLs associated with the Sqldmo.dll file. What MDAC does include is many of the related DLLs that a SQL-DMO client connection uses. Regardless, bundling MDAC with your application installation is not going to be the most efficient answer either,

SQLDMO Last Backup (for database not Transaction Log)
If I understand correctly that when you tried to open SQL Server Enterprise Manager (SEM) in SQL 2000, you fails with the following errors : SQLDMO has not been registered, please re-run SQL Server setup and contact your system administrator. Snap-in failed to initiale. Name: Microsoft SQL Enterprise Manager CLSID:

Unable to create automation bject 'SQLDMO.SQLServer'
sql...@virgilio.it microsoft public it sql salve, user wrote: Ciao Andrea, grazieeffettivamente sono stato poco chiaro. regsvr32.exe /v sqldmo.dll) presente nella cartella Binn di SQL Server 2000 (lo trovi tra i componenti shared di SQL e quindi non nella cartella dell'istanza specifica) visto che