Web-Database Link

help-meee · 05-19-2006, 05:16 AM

I'm trying to link a database to my website, im currently using Microsoft Frontpage and Access. I have tried messing around with the FrontPage database wizard and templates, but it will not display data, and says something about '.asp' files and needing an internet server that supports 'active server pages.' Also needing querys for searching the data on the webpage.

I'm completely confused

so any pointers will be appreciated.

**gamerman0203** · 05-19-2006, 11:07 AM

you will need to save the pages as '.asp'. Then order to use them, you will need to have IIS (Internet Information Services) running and access your site as a normal web page.

To install IIS:
start>control panel>add/REmove programs
Click the windows components button on the left side
check the box near IIS and click OK. It will install IIS. might ask for your OS disk. IF the box is already checked then IIS is installed. Go to next step.

Once that is done, then move your site's folder into the 'Inetpub' folder on your C: drive. Then right click your sites folder and click properties. Click the sharing/Web sharing tab at the top and make sure it is shared or shared as a web page.

Then open IE and type "http://localhost/mysitesfolder/anypage"

This will bring up your site how it will be seen on the web. By installing IIS you turned your computer into a local web server for yourself.

As for the web pages themselves, you'll be best off teaching yourself ASP. That will get your the farthest. I can try to assist slightly here, but without knowing exactly what you want to do, I can't do much.

Put this just below the <body> tag. This will connect to your database:
<%
Dim objCon
Dim rsobj
Dim strSQL
Set objCon = server.CreateObject("ADODB.Connection")
objCon.Open = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="& Server.MapPath(" yourdatabasepath.mdb") (<-This is supposed to be on the same line as 'objCon.Open')
Set rsobj = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM tableindatabase;"
rsobj.Open strSQL, objCon

%>

Once you connect to your database then you can pull information out of it to write to the page. This is a simple script that will write all records in the table to the page:

<%
Do while not rsobj.eof
Response.Write(rsobj("field1"))
Response.Write("<BR>")
Response.Write(rsobj("field2"))
Response.Write("<BR>")

rsobj.movenext
loop
%>

That script will write Field1 and Field2 for every record in that database.

I could go much much much more into depth, but I'm not going to just yet. If you still need help, then tell me what you are trying to do and I'll see what I can produce for you.

Gosh I love this stuff!!!

-Dan

help-meee · 05-22-2006, 02:51 AM

Thanks for the help, I've had some other help from other teachers in the school, so i will try out your suggested method.

05-19-2006, 05:16 AM	#1 (permalink)
help-meee Registered User Join Date: May 2006 Posts: 2 OS: XP	Web-Database Link I'm trying to link a database to my website, im currently using Microsoft Frontpage and Access. I have tried messing around with the FrontPage database wizard and templates, but it will not display data, and says something about '.asp' files and needing an internet server that supports 'active server pages.' Also needing querys for searching the data on the webpage. I'm completely confused so any pointers will be appreciated.

05-19-2006, 11:07 AM	#2 (permalink)
gamerman0203 Retired Join Date: Oct 2005 Location: Grand Rapids, MI Posts: 2,144 OS: XP MCE, Ubuntu Gutsy My System	you will need to save the pages as '.asp'. Then order to use them, you will need to have IIS (Internet Information Services) running and access your site as a normal web page. To install IIS: start>control panel>add/REmove programs Click the windows components button on the left side check the box near IIS and click OK. It will install IIS. might ask for your OS disk. IF the box is already checked then IIS is installed. Go to next step. Once that is done, then move your site's folder into the 'Inetpub' folder on your C: drive. Then right click your sites folder and click properties. Click the sharing/Web sharing tab at the top and make sure it is shared or shared as a web page. Then open IE and type "http://localhost/mysitesfolder/anypage" This will bring up your site how it will be seen on the web. By installing IIS you turned your computer into a local web server for yourself. As for the web pages themselves, you'll be best off teaching yourself ASP. That will get your the farthest. I can try to assist slightly here, but without knowing exactly what you want to do, I can't do much. Put this just below the <body> tag. This will connect to your database: <% Dim objCon Dim rsobj Dim strSQL Set objCon = server.CreateObject("ADODB.Connection") objCon.Open = "DRIVER={Microsoft Access Driver (.mdb)}; DBQ="& Server.MapPath(" yourdatabasepath.mdb") (<-This is supposed to be on the same line as 'objCon.Open') Set rsobj = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT FROM tableindatabase;" rsobj.Open strSQL, objCon %> Once you connect to your database then you can pull information out of it to write to the page. This is a simple script that will write all records in the table to the page: <% Do while not rsobj.eof Response.Write(rsobj("field1")) Response.Write("<BR>") Response.Write(rsobj("field2")) Response.Write("<BR>") rsobj.movenext loop %> That script will write Field1 and Field2 for every record in that database. I could go much much much more into depth, but I'm not going to just yet. If you still need help, then tell me what you are trying to do and I'll see what I can produce for you. Gosh I love this stuff!!! -Dan __________________ Follow These Steps First! CPU-Z \| SensorView \| WinXP Clean Boot \| Latest DirectX \| ATI Catalyst \| Nvidia ForceWare Posting System Specifications Last edited by gamerman0203; 05-19-2006 at 11:09 AM.

05-22-2006, 02:51 AM	#3 (permalink)
help-meee Registered User Join Date: May 2006 Posts: 2 OS: XP	Thanks for the help, I've had some other help from other teachers in the school, so i will try out your suggested method.