OutFront Forums
     Home    Register     Search      Help      Login    

Follow Us
On Facebook
On Twitter
RSS
Via Email

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

 

frontpage database query error help???

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> Microsoft FrontPage Help >> frontpage database query error help???
Page: [1]
 
webgyrl

 

Posts: 52
Joined: 2/9/2009
Status: offline

 
frontpage database query error help??? - 2/10/2009 21:27:58   
does anyone know what i can do to access my database...i am getting this error
Could not find file 'E:\kunden\homepages\
TexasWebDevelopers

 

Posts: 722
Joined: 2/22/2002
From: Dallas, TX
Status: offline

 
RE: frontpage database query error help??? - 2/10/2009 23:51:13   
From reading all of your posts you seem to be having quite a bit of trouble but you are not giving anyone enough information to help you.

You DO know that Access databases are really two different animals? One way of using an Access database is with the Access software as a stand alone database to be used on your PC. You use the Access software program to write queries and make reports and other such stuff--however, this is completely different from using Access as a database on a web server. On a web server the Access database created is queried by way of ASP code written on an ASP page. The database must be on a Microsoft Web Server and in a folder that has read/write permissions assigned to it. The results of the query are displayed on yet another ASP page. ASP is the acronym for "Active Server Pages" and that is the type of code you would need to use to interact with the database through forms. If you try to upload your "stand alone" database with queries to your web server you will find it won't work.

FrontPage helps automate this process of connecting to, and interacting with, the Access database by using webbots that are automatically generated by the FrontPage program when you create a form and tell the software to make a database that maps to the form. The host web server MUST have Front Page Server Extension installed in order for these webbots to work properly. Many hosting companies are eliminating the extensions and Front Page is a discontinued product so you may find you are on the trailing end of this type of database interaction.

The path you just posted could be (1) the path to the database on your computer or (2) the path to the database on your web server. Who knows? You haven't provided any code or information for us to help you along.

_____________________________

:)

Follow us on TWITTER

(in reply to webgyrl)
webgyrl

 

Posts: 52
Joined: 2/9/2009
Status: offline

 
RE: frontpage database query error help??? - 2/11/2009 10:56:46   
hey..thanks for responding...what i am trying to do is create a website where people can go and search for some info i have in a database. this info in the database is also collected through the site. In other words...some people can put up an item for sale while others can search the items. I have managed to sort out the collecting of the information seamlessly.
Now when users post their items for sale they have to log in with an id i end up with two separate tables. 1 with the users information and one with the items for sale so to get the necessary info in the listing i joined the two tables in a query so that their contact info as well as posting will show in the results. the problem comes when i load the site to the web. when i go to do a search of the listings (i.e the query) i get an error saying the file cannot be found...please help let me know what info i need to give you...i found a microsoft help sheet ( http://support.microsoft.com/kb/916865) that says i have to make sure that the database is located in the correct folder on the Web server. and gives some info to help but i dont know where to start...help?!!!!1

(in reply to TexasWebDevelopers)
TexasWebDevelopers

 

Posts: 722
Joined: 2/22/2002
From: Dallas, TX
Status: offline

 
RE: frontpage database query error help??? - 2/11/2009 12:20:36   
OK--. I don't use the webbots to connect to databases. I don't know why FrontPage is looking for that particular path but somewhere along the line that's where you told FP the database was located. Now, if it is a local path (on your computer) then on upload the path should be converted to a path on the server. THAT MEANS...the database folder has to be uploaded also. AND the database folder has to have read/write permissions set on it.

So walk through it. Is the database uploaded to the web server?
Is the path on the web server the one that you posted (where did you get that path)?




_____________________________

:)

Follow us on TWITTER

(in reply to webgyrl)
webgyrl

 

Posts: 52
Joined: 2/9/2009
Status: offline

 
RE: frontpage database query error help??? - 2/11/2009 17:51:53   
Hey forgive me i am somewhat of a novice of working with the database queries. well as for the path i have no idea where that came from i just got it from the error message. all i did was design the batabase and query and have it in the fpdb folder of my site on my computer next i uploaded the site to my web server/host . i have also uploaded the database to the web server and changed the permissions....but thats the error i get..have you ever built a query to join 2 tables and access it to frontpage..can you think of any other way i might be able to do this..what i want to do is be able to have a user based website where they can log in and post thier items but i want once posted it will not only show their post but also their contact info which is from another table

(in reply to TexasWebDevelopers)
treetopsranch

 

Posts: 1539
From: Cottage Grove, OR, USA
Status: offline

 
RE: frontpage database query error help??? - 2/11/2009 20:01:46   
A link to your hosted website would be most helpful for us. Also if you really are a beginner in this web stuff, then keep in mind that doing a website using a database is hard enough for experienced webmasters and takes a bit of knowledge and experience to do correctly. You need to know what kind of server you are on for starters as that determines the type of database you will use.

_____________________________

Don from TreeTops Ranch, Oregon

"I've got a taste for quality and luxury"


(in reply to webgyrl)
Page:   [1]

All Forums >> Web Development >> Microsoft FrontPage Help >> frontpage database query error help???
Page: [1]
Jump to: 1





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