Re: problem with sql dataadapter wizard
From: Cameron Slade [MSFT] (camsl_at_online.microsoft.com)
Date: 03/04/04
- Previous message: Chris Langston: "Enterprise Templates and Inherited Forms using 1.5 Gig of Memory"
- In reply to: Aleksandr Vaysberg: "Re: problem with sql dataadapter wizard"
- Next in thread: Cameron Slade: "Re: problem with sql dataadapter wizard"
- Reply: Cameron Slade: "Re: problem with sql dataadapter wizard"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 04 Mar 2004 18:50:38 GMT
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 -- 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.
- Previous message: Chris Langston: "Enterprise Templates and Inherited Forms using 1.5 Gig of Memory"
- In reply to: Aleksandr Vaysberg: "Re: problem with sql dataadapter wizard"
- Next in thread: Cameron Slade: "Re: problem with sql dataadapter wizard"
- Reply: Cameron Slade: "Re: problem with sql dataadapter wizard"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
