tristan
Registered: 01/13/09
Posts: 419
|
| | 11/02/09 at 05:27 AM | Reply with quote | #1 |
|
Hi, Guys
I had to use MS Access as the backen for a site so they could fiddle and create there own reports and things outside of the data entry site.
(Thats why i have had to use ACCESS  )
So the story is this.
SBS server 2008 64bit.
Site loaded on fine. Got the MDAC error!
Server 2008 is now WDAC and not MDAC. (which is allready loaded with the OS!)
Created a new app POOL.
Changed the site over to 32bit in the app pool....
Fixed the error with an exchange componant disabling the app pool/stopping it.
So im back to the site loading in 32bit but still i get the error MDAC is missing. I have given file permissions to the IUSR account.
So i presume it can get access to the file.
Im lost any help would be much appreciated!
Thanks
Tristan
__________________
http://www.auzsolutions.com.au |
| Loading... | |
timt
Iron Speed MVP
The software house that trust built
Registered: 08/06/05
Posts: 1,330
|
| | 11/02/09 at 06:07 AM | Reply with quote | #2 |
|
Hi Tristan
I am not sure if its related but in the past we have had funny goings on with 64bit stuff (sql data access stuff) and ended up downloading 64/32 bit updates from Microsoft to get round them.
Maybe worth checking with them.
__________________
Tim Titchmarsh
Dot Net Architect
UK Iron Speed MVP
Consulting Organisation
+44 (0)1621 835002
http://www.dotnetarchitect.co.uk
timt@dotnetarchitect.co.uk |
| Loading... | |
tristan
Registered: 01/13/09
Posts: 419
|
| | 11/02/09 at 04:34 PM | Reply with quote | #3 |
|
Hi, Tim
Thanks for the response. It turns out that IIS on SBS Server 2008 is EXTREMLY touchy because it integrates with Exchange Server.
Basically everything on the SBS Server is 64bit so unless you have 32bit data connectors i would forget about it.
I have gotten around this by installing iis on an xp pro box and setting the other machines to go to that machine.
Clearly not the intended objective BUT, nothing else can do about it when Microsoft them selves dont make 64bit connectors for there software.
Someone wrote on the web, MS ACCESS shouldnt be used as a web database, this is partly true.
If IIS was on a standard server box or web server box then MS ACCESS would be fine.
If It was a low transactions database, (less then 50-100 entries a day) then i would also say it is fine.
But if you were both of the above then it would be an ISSUE!
And you would have to go over to another DB type.
One that has a connector like MS SQL or MYSQL!
In the end i would like to thank microsoft for ounce again making the IT Industry fun and exciting!
Peace out.
Tristan
__________________
http://www.auzsolutions.com.au |
| Loading... | |
JimiJ
MVP Developer
Registered: 03/30/05
Posts: 4,400
|
| | 11/04/09 at 02:46 AM | Reply with quote | #4 |
|
Tristan,
There are 5 important things you need to make sure MS Access works with 64-bit OS (IIS7/7.5):
1) Use Classic.Net AppPool with Enabled 32-Bit Application
2) Remove "mode=16" from Web.Config connectionString
3) Write Access to - Users (ServerName\Users)
4) Enabled Anonymous Authentication
5) Enabled ASP.Net Impersonation
Cheers,
Jimi
__________________
Jaime Jegonia
JimiTron Software
JimiTron.Net | JimiTron.Com |
| Loading... | |
porphi
Registered: 09/07/05
Posts: 1,210
| |
tristan
Registered: 01/13/09
Posts: 419
|
| | 11/04/09 at 05:58 AM | Reply with quote | #6 |
|
The drivers were not the real issue.
This is the real issue.
http://www.fmforums.com/forum/showtopic.php?tid/201200/
In the event viewer was the following error -
"The Module DLL C:\Windows\system32\RpcProxy\RpcProxy.dll failed to load. The data is the error."
and
"Application pool 'xxxxxxxxx' is being automatically disabled due to a series of failures in the process(es) serving that
application pool."
Essentially the rpcpoxy is trying to load into the 32bit pool.
Anyway to fix this issue:
Edit c:\windows\system32\inetsrv\config\applicationhost .config
In the section which has add - precondition="bitness64" to the rpcproxy line so that you have the following
Someone else had this issue as well and posted it here.
http://forums.iis.net/t/1154189.aspx
The apparant fix though DISABLES all there MAIL!
Exchange stops receiving EMAILS there IPHONES no longer connect to there mail. ie no external mail connection anymore.
In my case it was just not possible on SBS and many people/companys actually say not to do this on sbs if your componants are 32bit then get Server Standard 2008 or something.
Too many issue with SBS Server 2008 64bit integrating Exchange and IIS.
Anyway that was my experience and the apparant fix which in my case didnt work.
Hope the info helps someone else out if they get stuck as i wasted an entire day...!
__________________
http://www.auzsolutions.com.au |
| Loading... | |
maddness
Registered: 10/16/10
Posts: 1
|
| | 10/16/10 at 03:26 AM | Reply with quote | #7 |
|
Blogs are always a main source of getting accurate information and provide you the handy results.you can get instant and reliable information which surely helps you in any field of your concern.your blogs fulfill these requirement and I really appreciate it.keep it up doing good work. i will come back to see more in future as well.best regards
__________________
642-813 | 642-902 | 70-680 | N10-004 |
| Loading... | |
RSS(.NETCodeGenerationIsHere).gif)
