sris 0 Report post Posted April 1, 2005 Ko guna XP SP2 ker?MS Access XP/2002 ?Cuba buka fail database dalam ms accessklik Tools > Database Utility > Compact & Repair...←saya guna ms access 2002 dan windows xp. dan saya dah cuba klik Tools > Database Utility > Compact & Repair... masih dpt error yg sama... Quote Share this post Link to post Share on other sites
C-Fu 0 Report post Posted April 1, 2005 (edited) 1. kat dalam source view dalam dw, ko enable line number so tau line 113 tu ape kod die.2. ako memang sokong sangat untuk guna connection string / dsn-less connection, problem senang je setel. dan most free asp website memang suruh kita gune connection string pon.3. mase ko edit kod tu dan run ko bukak ms access ke? cube tutup access dulu. kalo tak jad gak, pi Start>run>odbcad32, pastu ko doubleklik entry database ko tuh. tengok name die. same tak ngan name yang ko boh kat dalam DW? kalo sama, kat dalam odbcad32 tadik tu doubleklik kat dbase ko. klik Advanced. tambah jumlah Threads dari 3 kepada 8 ke 10 ke.4. dari ape yang ako blaja untuk buat mende ni dalam dw dulu, kalo error tu tetap menjadi tapi ko dah buat ape yang ko rase betul...ko kene bukak source die, pastu delete SEMUA ASP KOD. semua, kecuali file2 html. pasal sometimes, bile ko klik + untuk add record ke pastu ko klik - untuk buang fungsi dari dw tu nanti certain code die tak buang. so tu pasal error.cara ako dulu bile buat , kalo contohnye insert record, ako buat very very basic webpage ngan form. teks hitam ngan page putih background. bile dah takde problem untk insert record, baru ako start main2 dengan kaler la image la etc etc.tutorial tu ako rase ade jumpe. tapi ako nak send/upload ke mane? ade gamba2 skali.AND, bila ko nak pos kod ke putera ni, make sure yang kod tu dalam tag [.code]kod2[./code].contoh macam <% blaaaaaah blahhhh %> ni site ako bile ako start belajar ASP ngan dreamweaver untuk keje skolah dulu. total time buat: 4 5 hari dari start blaja sampai siap hahahahhaha ako beshhhhhhhhhhhhhhhhofftopic: dalam dreamweaver, kalo ade flash file yang ko nak background die transparent cam ako buat tu, dalam dw klik kat flash movie tu, pastu under properties ko tambah parameter niname wmodevalue transparent Edited April 1, 2005 by C-Fu Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) Try tengokhttp://www.xlinesoft.com/asprunner/docs/er...eable_query.htmatau:http://www.xlinesoft.com/asprunner/docs/tr...ery__errors.htm Edited April 2, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) Untuk memastikan semua software di install dan konfigur dengan betul, cuba ikut step nie.1. Buat satu folder tryasp dalam C:\inetpub\wwwroot2. Buat satu folder db dalam folder tryasp.3. Path yang akan terjadi;c:\inetpub\wwwroot\tryasp\db4. Buat satu fail database access (simpan fail tryasp.mdb dalam folder db) seperti berikut;fieldname: Username dan IC_No (datatype: text)5. Simpan table tbl_UsernameSemak path database.c:\inetpub\wwwroot\tryasp\db\tryasp.mdbDreamweaverSetting site.1. Klik Site > Manage Sites > New > SiteKemudian ikut step by step. Edited April 2, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) Edited April 2, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) Check site: Edited April 2, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) Buat Connection String1. klik file > new. Pilih dynamic page > asp.net VB2. Klik Template > Microsoft Jet Edited April 2, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) Copy semua text conn. stringpaste dalam ruang kosong.taip data source spt dalam gambar.user id=;password=; Edited April 2, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) buat string dalam satu baris dan copy.Tutup fail asp.netcreate new asp file. Save as try.asp Edited April 2, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) Klik Application > DatabaseKlik + > Custom Conn StringIsikan seperti dalam rajah.Untuk conn string > paste. (string yang telah dicopy sebelum ini) Edited April 2, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) Nak buat borang insert record.Klik ApplicationKlik ikon record insertion form wizard Edited April 2, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 2, 2005 (edited) Simpan fail dengan nama try.aspakhir sekali , tekan F12 untuk test dalam browsertry masuk data, dan check database. kalu ok. ok la. Edited April 7, 2005 by OngBok Quote Share this post Link to post Share on other sites
DarkWan 3 Report post Posted April 7, 2005 berkenaan error tu, cuba download MDAC latest. kalau tak silap aku, MDAC 2.8.anyway, good job OngBok. btw, aku pun ada buat jugak site dengan 1stasphost ni. saje saje takde keje. coding bodo jek. testing testing hahahaha. buat connection string pun, manual sampai DMX takleh recognize aku punya coding tu (i must be bad in programming, somehow).http://k.1asphost.com/daniaherzegovinaID: testingpassword: testing Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 7, 2005 (edited) SET Database Connection On Site.Upload fail database ke dalam folder db di brinkster.comUpload fail try.asp ke root folder di brinkster.comContoh:try.asp Edited April 7, 2005 by OngBok Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 7, 2005 (edited) Selepas upload ke brinkster, anda belum boleh running fail asp ini.Buat sedikit pindaan seperti berikut.Dalam Classic File Manager, klik file try.asp > klik Edit file.Kod dibaca dari atas;=====================================<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><!--#include file="Connections/connTryasp.asp" --><%' *** Edit Operations: declare variables=====================================Delete baris <!--#include file="Connections/connTryasp.asp" --> dan gantikan dengan kod ini<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><%Dim myConn, MM_connTryasp_STRINGSet myConn = Server.CreateObject("ADODB.Connection")MM_connTryasp_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};" & _ "DBQ=" & Server.MapPath("\username\db\namafail.mdb") & ";"myConn.Open(MM_connTryasp_STRING)%><%' *** Edit Operations: declare variables=================================Sesuaikan path anda dan nama fail database.Kenapa gunakan var MM_connTryasp_STRING ?Kerana var ini digunakan dalam baris berikutnya. cuba check kod dibawah<%' *** Insert Record: set variablesIf (CStr(Request("MM_insert")) = "form1") Then MM_editConnection = MM_connTryasp_STRING MM_editTable = "tbl_Username" MM_editRedirectUrl = "thank.html" MM_fieldsStr = "Username|value|IC_No|value" MM_columnsStr = "Username|',none,''|IC_No|',none,''" Edited April 7, 2005 by OngBok Quote Share this post Link to post Share on other sites
starfish_gurlz84 0 Report post Posted April 8, 2005 Buat Connection String1. klik file > new. Pilih dynamic page > asp.net VB2. Klik Template > Microsoft Jet←maner nie tak der pon dah cari dah !!!! file > new > asp.net VB > klik template > tak der per2 !!!! Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted April 8, 2005 Klik Application > Database > + > OLE DB Conn.. Quote Share this post Link to post Share on other sites
peacepeijal 0 Report post Posted August 8, 2005 tahniah kpada ONG BOK ... mjadi lecturer dkat sini... aku bangga putera.com mmpunyai kjasama yg hebat!!tapi aku dah tlambat la thread nih...ulang balik leh x??? [jgn marah... gurau...] nk blaja nih kene ader pc yg berinternet... Quote Share this post Link to post Share on other sites
tiena_77 0 Report post Posted August 9, 2005 Hai semua,saya pun baru belajar guna dreamweaver ni.Macam best tapi tu ler lepas try sampai sekarang masih tak leh nak wat connection walaupun dah cuba step by step yang OngBok tunjuk tu...biler test URL dia kata dreamweaver cannot use the prefix you entered to display live data. HTTP Error: 12029) Kalu ada sesiapa yang boleh bagitau salah kat maner...tima kasihhh Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted August 9, 2005 hmmm... masih ada yang berminat.Betul ke ko ikut step yang aku bagi tu. Sepatutnya tak jadi masalah.Cuba ko check semula step by step. Quote Share this post Link to post Share on other sites
tiena_77 0 Report post Posted August 9, 2005 hihii...memang ler berminat....dah lama nak buat tapi tak kesempatan tapi biler tengok ada tutorial yang OngBok buat tu terus bersemangat nak sambung balik. Dan masalah tadi dah berjaya settlekan...lupa nak startkan IIS....tapi ada masalah lagi .selepas step 1 untuk connection string kan kena g template...tak jumper ler ikon nyer...so tak tau nak g maner....tolonnnn.tq Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted August 9, 2005 DM Ver berapa ko guna.? Quote Share this post Link to post Share on other sites
tiena_77 0 Report post Posted August 11, 2005 Sekali lagi saya berjaya settlekan masalah saya dan telah sampai ke tahap set database connection on site. biler saya view dia kuar error nie:The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. --------------------------------------------------------------------------------A string literal was expected, but no opening quote character was found. Error processing resource 'http://www45.brinkster.... <font face="Arial" size=2>-------------------------^Boleh OngBok bagitau kat maner yang perlu dibetulkan.Tima kasiihhhIni saya nyer kod<?xml version="1.0" encoding="iso-8859-1"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><%Dim myConn,MM_connTryasp_STRINGSet myConn=Server.CreateObject("ADODB.Connection")MM_connTryasp_STRING="DRIVER={Microsoft Access Driver(*.mdb)};"&_"DBQ="&Server.MapPath("\tiena77\db\tryasp.mdb")&";"myConn.Open(MM_connTryap_STRING)%><%' *** Edit Operations: declare variablesDim MM_editActionDim MM_abortEditDim MM_editQueryDim MM_editCmdDim MM_editConnectionDim MM_editTableDim MM_editRedirectUrlDim MM_editColumnDim MM_recordIdDim MM_fieldsStrDim MM_columnsStrDim MM_fieldsDim MM_columnsDim MM_typeArrayDim MM_formValDim MM_delimDim MM_altValDim MM_emptyValDim MM_iMM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Request.QueryStringEnd If' boolean to abort record editMM_abortEdit = false' query string to executeMM_editQuery = ""%><%' *** Insert Record: set variablesIf (CStr(Request("MM_insert")) = "form1") Then MM_editConnection = MM_connTryasp_STRING MM_editTable = "tbl_Username" MM_editRedirectUrl = "" MM_fieldsStr = "Username|value|IC_No|value|id|value" MM_columnsStr = "Username|',none,''|IC_No|',none,''|id|none,none,NULL" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End IfEnd If%><%' *** Insert Record: construct a sql insert statement and execute itDim MM_tableValuesDim MM_dbValuesIf (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End IfEnd If%><html xmlns="http://www.w3.org/1999/xhtml"><head><title>Untitled Document</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /></head><body><form method="post" action="<%=MM_editAction%>" name="form1"> <table align="center"> <tr valign="baseline"> <td nowrap align="right">Username:</td> <td> <input type="text" name="Username" value="" size="32"> </td> </tr> <tr valign="baseline"> <td nowrap align="right">IC_No:</td> <td> <input type="text" name="IC_No" value="" size="32"> </td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td> <input type="submit" value="Insert Record"> </td> </tr> </table> <input type="hidden" name="MM_insert" value="form1"></form><p> </p><p> </p><p> </p></body></html> Quote Share this post Link to post Share on other sites
abixpert 0 Report post Posted March 8, 2006 tadak sambungan ke? Quote Share this post Link to post Share on other sites
TonikCapGajah2013 175 Report post Posted March 8, 2006 ....sambung.tapi aku belum on lagi..Guna DW8 Quote Share this post Link to post Share on other sites