Problem using SQLDMO/Vb6 against SQL Server 2008

Posted by E.J. Brennan on Stack Overflow See other posts from Stack Overflow or by E.J. Brennan
Published on 2010-03-23T20:05:50Z Indexed on 2010/03/24 6:13 UTC
Read the original article Hit count: 489

Filed under:

sqldmo

|

vb6

|

sql-server

|

sql-server-2008

I have a client, that uses SQLDMO for a portion of a custom application that was written against SQL Server 2000, and they recently upgraded to SQL Server 2008.

The majority of the app still runs fine (doesn't use SQLDMO), but the admin functions which rely on SQLDMO stopped working.

I installed the SQL2005 backward compatibility pack, and now SQLDMO partially works, i.e. I can run "select" type queries, but any "Update" queries fail with the error message:

to connect to the server you must use SQL Server management studio or sql server management objects (SMO)

Any thoughts? Should the backward compatibility pack give me ALL the functionality back, or is this a known issue?

BTW: I realize SQLDMO has been deprecated and will go away next release, none-the-less I need to do what I can to solve the problem at hand.

© Stack Overflow or respective owner

Related posts about sqldmo

Problem using SQLDMO/Vb6 against SQL2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a client, that uses SQLDMO for a portion of a custom application that was written against SQL 2000, and they recently upgraded to SQL2008. The majority of the app still runs fine (doesn't use SQLDMO), but the admin functions which rely on SQLDMO stopped working. I installed the SQL2005 backward… >>> More
Problem using SQLDMO/Vb6 against SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a client, that uses SQLDMO for a portion of a custom application that was written against SQL Server 2000, and they recently upgraded to SQL Server 2008. The majority of the app still runs fine (doesn't use SQLDMO), but the admin functions which rely on SQLDMO stopped working. I installed… >>> More
sql 2008 sqldmo alternative

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi! I previously was using sqldmo to automatically generate scripts from the databse. Now I upgraded to sql server 2008 and I don’t want to use this feature anymore since Microsoft will be dropping this feature off. Is there any other alternative I can use to connect to a server and generate scripts… >>> More
SQL Server 2008 alternative for SQL-DMO

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi! I previously was using SQL-DMO to automatically generate scripts from the database. Now I upgraded to SQL Server 2008 and I don’t want to use this feature anymore since Microsoft will be dropping this feature off. Is there any other alternative I can use to connect to a server and generate scripts… >>> More
How can I drop a SqlServer Backup Device using SMO in C#?

as seen on Stack Overflow - Search for 'Stack Overflow'
I can drop a SqlServer Backup Device using SQL-DMO using the following pseudo-code: SQLDMO.SQLServer2 server = New SQLDMO.SQLServer2(); server.Connect("myserver"); server.BackupDevices.Remove("mybackupdevice"); File.Delete("mybackupdevicephysicallocation"); SMO.Server.BackupDevices does not appear… >>> More

Related posts about vb6

VB6 App + .Net component working as compiled app but not in VB6 IDE

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a VB6 App that uses a .Net component (via a .tlb reference in the VB6 app) which is working fine when executed as a compiled app, but it produces an error from the VB6 IDE a certain point when it is trying to use the .NET component. I should note that the error occurs when the .NET component… >>> More
Tutoriel VBA/VB6 : Les extensions OpenGL en VBA et VB6, par Thierry Gasperment (Arkham46)

as seen on Developper.com - Search for 'Developper.com'
Bonjour à tous! Voici un article sur la programmation des extensions OpenGL, en VB6/VBA Cet article décrit l'utilisation de quelques extensions fréquemment utilisées : - Les VBO (vertex buffer objects) pour améliorer les performances - Les textures 3D pour réaliser des textures continue sur… >>> More
Is it possible to simultaneously debug VB6 and a C++ COM dll?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a VB6 dll that is loaded by a VB6 frontend. This VB6 dll calls a C++ ATL dll via its COM interface. So, I can run from code in VB6 and I can debug in C++ also, however I can't seem to step through the VB6 code and then get into the C++ code. I feel that this should be possible. Currently I… >>> More
Writing excel file to vb6

as seen on Stack Overflow - Search for 'Stack Overflow'
i have an excel file template and i want save the written value in textboxes to the cells of excel using vb6 language. can anyone help me? >>> More
Trace not working in a .NET DLL loaded from VB6 EXE

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I have a .NET DLL that writes to the Trace. But seems that when I call my DLL from a VB6 EXE the trace is not working. I have created an myApp.config file in the EXE folder with the trace configuration, but this does not solves the issue. I've also tried creating the Trace objects in code… >>> More