|
tapanga -> RE: Will Pay For help (4/4/2002 20:33:14)
|
Hi Spooky
Thanx for the reply - besides the fact that I still need to test that example you gave me on how to include an image in the database I am trying to start out very basic and learn everything i need to know on the way.
www.meadownorth.ca/frontpagetest/HowellAgencies is the url i have been saving my attempts to.
So far i have
index.htm
administration.htm
add.asp
update.asp
update_form.asp
it seems as though my add.asp is working because when i enter data it gives me a confirmation page.
Now I want to be able to update/edit the database.
so update_form.asp calls update.asp which has an sql statement to update. But I am getting a error
Database Results Error
The database connection named 'add' is undefined.
This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have Scripting permissions enabled
* the web is not marked as an Application Root
so i did some research in the microsoft support pages and i did a test they said to test the global.asa and according to my web host i have to change some things in my global.asa as well as in the *.asp files hat are connecting to the database.
http://www.canhost.ca/asp.html
i'v tried to follow their instructions but i am lost when they tell me to do the following :
First: Locate and remove the wizard code
The section you need to remove starts with
<!--webbot bot="DatabaseRegionStart" ... and ends in .... i-ScriptTimeout tag="BODY" -->
Just delete the whole section
Second: Locate and replace the connection string
Replace the line:
fp_rs.Open fp_sQry, "DSN=orders"
with
Set oCm = Server.CreateObject("ADODB.Connection")
ConnStr = "filedsn=" & Server.MapPath("/_private/datadatabase.dsn")
ConnStr = ConnStr & ";DBQ=" & Server.MapPath("/_private/datadatabase.mdb")
oCm.Open ConnStr
I even created a simple page by doing
new > page > insert > database> results > use existing database connection (selecting the add database) > record source (use results) > etcetera
and when i upload it to the web server it is giving me that same database connection error.
i am currently designing on my hard drive and using cuteftp to upload the data to the web host.
if any of this has made sense to you and if you see a solution - please help.
I am sure I will run into lots of snags on the way - as i'm new to this whole FP way, but i have followed all the instructions for the Database wizard (it seems simple enough)
and can't even seem to see my data?
lol@essay - you're gonna charge me for this help for sure.....lolol
Thank you in advance
|
|
|
|
