Access 64 bit driver?

[Gerhard K. Ziran]

I am looking for a driver for MS Access MDB databases that will run under
W2003/64.

I do have some ASP pages that either display data from or update data in MDB
files; unfortunately, on my new server (Windows 2003 R2 Enterprise 64bit,
SP2) they will not run, at least not with IIS in 64bit mode.

Is there a solution available for this problem?

TIA,
Gerd

 

[Sylvain Lafontaine]

See:
http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html

 

[Gerhard K. Ziran]

Thank Sylvain, but I do not run SQL Server.

I am looking for a way to make my Access-database based ASPs continue to
work; an example:

-->
strConnection = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("News.mdb") & ";DriverId=25;FIL=MS
Access;MaxBufferSize=512;PageTimeout=5;"

strSQL = "SELECT TOP 1 * FROM News WHERE Language='us' ORDER BY RecNumber
DESC"

Set conn = CreateObject("ADODB.Connection")
conn.Mode = 3
conn.Open strConnection
Set rs = CreateObject("ADODB.Recordset")
rs.Locktype = 3
rs.Open strSQL, conn
<--

which worked just fine under 32 bit OSs but under W2003/64 now results in

"ADODB.Connection error '800a0ea9' Provider is not specified and there is no
designated default provider."

Thanks,
Gerd
_________________________________________________________________________________

 

[Sylvain Lafontaine]

You don't run SQL-Server but you could install SQL-Server 2005 Express: it's
free and it installs in 32 bit mode.

Back to your specific question, there is no 64 bit driver for Access
actually available (for sure not from Microsoft but maybe you could find one
in the commercial area, I didn't check) and don't expect one anytime soon.
(To my limited knowledge, there is none in the pipeline and if there was
one, this information would probably be kept strictly confidential inside
MS.).

If you want to access an Access database on a 64 bit machine, your only
options are to either use the SQL-Server 2005 (or another program) as a
proxy or to switch IIS to the 32 bit mode. (Well, a third possibility would
be to find a commercial driver working in 64 bit mode but personally, I
don't know of anyone; however, if you search the internet, maybe you will
find one.).

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

Thank Sylvain, but I do not run SQL Server.

I am looking for a way to make my Access-database based ASPs continue to
work; an example:

-->
strConnection = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("News.mdb") & ";DriverId=25;FIL=MS
Access;MaxBufferSize=512;PageTimeout=5;"

strSQL = "SELECT TOP 1 * FROM News WHERE Language='us' ORDER BY RecNumber
DESC"

Set conn = CreateObject("ADODB.Connection")
conn.Mode = 3
conn.Open strConnection
Set rs = CreateObject("ADODB.Recordset")
rs.Locktype = 3
rs.Open strSQL, conn
<--

which worked just fine under 32 bit OSs but under W2003/64 now results in

"ADODB.Connection error '800a0ea9' Provider is not specified and there is
no designated default provider."

Thanks,
Gerd
_________________________________________________________________________________

 

[Gerhard K. Ziran]

Thank You, Sylvain, I dl it and have a look. You would not happen to have a
pointer to some intro instructions for accessing Jet database files through
SQL Server ?

Gerd

 

[Sylvain Lafontaine]

One exemple of such instructions was exactly what I gave you in my first
post:
http://gorm-braarvig.blogspot.com:80/2005/11/access-database-from-sql-200564.html

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

Thank You, Sylvain, I dl it and have a look. You would not happen to have
a pointer to some intro instructions for accessing Jet database files
through SQL Server ?

Gerd

 

[Gerhard K. Ziran]

.... of which I could make little sense. Anyway, thanks Sylvain, I am sure I
can work it out somehow.

Gerd

 

[Sylvain Lafontaine]

Making sense or not about an article is another story. If you don't know
about SQL-Server and T-SQL then yes, it must not be easy to understand that
article. In your case, I'm afraid that you will have to expand your
knowledge if you want to access an Access database from a program running in
64 bit mode. In all cases, this should not be seen as a bad thing and
knowing a little about SQL-Server and T-SQL is surely not a bad thing for
someone working with databases.

An easier solution would be to set up the IIS to run under the 32 bit mode.

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

... of which I could make little sense. Anyway, thanks Sylvain, I am sure
I can work it out somehow.

Gerd