| Author |
 Topic  |
|
|
regneva
Starting Member
USA
7 Posts |
 Posted - 21 April 2008 : 12:54:19
|
I am posting in this forum, because I seem to be having trouble connecting to the Acess Database.
I had this running in XP X64, but in December I updgraded to Vista Ultimate 64, and Snitz forum hasn't worked ever since. I have other ASP pages that continue to run fine, and one that will read and write to a text file at the same location that my database is located at (which is not in folder accessible from the web).
I get this error when I try to load any forum page:
Active Server Pages error 'ASP 0113'
Script timed out
/Regneva/Forum/setup.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
It is already taking too long, and increasing the time doesn't help. When IE is trying to bring up the page, all my other asp pages can't load, because this is using all the resources. I've simply disabled all my database connections, and then I get the snitz page telling me I don't have a database selected (which is true).
I have tried using both string connect types:
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<db_path>snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=<db_path>snitz_forums_2000.mdb" '## MS Access 97
(where <db_path> is the actual path)
I would have tried using a virtual path (Server.MapPath), but since I want to keep my database outside of the server path, I wasn't sure how to keep the reference straight.
I am using IIS 7.0 to host my website and I have MS Office 2007 installed (with MS Access).
I looked at updating my JET drivers, but it seems as though they are updated by simply having Vista...
I enabled ASP to use the temp folder: http://support.microsoft.com/?id=926939
So not real sure where to go from here... Any ideas? I'm pretty sure it is a problem with server, either my IIS settings, my JET driver, or how JET driver is called (although I would think that the Access 97 link would work if it was the JET driver).
My website is here, the link to the forum is down a few links: http://regneva.homeip.net:1111
Many thanks, |
--
--Eric Joseph Jones
(Regneva Wilhelm Tone)
http://Regneva.homeip.net:1111/
Regneva@gmail.com
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 21 April 2008 : 23:03:13
|
Check your file permissions on the mdb file and folder.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
 |
|
|
regneva
Starting Member
USA
7 Posts |
Posted - 21 April 2008 : 23:51:09
|
I found the problem! 
It turns out that it is the 64-bit that was causing it; when I was running XP X64, I believe ASP was still run under 32 bit; however, in Vista, they upgraded ASP to run in 64 bit. The problem is that the Jet drivers are deprecated, and thus were not upgraded to 64 bit.
So I followed these instructions I obtained from Thomad at http://forums.iis.net/t/1066385.aspx to change my forum webpage to use 32 bit ASP. Really slick! So if you are running 64 and are having problems, try this!
1) Create a new Application Pool in the UI or via command-line, e.g.
%windir%\system32\inetsrv\appcmd add AppPool My32BitAppPool
2) Set it to run in 32-Bit Mode by setting "Enable 32-Bit Applications" in the AppPool's "Advanced Settings" or via command-line:
%windir%\system32\inetsrv\appcmd set AppPool My32BitAppPool -enable32BitAppOnWin64:true
3) Run your application in this AppPool by changing it in the UI (Application: Basic Settings) or via command-line:
%windir%\system32\inetsrv\appcmd set app "Default Web Site/test" -applicationPool:My32BitAppPool |
--
--Eric Joseph Jones
(Regneva Wilhelm Tone)
http://Regneva.homeip.net:1111/
Regneva@gmail.com
|
Edited by - regneva on 22 April 2008 13:31:11 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
|
|
Topic Locked
