ASP help!

[B4RK0D3]

Keep in mind that I'm a designer, not a programmer :roll:

The site is created in ASP Classic and references a global.asa file, which connects to an Access database (I know, I know). The only thing that seems to work is the .asp file that doesn't reference the global.asa file! I have gone through the site and updated all of the references to the .mdb file, but I'm still getting a 500 - Internal Server Error. What am I doing wrong? Please help!

 

[presidentender]

Did you make sure this host supports classic ASP?

 

[B4RK0D3]

Yes, it does support ASP classic. The host is www.webhost4life.com , who I've had success in the past with, using Classic ASP.

 

[torpid]

If the global.asa isn't executing then you need to verify that the site is created as an application. Turn on detailed error reporting in IE and tell us the specific error if that doesn't help.

 

[B4RK0D3]

I actually don't have access to IE on this computer. Here is the temporary URL, while default.asp is the home page. site144.mysite4now.com/nostalgia

As you can see, this link that doesn't reference global.asa works just fine - site144.mysite4now.com/nostalgia/home.asp

 

[B4RK0D3]

Here is the code that my default.asp uses to connect to the global.asa file:

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionTimeout = 15
Conn.CommandTimeout = 30
Conn.Open Application("connection")



And here is what it references within the global.asa file:


Sub Application_OnStart

application("connection") = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nostalgia.mdb" & server.mappath("/database/nostalgia.mdb")

End Sub

 

[Ken g6]

I don't know about ASP specifically, but the error I see looking at that page is:

Active Server Pages error 'ASP 0126'

Include file not found

/nostalgia/Default.asp, line 74

The include file '/includes/top.asp' was not found.

Does "/includes/top.asp" exist? Is it now "/nostalgia/includes/top.asp" or something? Is it readable by the proper user?

 

[B4RK0D3]

I'm actually working on the file as we speak... the web host updated a setting server-side to enable global.asa on temp URLs.

The error I'm getting now is:

Microsoft JET Database Engine error '80004005'

Not a valid file name.

/nostalgia/Default.asp, line 52





Line 52 is the last line below:

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionTimeout = 15
Conn.CommandTimeout = 30
Conn.Open Application("connection")

 

[VinylxScratches]

http://tutorials.aspfaq.com/80...s/80004005-errors.html here is some info on that error.

 

[B4RK0D3]

VinylxScratches, I fscking love you. That led me on the right path and I found a teeny error in my global.asa file. I owe you a handjob or something. Thanks man.

 

[Markbnj]

Originally posted by: B4RK0D3
VinylxScratches, I fscking love you. That led me on the right path and I found a teeny error in my global.asa file. I owe you a handjob or something. Thanks man.

Most people would draw the line at PayPal'ing a few bucks over to say thanks.