Haven't really done any development work since I got my new laptop with Windows 7 64bit, so decided to setup IIS 7 on it and setup a default snitz forum. Seems I can't even manage that anymore.
Unpacked the forum into c:\inetpub\wwwroot\snitz with the access database in c:\inetpub\wwwroot\snitz\dbase.
Connection string is as follows: strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\wwwroot\snitz\dbase\snitz_forums_2000.mdb" '## MS Access 2000 using physical path
I opened the database in access 2010 and saved it as snitz_forums_2000.accdb and changed connection string to: 'strConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\inetpub\wwwroot\snitz\dbase\snitz_forums_2000.accdb" '## MS Access 2007 using virtual path
Timeout error.
Moved the database to c:\inpetpub\db\ and changed the connection string accordingly. Gave IUSR and IIS_IUSR full control on folder and file.
Timeout error. A simple helloworld.asp file works fine in root folder.
You need to enable support for 32 bits apps in IIS. Open IIS Manager, choose Application Pools, right click DefaultAppPool, choose Advanced Settings and then choose True from the dropdown for Enable 32-bit Applications.
Posted - 01 June 2012 : 17:55:16
.
