|
I am getting error like
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later.
already in my system i have 2.7.
anybody help me. please
|
|
|
|
|
Hi, I Installed latest MDAC (2.8), already we have latest sqlserver sp(3a).
I created new database, I created new project.
Still i am getting error.
please solve it.
|
|
|
hi eshwar,
if all of this fails, it is clear the corruption is in your operating system environment. Reinstall your OS.
otherwise, test your application in another
server/computer.
|
|
|
|
|
I Think i was not explained my problem properly.
When i kept these files in to my server, it is giving error.
i have been seeing that error only for programs which are related to database.
I am able to see the o/p of non-database programs.
At the same time i am able to see all (database/non-database) outputs in my system. It is not giving any error.
My OS is XP professional. Server is windows 2000 server(5.0).
Let me know the solution please.
|
|
|
hi eshwar,
for your information.
***Microsoft Data Access Components (MDAC) 2.8 contains core Data Access components such as the Microsoft SQL Server OLE DB provider and ODBC driver. This redistributable installer for the MDAC 2.8 release installs the same Data Access components as Microsoft Windows Server 2003.
This release does not include Microsoft Jet, the Microsoft Jet OLE DB Provider or ODBC driver, the Desktop Database ODBC Drivers, or the Visual FoxPro ODBC Driver.
you can download latest redistributable installer by
clicking this link. http://downloads-zdnet.com.com/Microsoft-Data-Access-Components-MDAC-/3000-2404_2-10281285.html
try check out and update your MDAC.
read on each link contents. http://support.microsoft.com/?kbid=823718
|
|
|
|
|
I think i am distrubing you. But situation makes me to do like that. My problem is, my server is exchange 2000, in this mailserver(where my files are there) is there . I heared that if we load MDAC 2.8 and restart that server, there are some side effects like. So, Please explain, if we load MDAC 2.8 on ms-exchange 2000 , if we restart, are there any problems/ side effects. I am afraid to do that. Please explian in detial.
|
|
|
|
|
In that server we have MDAC 2.5, and my OS is windows 2000 with SP4.
<Added>
In my system it is XP professional
|
|
|
Did you ever resolve this problem?
I am getting exactly the same problem on a W2K SP4 Server (From XP client).
I have installed MDAC 2.8 on the server and reinstalled SP4. This has not made any difference.
Interestingly if I create a small VB.NET windows application to connect to and query my SQL Server it works fine.
If I try to do the same with the same code from ASP.NET it fails with the message
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later.
It is clearly lying!
Please help!
|
|
|
Each time I've seen this topic discussed, it is always a database connection problem of one sort or another.
I did a lot of searching, and found this:
"Ok I finally found out what caused the problem: Fasten your seatbelts:
The EXTRA.System-object conflcited with the SetWindowsHookEx-function. Both
of them worked fine, and there wasn't anything to see at it. But they caused
sometimes an error on the Database-Connection..."
|
|
|
|
|
hi,
I looked up this article but I'm not too sure how it would affect an ASP.NET application (and this may well be my limited understanding of differences between ASP.NET and VB.NET!). I'm also not sure how to use this article to cure my ailments
I think that I'm probably going to have to bite the bullet and reinstall the OS (my code used to work on this machine...) but this forum has made interesting reading
Cheers!
|
|
|
hi
I'm facing this problem
The .Net Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components(MDAC) version 2.6 or later
plz get me out of this.Mine is SQL7.0
thanks
|
|
|
I just spent 3 weeks trying to fix this problem, uninstalled and reinstalled .Net, IIS, etc. Put in a support call and spent 8 hours working with good MS support people. They tried all sorts of stuff, but nothing worked, and they were running out of ideas. I finally came up with a solution today:
- Back up anything you have in \Inetpub
- Uninstall VS .Net
- Uninstall .Net Framework
- Uninstall IIS
- Delete the entire \Inetpub folder
- Reinstall IIS, .Net Framework, and VS .Net
The key was deleting \Inetpub before reinstalling IIS, so that it was recreated with default permissions and components. I had done the same steps at least 5 times except for deleting \Inetpub, with no success.
I know this sounds drastic, but it worked after everything else failed including MS tech support. The only Knowledgebase article on this error says you need to install MDAC, which was useless. Since I am running XP SP2, I have MDAC 2.8 by default.
|
|
|