DRW, error

[thekaz]

I created simple 2 table(empty) DB in Access, imported to FP2003 using
Database interface wizard changed some appearance in design mode and then
published. Host has FPSE installed and supports ASP & Access. Where do I look
for path to DB? It would have to be where the connection is opened right? Am
I on the right track? Any tips would be appreciated! I got this error:

Database Results Wizard Error
'e:\kunden\homepages\11\d104946546\oths69ers_interface\fpdb\oths.mdb' is not
a valid path. Make sure that the path name is spelled correctly and that you
are connected to the server on which the file resides.
One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

 

[Steve Easton]

You somehow created the database outside of your web, and the path to the DB points back to your
computer instead of a file on the server.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer

 

[Kathleen Anderson [MVP - FrontPage]]

What's the URL?

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Kathleen Anderson [MVP - FP]]

Your database should be located at
http://www.thecanvascompany.com/fpdb/oths.mdb

Can you open your web site in FrontPage and confirm that the fpdb folder
exists and that your database is in it?


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[thekaz]

****couldn't find a link to edit my post**so I just replied again
spoke with "server", told me that DB should be uploaded to "_DB_import"
folder?! When I open site in FP I do not see this folder. How do I show
system folders in FP2003?

 

[thekaz]

Thanks Kathleen, yes fpdb exists & DB in in there! but according to host my
DB should be uploaded to "_DB_import" folder

 

[Kathleen Anderson [MVP - FP]]

Did they say why?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[thekaz]

OK, spent time (too much) on phone with host tech, now tells me DB's should
be uploaded to their "DB" folder they supply for security reasons. How do I
redirect FP to this folder without messing up my DB? Is this possible? Or
should I just look for a different HOST!?

 

[Thomas A. Rowe]

If the DB folder is outside of you web space, you have to upload the database via a FTP application.
The host then should provide you with instructions on how to connect to the database in this manner.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[thekaz]

If the DB folder is outside of you web space, you have to upload the database via a FTP application.
The host then should provide you with instructions on how to connect to the database in this manner.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[thekaz]

Sorry for the empty post! DB folder is in root web. Will FP function properly
if DB.mdb file is in DB folder? If I have to use FTP and custom ASP scripts
I'd rather switch host! Defeats the reason for using FP2003 since I am "code
IMPAIRED". Please Advise. Thank you for all your responses

 

[Thomas A. Rowe]

FP really doesn't care where the database is located, as long as a connection can be made.

However by default FP will store the database in the fpdb folder, which FP will then assign the
correct permissions to allow the database to be access via ASP, but not allow direct access via the
browser. If the host requires that database is stored in another folder, that is fine, however the
host must then set the correct permission to ensure the folder and database is readable and
writeable, but also protected it. Basically the host has to do what FP would automatically do.

Once the database is in this folder, you have to (remote site open) go to Tools | Site Settings |
Database and verify your connection or delete and recreate your connection to the database, this
will update the global.asa file which control access to the database.

You should however make the effort to learn ASP and not totally depend on FP or other application to
write the ASP code for you as you will run into limitation trying to implement features and
functions that you will come to need at some point.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[thekaz]

Thanks again Thomas, will follow your suggestions. Any suggestions on the
best ASP primer book?

 

[Thomas A. Rowe]

I don't buy books, so I can not recommend any.

When I started, I found http://www.ASP101.com to be a great reference site, especially their
samples.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================