Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?

Thanks Bob for all your answers !

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> a écrit dans le message de news:ufOFMhgzHHA.3772@xxxxxxxxxxxxxxxxxxxxxxx
I spent an hour searching for the answers to these questions this morning. Unfortunately, my answers, as of today, have to be :
1. Yes
2. Yes - although that WS2003 patch does provide some hope that they will release one for Vista.

BaCAD wrote:
thanks for your answer, I juste need to clarify and can you confirm :

1. Jet is not 64 bits compatible, thus a 64 bits application can't
use Jet provider to connect to a MS Access database
2. there is no other provider available to connect to MS Access
database
thanks for your help

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> a écrit dans le
message de news:%230AUUzfzHHA.3848@xxxxxxxxxxxxxxxxxxxxxxx
Oops, Sorry, my bad.
I'm sorry but I can find no solution for you, outside of extracting
your data from your Jet database and putting it into a database that can
be accessed by 64-bit applications. MSDE or SQL Server Express come to
mind given that they are free to use.

BaCAD wrote:
1. the link install Jet for Windows 2003 Server 64bits, and I am
using Windows Vista 64 bits, thus the program actually won't install on
Vista -> error message incompatible system

2. I saw on msdn forum a lot of articles indicating that there is
actually no version of Jet for Vista 64 bits and that MS won't
release a 64 bit
version of Jet, so I need to connect to MS Access DB with an other
provider.


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> a écrit dans le
message de news:%23jh5BwTzHHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
Not use Jet ... ??? It's a Jet database. What else would you use?

BaCAD wrote:
Yes, I forgot to mention, that I don't want to use Jet !
Any other suggestions ?
thx


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> a écrit dans le
message de news:%23HNokMSzHHA.5408@xxxxxxxxxxxxxxxxxxxxxxx
BaCAD wrote:
hello

I need to know which ADO provider I can use to connect to MS
Access Database under Windows Vista 64 bits.

http://www.microsoft.com/downloads/details.aspx?familyid=ad2b6698-de73-47dc-911b-50f4f0627ff4&displaylang=en


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap
so I don't check it very often. If you must reply off-line, then
remove the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?
    ... release one for Vista. ... Jet is not 64 bits compatible, thus a 64 bits application can't ... use Jet provider to connect to a MS Access database ... This email account is my spam trap so ...
    (microsoft.public.data.ado)
  • Re: RecordSet fails if a field is null ! - unspecified error 80004005
    ... Could your database be corrupt? ... Maybe something is wrong with your Jet components. ... Access group for pointers to that). ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?
    ... data from your Jet database and putting it into a database that can be ... Access Database under Windows Vista 64 bits. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: ACCESS and ASP
    ... you should be aware that earlier versions of Jet required a "*" ... > Please post ASP questions in ASP groups, ... > When you delete a record from a database, ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Which ADO provider to use to connect to MS Access DB under Vista x64 ?
    ... I just converted one of my NWind.mdb databases using Access 2007 and it created an entirely new database file with a new extension. ... Now the JET 4.0 OLE DB provider won't open it. ... Yes - although that WS2003 patch does provide some hope that they will release one for Vista. ... This email account is my spam trap so ...
    (microsoft.public.data.ado)