Having a heckuva time connecting to a database

[Novice]

I'm trying to set up a FP2000 form to save results to an access 2000 database, and I just can't get it to work. Any tips or articles you could refer me to would be much appreciated.

[scarlet]

Hi
I am having the same trouble. I feel like I am lost in Micro OZ 2000 and even the wizard can't help. If anyone knows the directions along the yellow brick data connectivity road :confused r where I can find a map, it would really help.
Scarlet

------------------
http://www.learning2earn.com

[Hierophant]

I am researching this problem and will post results when I know.

------------------
Wayne Luke - Sitepoint Moderator/Internet Media Developer
Digital Magician Studios - Making Magic with Web Applications
wluke@digitalmagician.com

[scarlet]

Hi
I have been fiddling with the database thing in FP2000...The instructions to do it are all in the help manual...I have set up a database and made a page that displays info from the database.....all with the wizards help............ BUT .............I wanted to let you know that Databasing in Front Page 2000 servers only works with NT. MSQl or PhP is needed to interact within a UNIX enviornment.
Scarlet
a.k.a. lost in {PhP/asp/MSQL/VB/MSDE} land


------------------
http://www.learning2earn.com

[Hierophant]

That is correct you need three things to be able to connect to an Access Database from Frontpage.

1. Frontpage Extensions installed on the server.

2. MDAC (Microsoft Data Access Components) installed on the Server. These components include ODBC drivers which enables you to connect to Access, SQL Server, Dbase, text and Excel databases and ADO which interacts with ASP.

3. ASP installed on the computer.

Now while ASP and Frontpage Extensions will run on almost any server, you would have to find some sort of third party component to to replace MDAC with as it only runs on Windows machines currently.

------------------
Wayne Luke - Sitepoint Moderator/Internet Media Developer
Digital Magician Studios - Making Magic with Web Applications
wluke@digitalmagician.com

[scarlet]

Hi novice
I found this and thought you might like to have it....http://www.asptoday.com/articles/20000407.htm
I cannot use it because I am hosted in a UNIX enviornment but I tried it on my computer @ home, it's about getting customer feedback, putting it into a database and taking it out. (including the asp pages needed to do all this) It might get you started on your database..hope it helps.
Scarlet

------------------
http://www.learning2earn.com

[Novice]

Thanks Scarlet and WLuke. Much appreciated. I'll let you know how it goes.

[Hierophant]

If your going to code ASP pages you might look at ASP 101 and 4 Guys from Rolla. Both sites have material that is better suited for the beginner. The articles listed at ASP Today can be written in a very technical manner and way over a newcomer's head.

------------------
Wayne Luke - Sitepoint Moderator/Internet Media Developer
Digital Magician Studios - Making Magic with Web Applications
wluke@digitalmagician.com