Generate Access Report in Microsoft Azure
I an absolute newbie in Web based programs in Microsoft Azure.
I now have a Web based program. It was developed for me in India, and is based on PHP.
The program has just been moved from the test environment in India, to my account in Microsoft Azure in Sydney. It generates reports (Both PDF files and Excel Files), which all work fine except one.
This is a generated Microsoft Access report. It comes up with the error report not available.
I was told that you need a virtual machine running in Azure to generate this report, so I managed to get a virtual machine running, in my account in Azure.
But the report still does not work. I would be grateful for any ideas
I now have a Web based program. It was developed for me in India, and is based on PHP.
The program has just been moved from the test environment in India, to my account in Microsoft Azure in Sydney. It generates reports (Both PDF files and Excel Files), which all work fine except one.
This is a generated Microsoft Access report. It comes up with the error report not available.
I was told that you need a virtual machine running in Azure to generate this report, so I managed to get a virtual machine running, in my account in Azure.
But the report still does not work. I would be grateful for any ideas
ASKER
One further comment: The error message has now changed to "Could not find driver"
Glad you added the additional comments, as it changed the answer significantly.
Even with that, I am not sure I understand the setup fully, but from the error message it sounds like your missing the ODBC or OLEDB driver for ACE (Access's default database engine).
To get that driver, you can install this:
Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Note that this comes in a 32 or 64 bit version. The version of the OS does not matter, but what program is making the call.
A 32 bit program even though it may be running under a 64 bit OS, will need 32 bit drivers. Likewise a 64 bit program needs 64 bit drivers.
Jim.
Even with that, I am not sure I understand the setup fully, but from the error message it sounds like your missing the ODBC or OLEDB driver for ACE (Access's default database engine).
To get that driver, you can install this:
Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Note that this comes in a 32 or 64 bit version. The version of the OS does not matter, but what program is making the call.
A 32 bit program even though it may be running under a 64 bit OS, will need 32 bit drivers. Likewise a 64 bit program needs 64 bit drivers.
Jim.
ASKER
Hi Jim,
I Think you are correct, however:
1. The program designers in India have offered to fix it for me. so I will wait to see how they go,
2. Your download link, as I understand it, only downloads the driver into my computer. I think I need it downloaded into Azure. So I would need more information to be able to do it myself.
Thank you for your input.
I will be back in touch in a week or so regardless of the outcome.
I Think you are correct, however:
1. The program designers in India have offered to fix it for me. so I will wait to see how they go,
2. Your download link, as I understand it, only downloads the driver into my computer. I think I need it downloaded into Azure. So I would need more information to be able to do it myself.
Thank you for your input.
I will be back in touch in a week or so regardless of the outcome.
1. That's good!
2. You would download that driver onto the machine that is running the web program. Azure (SQL Server in the cloud) and a JET/ACE database are simply data stores; you need the driver to talk to them. It's:
Program ----> driver -----> data store.
The data store may or may not be on a different server, but the driver must be installed where the program is running.
Jim.
2. You would download that driver onto the machine that is running the web program. Azure (SQL Server in the cloud) and a JET/ACE database are simply data stores; you need the driver to talk to them. It's:
Program ----> driver -----> data store.
The data store may or may not be on a different server, but the driver must be installed where the program is running.
Jim.
ASKER
Hi Jim,
The program designers in India have tried to fix it, but have run into problems. They have just sent me the following email:
“For the MS Access file to work we need to have ODBC driver. In our visibility environment (the environment we shared with you), we have the ODBC server in our environment.
But in the virtual machine we created in MS Azure we could not find one Usually ODBC will be present in Virtual machines . We tried to contact the Azure team but we cannot contact their technical support team using the current “Pay Per Go” subscription model
So please ask Azure support team why ODBC server is not available and how to enable it.”
I have attached a screen shot of my Azure account. I would be grateful if you could give me some information re the following questions:
1. Why ODBC server is not available and how to enable it?
2. Do I need the virtual machine, or just the ODBC Driver?
3. I have no database listed in the Azure account, so the database the website runs on must be in the cloud service or the storage account?
Sorry to be a bother, I really am a newbie, and I am very confused!
Azure-.jpg
The program designers in India have tried to fix it, but have run into problems. They have just sent me the following email:
“For the MS Access file to work we need to have ODBC driver. In our visibility environment (the environment we shared with you), we have the ODBC server in our environment.
But in the virtual machine we created in MS Azure we could not find one Usually ODBC will be present in Virtual machines . We tried to contact the Azure team but we cannot contact their technical support team using the current “Pay Per Go” subscription model
So please ask Azure support team why ODBC server is not available and how to enable it.”
I have attached a screen shot of my Azure account. I would be grateful if you could give me some information re the following questions:
1. Why ODBC server is not available and how to enable it?
2. Do I need the virtual machine, or just the ODBC Driver?
3. I have no database listed in the Azure account, so the database the website runs on must be in the cloud service or the storage account?
Sorry to be a bother, I really am a newbie, and I am very confused!
Azure-.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just to be clear for future readers, I'd like to point out that creating a DSN within Access is not the fix per say for the original problem despite what the last comment implies.
While you certainly can create a DSN connection in Access or even make ODBC connections without a DSN, to use ODBC and establish a connection to a database, a driver must be installed. Without Access itself being installed on the machine, one way to get those drivers is via the Microsoft Access Database Engine 2010 Redistributable package.
Jim.
While you certainly can create a DSN connection in Access or even make ODBC connections without a DSN, to use ODBC and establish a connection to a database, a driver must be installed. Without Access itself being installed on the machine, one way to get those drivers is via the Microsoft Access Database Engine 2010 Redistributable package.
Jim.
ASKER
The program designers were able to talk directly to Microsoft and the issue has been resolved.
ASKER