hello,
i always get problem to upload my database, because i don't know where i must be save database that i create in Access. Basicly i usually upload my web in site www.domaindlx.com, but database cannot run well. So when i look aplication software asprunner, that i have thinking that software could solved my databse problem, so i have to download this aplication and run it as well as with asp program, i meant i must run both of them.
if moderator or anyone else have solution or could help so upload my web run well in web site, can give reply solution in here or in my email in yahoo; Angga_Sundanis@yahoo.com.
Or you could run my aplication free web site in : http://cc.domaindlx.com/icabojong/index.htm
and click page kritik==> problem could see in above:
- Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/icabojong/dbguestconfirmation.asp, line 49
- Connect.Open "buku tamu" %>
ADODB.Connection error '800a0e78'
Operation is not allowed when the object is closed.
/icabojong/guestlog.asp, line 25
or
this my dbguestconfirmation.asp
<html>
<head>
<title>Terima Kasih Telah Mengisi Buku Tamu Kami.</title>
</head>
<body bgcolor="#f4f4ea">
<% if Request.Form ("DataNama") = "" Then %>
Maaf, Anda Belum Mencantumkan Nama Anda. Pakai Tombol Back untuk kembali
<% ElseIf InStr (Request.Form ("DataEmail"), "@") = 0 then %>
ALamat E-Mail Anda Kurang Tanda @. Pakai Tombol Back untuk Kembali.
<% ElseIf InStr (Request.Form ("DataEmail"), ".") = 0 then %>
Alamat E-mail Anda Kurang Tanda ".". Pakai Tombol Back untuk kembali.
<% ElseIf Request.Form ("DataKomentar") = " " then %>
Maaf, Komentar Anda sungguh Berarti Bagi Kami. Pakai tombol back untuk kembali.
<% Else %>
<p>
<font face = "Arial">
Halo <% =Request.Form ("DataNama") %> Anda Sudah Mencantumkan identitas anda pada
Guest Book Kami. Terima Kasih Yach......</font>
</p>
<p>
Inilah Data-data yang tadi Anda Masukkan :
Nama : <b><%=Request.Form("DataNama")%></b>
E-Mail : <b><%=Request.Form("DataEmail")%></b>
Tahu Situs ini Dari : <b><%=Request.Form("DataTahu")%></b>
Komentar : <b><%=Request.Form("DataKomentar")%></b>
</p>
<p>
<a href= "guestlog.asp">Klik Di Sini untuk Melihat Buku Tamu.</a>
<% DataNama = Request.Form("DataNama") %>
<% DataEmail = Request.Form("DataEmail") %>
<% DataTahu = Request.Form("DataTahu") %>
<% DataKomentar = Request.Form("DataKomentar") %>
<% Set Connect = Server.CreateObject("ADODB.Connection")%>
<% Connect.open "buku tamu" %>
<% Connect.Execute "INSERT INTO guestbook (nama, email, tahu, komentar) values ('" &DataNama& "', '" &DataEmail& "', '" &DataTahu& "', '" &DataKomentar& "')"%> <% connect.close %>
<% End If %>
</body>
</html>
and guestlog.asp
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#f4f4ea" text="#000000">
<font size="4"></font>
<p align="center"><b><font face="Arial">
Agar Persahabatan Selalu Terbina
Mohon Kiranya Mengisi Guest Book Di Bawah ini</font>
</b></p>
<p align="left"> </P>
<form method="POST" action="dbguestconfirmation.asp">
<table border="0" width="74%">
<tr>
<td width="39%"> <font face="Courier New" size="2"> <b>Nama</b></font>
<font face="Courier New" size="1">
(Wajib Anda Isi)</font></td>
<td width="61%">
<input type="text" name="DataNama" size="41"></td>
</tr>
<tr>
<td width="39%">
<font face="Courier New" size="2">
<b>E-Mail</b></font></td>
<td width="61%">
<input type="text" name="DataEmail" size="41"></td>
</tr>
<tr>
<td width="39%">
<font face="Courier New" size="2">
<b>Tahu Website ini Dari</b>
</font></td>
<td width="61%">
<select size="1" name="DataTahu">
<option>Teman</option>
<option>Chatting</option>
<option select>Just Surfing!</option>
</select></td>
</tr>
<tr>
<td width="39%">
<font face="Courier New" size="2">
<b>Komentar</b></font>
<font face="Courier New" size="1">
(Wajib Anda Isi)</font></td>
<td width="61%">
<textarea rows="5" name="DataKomentar" cols="32">
</textarea></td>
</tr>
</table>
<p align="left"><input type="submit" value="Kirim">
<input type="reset" value="Reset"></p>
</form>
<p align="left"> </p>
</body>
</html>
