By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,033 Members | 1,285 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,033 IT Pros & Developers. It's quick & easy.

Cannot Get VB.Net Standard to connect to a MSAccess Database.

P: n/a
Hi,

I am trying to create an ASP page in MS Visual Basic .NET Standard 2003.

But every time I put an OleDbDataAdapter on a Component1 and go through the
Data Adapter Configuration Wizard I receive the following error when I
enter the SQL to select some records.

The connection could not be opened because of the following error:

The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data
Access Components(MDAC) version 2.6 or later. Version 2.50.4403.8 was found
currently installed...

I have since installed MDAC 2.7 but still get this error message.

Can any one help

--

Many Thanks for your time
Mark


Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Certainly.

In your application, go into the references section. You will likely find
that 2.5 is still being referenced. Remove that reference and add a
reference for 2.6 instead.

--
Gerry O'Brien [MVP]
Visual Basic .NET(VB.NET)


"Mark" <mp*********@NOSPAMbtopenworld.com> wrote in message
news:u3**************@TK2MSFTNGP15.phx.gbl...
Hi,

I am trying to create an ASP page in MS Visual Basic .NET Standard 2003.

But every time I put an OleDbDataAdapter on a Component1 and go through
the Data Adapter Configuration Wizard I receive the following error when
I enter the SQL to select some records.

The connection could not be opened because of the following error:

The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data
Access Components(MDAC) version 2.6 or later. Version 2.50.4403.8 was
found currently installed...

I have since installed MDAC 2.7 but still get this error message.

Can any one help

--

Many Thanks for your time
Mark

Nov 21 '05 #2

P: n/a
Hi Mark
You need to update the reference in your visual studio to reference the
new version of the MDAC dll , this is not done by default when you install
a new version as you might have applications that are dependant on the
older version. Hope this explains it.

Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC

Nov 21 '05 #3

P: n/a
In VB 6 I would go to Tools>References

How do I do this in .NET?

Thanks
Mark.

"Gerry O'Brien [MVP]" <gerry dot obrien at gmail dot com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Certainly.

In your application, go into the references section. You will likely find
that 2.5 is still being referenced. Remove that reference and add a
reference for 2.6 instead.

--
Gerry O'Brien [MVP]
Visual Basic .NET(VB.NET)


"Mark" <mp*********@NOSPAMbtopenworld.com> wrote in message
news:u3**************@TK2MSFTNGP15.phx.gbl...
Hi,

I am trying to create an ASP page in MS Visual Basic .NET Standard 2003.

But every time I put an OleDbDataAdapter on a Component1 and go through
the Data Adapter Configuration Wizard I receive the following error when
I enter the SQL to select some records.

The connection could not be opened because of the following error:

The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data
Access Components(MDAC) version 2.6 or later. Version 2.50.4403.8 was
found currently installed...

I have since installed MDAC 2.7 but still get this error message.

Can any one help

--

Many Thanks for your time
Mark


Nov 21 '05 #4

P: n/a
In solution explorer on the right, you will see a References section.
Expand it to see current reference and select the old version and delete it.
Then right click and choose Add Reference.

--
Gerry O'Brien [MVP]
Visual Basic .NET(VB.NET)


"Mark" <mp*********@NOSPAMbtopenworld.com> wrote in message
news:Os**************@TK2MSFTNGP09.phx.gbl...
In VB 6 I would go to Tools>References

How do I do this in .NET?

Thanks
Mark.

"Gerry O'Brien [MVP]" <gerry dot obrien at gmail dot com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Certainly.

In your application, go into the references section. You will likely
find that 2.5 is still being referenced. Remove that reference and add a
reference for 2.6 instead.

--
Gerry O'Brien [MVP]
Visual Basic .NET(VB.NET)


"Mark" <mp*********@NOSPAMbtopenworld.com> wrote in message
news:u3**************@TK2MSFTNGP15.phx.gbl...
Hi,

I am trying to create an ASP page in MS Visual Basic .NET Standard 2003.

But every time I put an OleDbDataAdapter on a Component1 and go through
the Data Adapter Configuration Wizard I receive the following error
when I enter the SQL to select some records.

The connection could not be opened because of the following error:

The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data
Access Components(MDAC) version 2.6 or later. Version 2.50.4403.8 was
found currently installed...

I have since installed MDAC 2.7 but still get this error message.

Can any one help

--

Many Thanks for your time
Mark



Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.