Using System.Data under Windows x64?

[Sin Jeong-hun]

The default configuration is "Any CPU". As long as I've observed, the
result exe will run as 32bit under 32bit Windows, and 64bit under
Windows x64.

I tried to use Access mdb under Windows x64, by using;
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; data source=...

Then an error message popped up saying that there is no such provider.
I searched the internet for this matter and found that Jet.OLEDB.4.0 is
a 32bit driver so it doesn't work with 64bit applications. So I had to
compile my application for 'x86' then it worked fine.

The question is, there is no the 64 bit driver for MDB? So 64bit .NET
applications can't access MDB? If there is a way, please let me know.
Thanks.

[Laura T]

According to this post at
http://forums.microsoft.com/msdn/sho...85703&siteid=1, no,
there is not and will not be.

"
There is no way to access a .mdb database from 64bit.
It has been decided to not port the Microsoft Jet Database engine to 64Bit.

Brad Rhodes
This message is provided as is....


--------------------------------------------------------------------------------

Lead PM Microsoft Data Access Programmming
"
"Sin Jeong-hun" <ty*******@gmail.comha scritto nel messaggio
news:11**********************@s13g2000cwa.googlegr oups.com...

The default configuration is "Any CPU". As long as I've observed, the
result exe will run as 32bit under 32bit Windows, and 64bit under
Windows x64.

I tried to use Access mdb under Windows x64, by using;
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; data source=...

Then an error message popped up saying that there is no such provider.
I searched the internet for this matter and found that Jet.OLEDB.4.0 is
a 32bit driver so it doesn't work with 64bit applications. So I had to
compile my application for 'x86' then it worked fine.

The question is, there is no the 64 bit driver for MDB? So 64bit .NET
applications can't access MDB? If there is a way, please let me know.
Thanks.