Re: problem with sql dataadapter wizard

From: Cameron Slade [MSFT] (camsl_at_online.microsoft.com)
Date: 03/04/04

  • Next message: Cameron Slade: "Re: problem with sql dataadapter wizard" 
    Date: Thu, 04 Mar 2004 22:12:02 GMT

    Hey Aleksandr

    Here is a less drastic approach than my other response. Try the following to see if it fixes the problem.

    regsvr32 C:\Program Files\Microsoft Visual Studio .Net 2003\Common7\Tools\VDT\vdt70p.dll

    Cameron Slade
    Microsoft VSData Team
    http://blogs.msdn.com/vsdata 

    -- 
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm 
Note:  For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.  
--------------------
>From: "Aleksandr Vaysberg" <alex197@netzero.net>
>References: <e43mwAp#DHA.2072@TK2MSFTNGP11.phx.gbl> <xrMl0kK$DHA.2452@cpmsftngxa06.phx.gbl> <##ZmjYN$DHA.3452@TK2MSFTNGP11.phx.gbl> <EYon#eKAEHA.612
@cpmsftngxa06.phx.gbl>
>Subject: Re: problem with sql dataadapter wizard
>Date: Tue, 2 Mar 2004 23:34:07 -0500
>Lines: 190
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <#OC#BjNAEHA.640@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.vsnet.enterprise.tools
>NNTP-Posting-Host: 1Cust232.tnt5.nyc9.da.uu.net 67.192.228.232
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.vsnet.enterprise.tools:1928
>X-Tomcat-NG: microsoft.public.vsnet.enterprise.tools
>
>Hi Cameron!
>
>Thanks for the answer on my problem. I just created empty test.udl file, and
>did all that you told me. When I've clicked on Test button it's show me that
>connection is Ok. But from VS Studio I still can't using SQLDataAdapter. The
>same error.
>I'm using VS.net Enterprise Architecture 2003. When I first time installed
>studio on my computer it was ok with connection.
>
>But I installed studio from my hard drive (at this time I didn't had a dvd
>writer) and then (when I've bought dvd writer) I've  deleted installation
>from hard drive but before I copied all installation on dvd disk. Then, I
>reinstalled studio because it's required in some cases dvd disk, but didn't
>recognized. I thought that happened because I' ve installed studio from hard
>drive. So after I reinstalled studio from dvd disk - I got this problem.
>I've remember that I had couple of issues while second installation - first
>of them: in the middle of process I got an error message insert the Visual
>Studio .NET Architect Enterprise 2003 English-DVD for file vdt70vcs.dll. I
>was forced again copied all stuff on hard drive:) Second issue was that
>studio told me that cannot be created odbc connection with database
>xtrasamples.mdb. I've tried 2 times reinstalled studio-the same result:(
>
>I don't have any version of ms office 2003
>Help me please
>
>"Cameron Slade [MSFT]" <camsl@online.microsoft.com> wrote in message
>news:EYon%23eKAEHA.612@cpmsftngxa06.phx.gbl...
>> Hi Aleksandr,
>>
>> If you don't have the reg files there is another way we can test to see if
>OLEDB is installed and working correctly.  Create a file called Test.UDL and
>then open it by double clicking on it.  This should
>> launch the Data Links Properties dialog.  Fill in all of the connection
>data for the SQL Server you are trying to connect to and Test the
>connection.  Let me know what happens.
>>
>> There are a couple of other things that I would like to know.  What
>version of Visual Studio is this?  Where you able to connect to SQL Server
>via the Server Explorer before you uninstalled?  Have
>> you ever installed a version of Office 2003, beta or RTM?
>>
>> Cameron Slade
>> Microsoft VSData Team
>> http://blogs.msdn.com/vsdata
>> -- 
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>rights. Use of included script samples are subject to the terms specified at
>http://www.microsoft.com/info/cpyright.htm
>> Note:  For the benefit of the community-at-large, all responses to this
>message are best directed to the newsgroup/thread from which they
>originated.
>> --------------------
>> >From: "Aleksandr Vaysberg" <alex197@netzero.net>
>> >References: <e43mwAp#DHA.2072@TK2MSFTNGP11.phx.gbl>
><xrMl0kK$DHA.2452@cpmsftngxa06.phx.gbl>
>> >Subject: Re: problem with sql dataadapter wizard
>> >Date: Thu, 26 Feb 2004 21:05:20 -0500
>> >Lines: 92
>> >X-Priority: 3
>> >X-MSMail-Priority: Normal
>> >X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>> >Message-ID: <##ZmjYN$DHA.3452@TK2MSFTNGP11.phx.gbl>
>> >Newsgroups: microsoft.public.vsnet.enterprise.tools
>> >NNTP-Posting-Host: 1Cust170.tnt7.nyc9.da.uu.net 67.192.230.170
>> >Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
>> >Xref: cpmsftngxa06.phx.gbl microsoft.public.vsnet.enterprise.tools:1895
>> >X-Tomcat-NG: microsoft.public.vsnet.enterprise.tools
>> >
>> >
>> >Hi!
>> >
>> >Thanks for your answer. My Windows is Win XP Prof, so I don't have
>> >newudl.reg file in this folder. When I click on Data Connection and
>select
>> >new connect with right click-nothing happens at all. But, when I select
>Add
>> >Connection it's give this error message.
>> >
>> >"Cameron Slade [MSFT]" <camsl@online.microsoft.com> wrote in message
>> >news:xrMl0kK$DHA.2452@cpmsftngxa06.phx.gbl...
>> >> Hi,
>> >>
>> >> I am not sure what the problem might be but I do have a couple of ideas
>on
>> >where to start.  The first think I would to is see if OLEDB is installed
>> >correctly.  The easiest way to do that is to go to  C:
>> >> \Program Files\Common Files\System\Ole DB and run newudl.reg.  Next go
>to
>> >your window desktop or any folder and right click and select
>New->Microsoft
>> >Data Link.  Double click the data link and
>> >> see if you can configure a new connection and then test the connection.
>> >If you want to disable the New->Data Link functionality run nonewudl.reg.
>> >>
>> >> Also what happen when you right click on Data Connections in the Server
>> >Explore and select new connect.  Can you create a new connection?
>> >>
>> >> Let me know what you find and we can continue to troubleshoot.
>> >> Cameron Slade
>> >> Microsoft VSData Team
>> >> -- 
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >rights. Use of included script samples are subject to the terms specified
>at
>> >http://www.microsoft.com/info/cpyright.htm
>> >>
>> >> Note:  For the benefit of the community-at-large, all responses to this
>> >message are best directed to the newsgroup/thread from which they
>> >originated.
>> >> --------------------
>> >> >From: "Aleksandr Vaysberg" <alex197@netzero.net>
>> >> >Subject: problem with sql dataadapter wizard
>> >> >Date: Mon, 23 Feb 2004 23:39:32 -0500
>> >> >Lines: 19
>> >> >X-Priority: 3
>> >> >X-MSMail-Priority: Normal
>> >> >X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>> >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>> >> >Message-ID: <e43mwAp#DHA.2072@TK2MSFTNGP11.phx.gbl>
>> >> >Newsgroups: microsoft.public.vsnet.enterprise.tools
>> >> >NNTP-Posting-Host: 1Cust144.tnt5.nyc9.da.uu.net 67.192.228.144
>> >> >Path:
>>
>>cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP
>0
>> >8.phx.gbl!TK2MSFTNGP11.phx.gbl
>> >> >Xref: cpmsftngxa06.phx.gbl
>microsoft.public.vsnet.enterprise.tools:1863
>> >> >X-Tomcat-NG: microsoft.public.vsnet.enterprise.tools
>> >> >
>> >> >Hi all!
>> >> >
>> >> >I've reinstalled studio 2003 and got a problem. If I hard coded
>> >connection
>> >> >to my ms sql 2000 database-it's works ok.But I can't using wizard-when
>I
>> >use
>> >> >SQLDataadapter wizard and click on new connection button I getting an
>> >error
>> >> >message:
>> >> >
>> >> >The following exception has occurred:
>> >> >ArgumentNullException: Value Cannot be NULL. Parameter
>dataViweManager.
>> >> >
>> >> >
>> >> >And also-in server explorer, if I click on plus sign near the sql
>> >> >server-it's doesn't expand and instead I see a red cross sign.
>> >> >
>> >> >How to fix?
>> >> >
>> >> >Thanks
>> >> >
>> >> >
>> >> >
>> >>
>> >> Cameron Slade
>> >> Microsoft VSData Team
>> >> -- 
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >rights. Use of included script samples are subject to the terms specified
>at
>> >http://www.microsoft.com/info/cpyright.htm
>> >>
>> >> Note:  For the benefit of the community-at-large, all responses to this
>> >message are best directed to the newsgroup/thread from which they
>> >originated.
>> >>
>> >
>> >
>> >
>>
>> Cameron Slade
>> Microsoft VSData Team
>> -- 
>>
>> This posting is provided "AS IS" with no warranties, and confers no
>rights. Use of included script samples are subject to the terms specified at
>http://www.microsoft.com/info/cpyright.htm
>>
>> Note:  For the benefit of the community-at-large, all responses to this
>message are best directed to the newsgroup/thread from which they
>originated.
>>
>
>
>
  • Next message: Cameron Slade: "Re: problem with sql dataadapter wizard"