using ASP in web with database Access

[jhaek19]

Hi, I need help on this...

This code is working on my IIS server but when I uploaded it to the web, it wont run anymore, why? Please help.

Thanks!

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("cartoon.mdb"))
set rs = Server.CreateObject("ADODB.recordset")

[sashi]

Hi, I need help on this...

This code is working on my IIS server but when I uploaded it to the web, it wont run anymore, why? Please help.

Thanks!

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("cartoon.mdb"))
set rs = Server.CreateObject("ADODB.recordset")

Hi there,

"Won't run anymore" doesn't provide much details to be able to help you out. Please provide more details such as the error message / error number / code being prompt or thrown while executing this code.

Providing more details would ease in providing help in return. Good luck & Take care.

[jhaek19]

Ahm, actually there is no error, cause it simply "wont run/execute" in my web server, unlike in my own computer where I developed the asp file, it executes the way it should be on my IIS virtual directory...but when I uploaded it for users to browse in the www, my commands wont execute; access database, etc...

Hi there,

"Won't run anymore" doesn't provide much details to be able to help you out. Please provide more details such as the error message / error number / code being prompt or thrown while executing this code.

Providing more details would ease in providing help in return. Good luck & Take care.

[gateshosting]

So you open the web page, and nothing happens? There HAS to be an error somewhere.

Do you have a global.asa file that holds variables, and you are running the virtual directory as it's own application, etc.?

First, I would start by writing out some basic info so you can debug...

response.write server.mappath("/") & "/whatever/mydb.mdb"
response.end
 

This way, you can step through the code, to see if everything is working.

You should also have a custom 500.asp page which can be configured to show you where errors occur, plus give a nice friendly error page to clients. You can even have it email you the errors, so you can fix the site as quickly as possible. Just a suggestion.

Best regards,

Michael C. Gates

[jhaek19]

I tried it, so it seems my asp doesn't execute on my web server...is there any special headings or commands I should include??

can anyone give me a sample asp file that executes with a database in a web server???please help!


thanks!

So you open the web page, and nothing happens? There HAS to be an error somewhere.

Do you have a global.asa file that holds variables, and you are running the virtual directory as it's own application, etc.?

First, I would start by writing out some basic info so you can debug...

response.write server.mappath("/") & "/whatever/mydb.mdb"
response.end
 

This way, you can step through the code, to see if everything is working.

You should also have a custom 500.asp page which can be configured to show you where errors occur, plus give a nice friendly error page to clients. You can even have it email you the errors, so you can fix the site as quickly as possible. Just a suggestion.

Best regards,

Michael C. Gates
www.gateshosting.com

[sashi]

I tried it, so it seems my asp doesn't execute on my web server...is there any special headings or commands I should include??

can anyone give me a sample asp file that executes with a database in a web server???please help!


thanks!

Hi there,

Is ASP supported on the particular web server? Please check this detail. Good luck & Take care.

[gateshosting]

Are you using windows 2003 or 2000 server?

Regards,

Michael C. Gates

[jhaek19]

Thanks for all your help, I found out that my webhost doesn't support ASP, how sad!!! Anyways Im shifting to PHP programming, hope to hear your help in the future, enjoy programming!