Access 64 bit driver?

G

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
 
G

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
_________________________________________________________________________________
 
S

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)


Gerhard K. Ziran said:
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
_________________________________________________________________________________
 
G

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
 
S

Sylvain Lafontaine

G

Gerhard K. Ziran

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

Gerd
 
S

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)


Gerhard K. Ziran said:
... of which I could make little sense. Anyway, thanks Sylvain, I am sure
I can work it out somehow.

Gerd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top