|
| |
|
|
tapanga
Posts: 22
Joined: 4/2/2002
From:
Status: offline
 |
Will Pay For help - 4/4/2002 15:37:47
I am trying really hard to get a web site connected to a database up and running - and seem to continuously run into questions on how to get things to work in FP2002.
If you have some free time and wish to help me out on a one on one basis - i'd be happy to pay for your time. Please email me
tdale@sasktel.net
|
|
|
|
tapanga
Posts: 22
Joined: 4/2/2002
From:
Status: offline
|
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
| |
|
|
|
tapanga
Posts: 22
Joined: 4/2/2002
From:
Status: offline
|
RE: Will Pay For help - 4/4/2002 22:05:17
Hi Spooky
A newly aquired helper told me that I am supposed to publish the site via frontpage and not other software
**blonde**
I did that and it seems to have rectified the Database connection problem.
The web host tells me that they DO support frontpage extensions - hence my reason for selecting them. In the mean time however - I have been offered some help - i'll let you guys know how it goes.
This is a wonderful site and Spooky - thanks to you for all your help.Because of people like you and forums like this - us newbies are made to feel very welcome - maybe one day i'll be able to help others too.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
