Re: SQL 2005 (Express) - Can't connect with ActiveX SQLDMO

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



You need the DMO version that ships with SQL Server 2005, this is part of
the backwards compatibility components installation option on a regular
install, I am not sure this is part of Express, I think not.

GertD@xxxxxxxxxx

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.

"Martin Schmeller" <martin@xxxxxxxxxxxx> wrote in message
news:OccR$0U5FHA.3292@xxxxxxxxxxxxxxxxxxxxxxx
> Hello everybody,
>
> I try to run our VB6 client-software from my win2000 pc with SQL2005
> Express.
> The client uses ActiveX SQLDMO.
> Wenn the client try to connect to the SQL Server an error is raised:
> [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server
> you must use SQL Server Management Studio or SQL Server Management Objects
> (SMO).
>
> So what can I do? Where can I find ActiveX SQLDMO that will work with SQL
> Server 2005 (Express) ???
> I already tried the new SQMDMO-Library that I found in the SQL2005
> <Installpath>\80\bin directory but the error is still raised.
>
> Thanks for all answers
>
> Martin
>


.



Relevant Pages

  • SQL 2005 (Express) - Cant connect with ActiveX SQLDMO
    ... The client uses ActiveX SQLDMO. ... must use SQL Server Management Studio or SQL Server Management Objects ... Where can I find ActiveX SQLDMO that will work with SQL ...
    (microsoft.public.sqlserver.clients)
  • SQL-Server 2005 (Express) cant connect with dmo-objects from Win2000-Client
    ... The client uses ActiveX SQLDMO. ... must use SQL Server Management Studio or SQL Server Management Objects ... Where can I find ActiveX SQLDMO that will work with SQL ...
    (microsoft.public.sqlserver.connect)
  • RE: VS 2005 Problems - Am I the Only One?
    ... I am afraid we don't support the SQL Server Management Studio here, ... OK, I got it, the default VS2005 editor's tab order doesn't meet the ... I will forward this feedback to our ...
    (microsoft.public.vsnet.general)
  • RE: Strange Behavior w SQL Server Management Studio
    ... > Alright I am having a couple of strange problems with SQL Server Management ... I am hitting a SQL Server 2000 box with no problem. ... In SS Management Studio I can attempt to run the ... > Line 1: Incorrect syntax near 'GO'. ...
    (microsoft.public.sqlserver.tools)
  • Strange Behavior w SQL Server Management Studio
    ... Alright I am having a couple of strange problems with SQL Server Management ... In SS Management Studio I can attempt to run the ... Line 1: Incorrect syntax near 'GO'. ...
    (microsoft.public.sqlserver.tools)