32-Bit platform to a 64-Bit platform access form

I have a form which I'm moving from my old server to a 64Bit server, I keep
getting the HTTP 500 error, "cannot display the page". In the program (name.
asp) I had change the Provider

"MSDASQL;Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\wss\
VirtualDirectories\CompanyPortal\Forms\Progam\Prog ramName.mdb;"

And I had dowload the 64 bit driver MSDASQL, But it still not working. Do I
need to convert the Access database to SQL and use a SQL ODBC connection?

At this moment, all drivers/providers for Access/JET are exclusively 32 bit,
so you cannot access an Access/JET database from the 64 world; including if
you try to use the 64 bit MSDASQL provider to etablish a connection between
an ADO client (your ASP application) and an ODBC client.

First, in your case, for performance reason, as you are working with ADO,
you shouldn't use the MSDASQL Provider to call an ODBC provider and instead,
directly use the OLEDB Provider of Access/JET.

However, switching the provider will change nothing to your fundamental
problem; for which you have only three workable solutions:

1- Switch the IIS web server to run in the 32 bit mode instead of running in
the 64 bit mode.

If your application is an ASP.NET application and not an ASP Classic
application, you'll have to switch it too. To know how to performe these
steps, see the following article:

http://support.microsoft.com/kb/894435


2- or convert Access to SQL-Server.

3- Install the 32 bit version of SQL-Server Express and use it as a proxy
between IIS and your Access database.

Needless to say that the first one is the most easy of all three.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"Nupe02" u56284@uwe wrote in message news:9f4e7dcf5a72b@uwe...
I have a form which I'm moving from my old server to a 64Bit server, I keep
getting the HTTP 500 error, "cannot display the page". In the program
(name.
asp) I had change the Provider

"MSDASQL;Driver={Microsoft Access Driver (*.mdb)};
DBQ=C:\Inetpub\wwwroot\wss\
VirtualDirectories\CompanyPortal\Forms\Progam\Prog ramName.mdb;"

And I had dowload the 64 bit driver MSDASQL, But it still not working. Do
I
need to convert the Access database to SQL and use a SQL ODBC connection?