| Author |
 Topic Search  Topic Options
|
BrownGhost 
Groupie
Joined: 26 November 2002
Status: Offline
Points: 193
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Forum access and Win2008 server + iis7
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??
|
 |
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
Posted: 30 August 2009 at 11:46am |
|
The access database (or the database folder) needs to have read/write permissions enabled
|
|
|
|
BrownGhost
Groupie
Joined: 26 November 2002
Status: Offline
Points: 193
|
Post Options
Thanks(0)
Quote Reply
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 ?
|
|
|
|
BrownGhost
Groupie
Joined: 26 November 2002
Status: Offline
Points: 193
|
Post Options
Thanks(0)
Quote Reply
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..
|
|
|
|
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
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 
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
BrownGhost
Groupie
Joined: 26 November 2002
Status: Offline
Points: 193
|
Post Options
Thanks(0)
Quote Reply
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..
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
Edited by WebWiz-Bruce - 01 September 2009 at 10:58am
|
|
|
|
