Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Cannot open accesss database error
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 4

chiefcook
Starting Member

USA
30 Posts

Posted - 08 August 2006 :  06:37:19  Show Profile
Same Code: 424 error occurs. All rights and permissions have been checked for the entire hierarchy of folders applicable to my forum files in the web root on a file by file basis, so those seem OK. iusr has full rights and permissions.

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 August 2006 :  07:22:36  Show Profile  Send ruirib a Yahoo! Message
I think it must be something related with Windows 2003. Is the latest Jet service pack installed? Is the latest MDAC installed?

I don't remember ever seeing that occurring around here, and it seems that the error means something like object not found. It would be interesting to find out which object is not found...

Do you feel like you could run setup.asp in such a manner as making it stop at predetermined points so that maybe we can have a more precise idea of where the setup page is failing?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 08 August 2006 :  07:50:56  Show Profile
I would definitely need some instruction. what would I need in order to step through the code?

Everything is easier when it is someone else's responsibility
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 08 August 2006 :  07:52:18  Show Profile
I am checking on the MDAC and Jet versions

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 August 2006 :  08:58:26  Show Profile  Send ruirib a Yahoo! Message
Yeah, I can try and set some points and even email you a config.asp to test. Let me know about the MDAC and Jet versions.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 08 August 2006 :  10:10:28  Show Profile
I am running jet 4.0.9025.0 and MDAC 2.82.1830.0

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 August 2006 :  10:21:16  Show Profile  Send ruirib a Yahoo! Message
Ok, can you add these three lines at line# 109, setup.asp:

        Response.Write "Line 109"
	my_conn.Close
	Response.End

Let me know if the error appears, after running setup.asp.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 08 August 2006 :  10:58:11  Show Profile
I added it and got the same error.

Just to be sure I did this right.... I added the code at line 109, between "(line 107)my_conn.Open strConnString" and "(line 113) for counter = 0 to my_Conn.Errors.Count -1"

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 August 2006 :  11:03:51  Show Profile  Send ruirib a Yahoo! Message
Yeah, that was it.

Now add these 2, in config.asp, at line#133:

        Response.Write "Line 133"
	Response.End


You can remove the ones from setup.asp.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 08 August 2006 :  11:17:12  Show Profile
Well, it did write Line 133 when I ran setup.asp

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 August 2006 :  11:19:56  Show Profile  Send ruirib a Yahoo! Message
Ok, so now movethose two lines to line# 137, setup.asp.
Code should look like this:

set my_Conn = Server.CreateObject("ADODB.Connection")
	my_Conn.Errors.Clear
	Err.Clear

        Response.Write "Line 137"
	Response.End

	my_Conn.Open strConnString


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 08 August 2006 :  13:25:41  Show Profile
That worked too. It also worked here (line 155):
my_Conn.Errors.Clear
Err.Clear

Response.Write "Line How is this"
Response.End

'## if the configvariables aren't loaded into the Application object
'## or after the admin has changed the configuration
'## the variables get (re)loaded


But, it did not work at line 200

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 August 2006 :  13:35:04  Show Profile  Send ruirib a Yahoo! Message
Line 200? What line is that?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 08 August 2006 :  13:44:17  Show Profile
After the SQL

-- strSql = "SELECT * FROM " & strTablePrefix & "CONFIG_NEW " --

section, which starts right below the commented out section under line 155

Everything is easier when it is someone else's responsibility
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 08 August 2006 :  13:48:51  Show Profile
Sorry, that is more confusing than anything...

Ignore the line 200 stuff... I inserted in the middle of if statements. I am better off following along. Rebuilding a win2k server at the same time...

Everything is easier when it is someone else's responsibility
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07