Forum access and Win2008 server + iis7
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27764
Printed Date: 02 April 2026 at 10:45am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Forum access and Win2008 server + iis7
Posted By: BrownGhost
Subject: Forum access and Win2008 server + iis7
Date Posted: 30 August 2009 at 3:20am
|
i cant get the access database to work.. iis 7 on win 2008 server ASP is enabeld and server side includes. ofter than that its a brand new clean install.. when tresting conetion.. Adobe.connetion failes Any help?? |
Replies:
Posted By: 123Simples
Date Posted: 30 August 2009 at 11:46am
|
The access database (or the database folder) needs to have read/write permissions enabled
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: BrownGhost
Date Posted: 30 August 2009 at 12:11pm
|
ADODB.Connectionit seems like win 2008 server 64Bit dos not have connetion stuff for access database.. :/ can this be true ? ------------- Thanks BrownGhost http://www.pitbull.dk" rel="nofollow - http://www.pitbull.dk |
Posted By: BrownGhost
Date Posted: 30 August 2009 at 12:17pm
|
My parther just confirmed it, he format the server, and put in a 32bit. now all works.. i just hate you MS for not telling 64bit dos not work.. Sorry to borther you Mr.T.. thanks for your time.. ------------- Thanks BrownGhost http://www.pitbull.dk" rel="nofollow - http://www.pitbull.dk |
Posted By: 123Simples
Date Posted: 30 August 2009 at 2:30pm
Glad you got it sorted BrownGhost - no worries about asking though - that is why the forum is here 
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: WebWiz-Bruce
Date Posted: 31 August 2009 at 4:32pm
|
Windows 2008 64 bit is much better than the 32 bit version, infact the new Windows 2008 R2 version only comes in 64 bit flavours as Microsoft have now dropped 32 bit server OS's. To use Access on Windows 2008 x64 IIS7 and 7.5 you need to change the application pool to run in 32 bit mode. This is actually the way Microsoft advise you to run IIS application pools as it gives better performance, memory usage, and compatibility. It also allows your 32 bit components to be used as well as the Access JET or ACE Drivers. The new ACE driver for Access is what Microsoft is bring in to replace the older JET driver with Office 2007 and up. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: BrownGhost
Date Posted: 31 August 2009 at 5:49pm
|
B.. this i dont understand, as in odbc under drivers on the 64bit version there is NON... we spend 26 houers trying to solve this issue, 2 dudes.. And all over the net, there was no solutions.. Also the stuff about iis 7.5 i also dont understand, yeahh there is talk of it. but has any one seen or run it.. as its nowear to be downloaded.. jep the jet driver is out i know.. but no new drivers is in the server, and one cant drownload any new driver for it.. So its back på 32bit, thats works.. ------------- Thanks BrownGhost http://www.pitbull.dk" rel="nofollow - http://www.pitbull.dk |
Posted By: WebWiz-Bruce
Date Posted: 01 September 2009 at 10:52am
|
There is no JET 64 bit driver, however if you run your IIS 7.x applications pools in 32 bit mode it will use the JET 32 bit driver which comes with Windows Server 2008. You can also use your 32 bit components by registering them in the windows/wow64 directory and using regsvr from that directory. We have 1000's of websites running on our Windows 2008 64 bit servers which are setup in this way many using Access databases with the JET driver with no problems. This includes the Demo of web wiz forums at http://demo.webwizforums.com which is running on 64 bit Windows 2008 using Access. IIS 7.5 is part of Windows 2008 R2 which is out on general release on the 22nd of October. However as we are a Microsoft Hosting Partner we already offer web hosting solutions on Windows 2008 R2 with IIS 7.5, which you can signup for now at the link below:- http://www.webwiz.net/webhosting/ This website and forum also are running on IIS 7.5 as we recently updated this web server to Windows 2008 R2 x64. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: WebWiz-Bruce
Date Posted: 01 September 2009 at 10:56am
|
Instead of reinstalling the 32bit version, all you needed to have done was go to the websites application pool in IIS and click on 'Advanced Settings' and then change 'Enable 32-Bit Applications' to 'True'. That is it you don't need to do anything else and your Access database will then run in Windows 2008 64 bit using the 32bit JET driver. Quite simple when you know how  ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: BrownGhost
Date Posted: 01 September 2009 at 11:20am
|
Humm but still, i then wonder, even if i do this, why is there no drivers under odbs drivers TAB.. Administrativ tools / ODBC then look in drivers.. only 1 there thats MS SQL driver. all others are gone. non for 64 or 32 bit.... (on server 2008 64bit version) thats the hole problem... so i still wondering how in hell you run yours :( i have formatet, 26 houers 2 persons was enough time wasted :( ------------- Thanks BrownGhost http://www.pitbull.dk" rel="nofollow - http://www.pitbull.dk |
Posted By: BrownGhost
Date Posted: 01 September 2009 at 1:00pm
|
Ill now format the 32 bit. install the 64bit. and do what you say :o) Alsi we have 12 gigabyte ram in the server the 32 bit version only see 4 :o( and when it dos not work, ill post here and ask you what to do :) haha.. hope you will help me out B :) Thanks ------------- Thanks BrownGhost http://www.pitbull.dk" rel="nofollow - http://www.pitbull.dk |
Posted By: WebWiz-Bruce
Date Posted: 01 September 2009 at 1:38pm
|
The Data Souces (ODBC) available under Admin Tools will only show the 64 bit drivers. To view the installed 32bit ODBC drivers you need to go to the directory:- C:\Windows\SysWOW64 then run the file odbcad32.exe It will then list all the 32 bit drivers including the 32 bit JET driver included with Windows 2008 x64. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: BrownGhost
Date Posted: 02 September 2009 at 12:04pm
|
You than man B.. thanks a billion times... it works :)
------------- Thanks BrownGhost http://www.pitbull.dk" rel="nofollow - http://www.pitbull.dk |
Posted By: WebWiz-Bruce
Date Posted: 02 September 2009 at 1:15pm
|
No problem. Have been using Win2k8 x64 for nearly two years now, so picked up quite a bit about it. I certainly prefer it though over 2k3, and the new Win2k8 R2 improves things even further. Have a few Windows 2008 x64 boxes running Hyper-v which have not been rebooted in over a year, so it is certainly very stable as well. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: BrownGhost
Date Posted: 03 September 2009 at 9:54am
|
a year, thats insane *haha* im looking forvard to that.. its running real good now :) the only issue is on my MS SQL sites i had to enabel 32bit mode as Jmail only comes in 32Bit. so those sites run all things in 32bit mode grrrrrrrrr my other componets are both 32 and 64 bit versions.. like aspupload and aspjpg looking forward to Jamil making a 64bit version.. IF thy do.. What do you do for mail komponent to keep your boxes running only 64bit ?? ------------- Thanks BrownGhost http://www.pitbull.dk" rel="nofollow - http://www.pitbull.dk |
Posted By: WebWiz-Bruce
Date Posted: 03 September 2009 at 12:22pm
|
We run all application pools in 32 bit mode. Microsoft recommend that you run website application pools in 32 bit mode on Win2k8 x64, not only is it better for compatibility with 32 bit components and drivers, they also use much less memory, and Microsoft also say you get better performance. Here is the information from Miocrosoft's Hosting Deployment Guide white paper, which I think I got from a Microsoft training day for IIS 7:- ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: BrownGhost
Date Posted: 03 September 2009 at 1:02pm
|
I see.... thanks so much for taking time to help and educate me :) love that... i think ive got it now, and all is setup, and running nice :) Take care B, untill next time :o) ------------- Thanks BrownGhost http://www.pitbull.dk" rel="nofollow - http://www.pitbull.dk |