Re: Help Please Wit Error
- From: "Gordo" <gmccague@xxxxxxxxx>
- Date: 30 May 2005 04:46:54 -0700
Hi Adam:
What kind of database system are you attempting to connect to?
Microsoft Access? SQL Server? Are you building a ASP.NET application or
a Windows Application?
Occasionally I receive the error you are mentioning when the SQL Server
you are connecting to only allows TCP/IP connections and not Named
Pipes (A secure SQL Server may be configured to not allow Named Pipes).
This is primarily my experience with Web Applications and I usually
have to install the SQL Network Client on the web server and set the
Enabled Protocols to TCP/IP in the SQL Server Network Utility.
I have had to completely remove the MDAC and re-install it as well
which can be tricky if you have Visual Studio installed. I don't know
if it has MDAC components as well.
Finally I also suggest that you confirm that the .NET SDK is also
properly installed. I find that problems with the .NET SDK can cause
problems in other systems such as MDAC.
Did you check your event log for any related items? It also may help to
see an example of the connection string you are using.
Cheers,
Gordon
P.S. I see that you email is @shaw.ca. A fellow Canadian! I don't
remember the last time I saw a clearly Canadian email address in
newsgroups.
Adam wrote:
> Hey Guys,
>
> I'm trying to create an application that uses an OLEDBConnection.
> Every time I try to run my app when I get to the opening of the
> connection I get this error.
>
> "The .Net Framework Data Providers require Microsoft Data Access
> Components (MDAC). Please install Microsoft Data Access Components
> (MDAC) version 2.6 or later."
>
> I have downloaded the latest version of MDAC (2.7) and installed it but
> i still get the same error. I downloaded this utility from MS and its
> supposed to check which version of MDAC i have installed and it says I
> have all of them installed from 2.1 to 2.8 sp1. It doesn't make any
> sense, I have used this type of connection before but i have formatted
> since so I'm not sure if there is some little setting that i missed or
> if i just got lucky last time. Any input will be greatly appreciated so
> thx in advance.
>
> - Adam
>
> P.S.
> I am running Windows XP Pro SP2 with Visual Studio .NET 2003 & Visual
> Studio .NET 2005 Beta 2. I had the same problem without VS.NET 2005
> installed I was kind of hoping that hen I installed VS.NET 2005 it would
> fix my problem but it didn't.
.
- References:
- Help Please Wit Error
- From: Adam
- Help Please Wit Error
- Prev by Date: Help Please Wit Error
- Next by Date: Read easyly emails from exchange
- Previous by thread: Help Please Wit Error
- Next by thread: Read easyly emails from exchange
- Index(es):
Relevant Pages
|
