Connecting to MS Access database from ASP in Windows Server 2003 64-bit

I'm setting up a Windows Server 2003 64-bit machine for a user. It will be
serving ASP forms with MS Access as its back-end database.

I created a simple ASP webpage and it is displayed without any problem.

I created a MS Access database on the server and a ASP webpage to connect
to the database.

I attempted to create a system DSN. However, an ODBC Driver for MS Access
was not available; only the driver for a SQL Server was available.

So, I decided to use DSN-less. I used a connection string with
"Provider=Microsoft.Jet.OLEDB.4.0." in the ASP file. When I launched this
ASP file, the log file shows a "Provider cannot be found" error. I used
"Driver={Microsoft Access Driver (*.mdb)}.... When I launch this ASP file,
the log file shows a "Provider is not specified" error.

I read something about Microsoft Jet not available for 64-bit machine, but
Microsoft will be providing it later. Is there a 64-bit ODBC driver for
Microsoft Access?

Or, do I enable IIS to run 32-bit application for this ASP application to
run? If this need to be done, I do this by using the instruction in
http://www.microsoft.com/technet/prodtechnol/WindowsServer20 03/Library/IIS/405f5bb5-87a3-43d2-8138-54b75db73aa1.mspx?mfr =true?
Will this making the ODBC driver for MS Access appear as a choice for system
DSN? Will it allow me to connect to the database using DSN-less? Is there
anything else that I need to do after enabling the setting?

This is new territory for me. I have set up file servers. This is my first
Windows application server, and I'm not an ASP programmer but I'm learning.
Thank you for your assistance.

Re: Connecting to MS Access database from ASP in Windows Server 2003 64-bit

Michael W White wrote:
> I'm setting up a Windows Server 2003 64-bit machine for a user. It will be
> serving ASP forms with MS Access as its back-end database.
>
> I created a simple ASP webpage and it is displayed without any problem.
>
> I created a MS Access database on the server and a ASP webpage to connect
> to the database.
>
> I attempted to create a system DSN. However, an ODBC Driver for MS Access
> was not available; only the driver for a SQL Server was available.
>
> So, I decided to use DSN-less. I used a connection string with
> "Provider=Microsoft.Jet.OLEDB.4.0." in the ASP file. When I launched this
> ASP file, the log file shows a "Provider cannot be found" error. I used
> "Driver={Microsoft Access Driver (*.mdb)}.... When I launch this ASP file,
> the log file shows a "Provider is not specified" error.
>
> I read something about Microsoft Jet not available for 64-bit machine, but
> Microsoft will be providing it later. Is there a 64-bit ODBC driver for
> Microsoft Access?
>
> Or, do I enable IIS to run 32-bit application for this ASP application to
> run? If this need to be done, I do this by using the instruction in
> http://www.microsoft.com/technet/prodtechnol/WindowsServer20 03/Library/IIS/405f5bb5-87a3-43d2-8138-54b75db73aa1.mspx?mfr =true?
> Will this making the ODBC driver for MS Access appear as a choice for system
> DSN? Will it allow me to connect to the database using DSN-less? Is there
> anything else that I need to do after enabling the setting?
>
> This is new territory for me. I have set up file servers. This is my first
> Windows application server, and I'm not an ASP programmer but I'm learning.
> Thank you for your assistance.

Here's your answer:

http://groups.google.co.uk/group/microsoft.public.inetserver .asp.general/browse_frm/thread/eded8c3e36dfe51/6e4ddc74c6ac2 242?q=jet+64+bit&rnum=1#6e4ddc74c6ac2242

--
Mike Brind

Re: Connecting to MS Access database from ASP in Windows Server 2003 64-bit

Thank you. That worked.

"Mike Brind" wrote in message
news:1150375367.450115.211090@f6g2000cwb.googlegroups.com...
>
> Michael W White wrote:
>> I'm setting up a Windows Server 2003 64-bit machine for a user. It will
>> be
>> serving ASP forms with MS Access as its back-end database.
>>
>> I created a simple ASP webpage and it is displayed without any problem.
>>
>> I created a MS Access database on the server and a ASP webpage to
>> connect
>> to the database.
>>
>> I attempted to create a system DSN. However, an ODBC Driver for MS
>> Access
>> was not available; only the driver for a SQL Server was available.
>>
>> So, I decided to use DSN-less. I used a connection string with
>> "Provider=Microsoft.Jet.OLEDB.4.0." in the ASP file. When I launched this
>> ASP file, the log file shows a "Provider cannot be found" error. I used
>> "Driver={Microsoft Access Driver (*.mdb)}.... When I launch this ASP
>> file,
>> the log file shows a "Provider is not specified" error.
>>
>> I read something about Microsoft Jet not available for 64-bit machine,
>> but
>> Microsoft will be providing it later. Is there a 64-bit ODBC driver for
>> Microsoft Access?
>>
>> Or, do I enable IIS to run 32-bit application for this ASP application
>> to
>> run? If this need to be done, I do this by using the instruction in
>> http://www.microsoft.com/technet/prodtechnol/WindowsServer20 03/Library/IIS/405f5bb5-87a3-43d2-8138-54b75db73aa1.mspx?mfr =true?
>> Will this making the ODBC driver for MS Access appear as a choice for
>> system
>> DSN? Will it allow me to connect to the database using DSN-less? Is there
>> anything else that I need to do after enabling the setting?
>>
>> This is new territory for me. I have set up file servers. This is my
>> first
>> Windows application server, and I'm not an ASP programmer but I'm
>> learning.
>> Thank you for your assistance.
>
> Here's your answer:
>
> http://groups.google.co.uk/group/microsoft.public.inetserver .asp.general/browse_frm/thread/eded8c3e36dfe51/6e4ddc74c6ac2 242?q=jet+64+bit&rnum=1#6e4ddc74c6ac2242
>
> --
> Mike Brind
>