Re: problem with sql dataadapter wizard

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Cameron Slade (camslade_at_hotmail.com)
Date: 03/04/04 

Date: 4 Mar 2004 15:55:12 -0800

Hi Aleksandr,

Try the following.

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.

camsl@online.microsoft.com (Cameron Slade [MSFT]) wrote in message news:<7Ww$#khAEHA.2196@cpmsftngxa06.phx.gbl>...
> Hi Aleksandr,
>
> I don't think there is going to be an elegant solution to this problem but here are some things to try.
>
> Uninstall Visual Studio 2003
> Uninstall SQL Server Enterprise Manager if it is installed.
> Delete the following directories
> C:\Program Files\Common Files\Microsoft Shared\Visual Database Tools>
> C:\Program Files\Microsoft Visual Studio .NET 2003>
>
> Delete the Following hives from the registry
> HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\7.1
> \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.1
>
> Also search the registry for the following files and delete any keys that reference them.
> MSVCP71.DLL
> MSVCR71.DLL
> VDT70.DLL
> VDT70G.DLL
>
> Another approach to cleaning up the registry would be to use something like RegClean or RegScrub to clean up the registry. I have to warn you tools that mess with registry can be hazardous to your
> machine and may result in your machine being hosed.
>
> Other things that would be interesting to know are other MS products do you have installed or have been installed?
>
> 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.
> >>
> >
> >
> >
>
> Cameron Slade
> Microsoft VSData Team
> http://blogs.msdn.com/vsdata

Relevant Pages

  • Re: problem with sql dataadapter wizard
    ... But from VS Studio I still can't using SQLDataAdapter. ... studio on my computer it was ok with connection. ... from hard drive but before I copied all installation on dvd disk. ... >>Data Link. ...
    (microsoft.public.vsnet.enterprise.tools)
  • Re: problem with sql dataadapter wizard
    ... Uninstall Visual Studio 2003 ... >studio on my computer it was ok with connection. ... >from hard drive but before I copied all installation on dvd disk. ... >> Microsoft VSData Team ...
    (microsoft.public.vsnet.enterprise.tools)
  • Re: problem with sql dataadapter wizard
    ... But from VS Studio I still can't using SQLDataAdapter. ... >studio on my computer it was ok with connection. ... >from hard drive but before I copied all installation on dvd disk. ... >> Microsoft VSData Team ...
    (microsoft.public.vsnet.enterprise.tools)
  • Re: problem with sql dataadapter wizard
    ... So I just took them from dvd disk put at the same place ... But from VS Studio I still can't using SQLDataAdapter. ... >>studio on my computer it was ok with connection. ... >>from hard drive but before I copied all installation on dvd disk. ...
    (microsoft.public.vsnet.enterprise.tools)
  • Re: Visual C++ 6.0 - Article!!!!!!!
    ... > 'scratch' machine to see what the installation effects would be before ... a pretty easy upgrade, ... > studio registry tree yourself. ... > Don't let source safe 6.0 upgrade a shared database until everyone ...
    (microsoft.public.vc.mfc)