Re: using ado drivers with 64 bits software



The is for the Itanium 64 bit, not the AMD or the Intel 64 bit. To my
knowledge (but I might be wrong) there won't be any 64 bit driver for JET;
probably because of security concerns.

In my opinion: either for the 32 or the 64 bit environment, it's usually a
bad idea to use a MDB file as your backend database when you could use
SQL-Server Express instead; even when this database has been first created
with Access. With its poor performance over a network, lack of security and
of fiability, the use of the MDB file format as the backend should only be
used inside a strictly confined Access environment, nothing else and even
then, the use of ODBC linked tables against a SQL-Server is probably a
better and safer option.

The fact that there is no 64 bit driver for JET at this moment and that
probably there will never be one should ring a little bell inside your ears.
See this as a wake up call.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:u8tuPN4UIHA.3364@xxxxxxxxxxxxxxxxxxxxxxx
I've heard conflicting reports. You might want to try asking the Access
experts in one of the Access groups.

Wait, I just did a google search and this came up:
http://thesource.ofallevil.com/downloads/details.aspx?familyid=AD2B6698-DE73-47DC-911B-50F4F0627FF4&displaylang=en

This only seems to be useful if you are using Windows Server.

Christophe 83 wrote:
Tank for you answer.
I understand that I can't use jet with 64 bits build.
Just one more question: do you know if Microsoft will develop a 64
bit jet drivers? if yes when can you expect have it? if no what
solution for read mdb data file with a 64 bit build software?

Thank.


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> a écrit dans le
message de news: utjdtouUIHA.3908@xxxxxxxxxxxxxxxxxxxxxxx
Christophe 83 wrote:
Hello,

I am using CRecordset foe acces .mdb file created with ms acces.
if I build my softwre on 32 bits all is fine
but when I make a 64 bit build I have a message who say that system
can't find data. In French message:
"Source de données introuvale et nom de pilote non spécifié".
What is the problem ? and how can I do.

Does anyone have an idea on this?
thanks in advance for the help
Christophe

You are out of luck. There is no 64-bit provider for Jet.

In order for IIS to use 32-bit drivers, you must flip it from 64-bit
to 32-bit.

http://support.microsoft.com/default.aspx?scid=kb;en-us;894435


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.

--
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: simple insert statement
    ... delimiters. ... It certainly is when you use the Jet 4 driver. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: 64-bit Version of Microsoft Access?
    ... The real problem is the absence of a 64 bit JET ODBC driver: ... IIS cannot access a mdb file because there is no 64 bit ODBC ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: 64-bit Version of Microsoft Access?
    ... no real implication for Access or JET other that they cannot call 64 ODBC ... The real problem is the absence of a 64 bit JET ODBC driver: ... IIS cannot access a mdb file because there is no 64 bit ODBC ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Wtite data immediately to mdb file
    ... > I wonder if that, by opening in the method I originally used, JET reads from ... >> 'Dim intCurrentRow As Integer ... >> but JET appears not to write the changes to the mdb file in time for the ... >>> I have a combobox which lists Keywords. ...
    (microsoft.public.vb.database.dao)
  • Re: Wtite data immediately to mdb file
    ... Many thanks for your reply Jim. ... I wonder if that, by opening in the method I originally used, JET reads from ... > but JET appears not to write the changes to the mdb file in time for the ... >> I have a combobox which lists Keywords. ...
    (microsoft.public.vb.database.dao)