Connect ASP DAtabase And Adding Records

tgalanopoulos · 22 Νοεμβρίου 2001

Geias bre pedia. Ante na doume 4 mines i selida mou kato giati? Giati den ksero opli kala asp Exo kanei mia forma me pedia opu me auton ton tropo tha simplirono ta pedia ki molis tha patao to koumpi insert tha pigenei sto allo arxeio insertrecord.asp kai tha prosthetei tin eggrafi.Mexri tora to formmadd mia xara molis pao na kano insert den mporei na tin eisagei. sas dino parakato analitika ton kodika tou kathe arxeiou gia na deite pos exei. ypopsin ta permissions einai ok kai to virtual directory .FORMADD.ASP <html><head> <title>Insert Records To Database</title> </head> <body> <form name="Insert Records To Database" method="Post" action="insertrecord.asp"> <center><table><tr><td>Group Artist: </td> <td><input type="text" name="GroupArtist" size="60"></td></tr><tr><td>Title: </td> <td><input type="text" name="Title" size="60"></td></tr><tr><td>CD: </td> <td><input type="text" name="CD" size="6"></td></tr><tr><td>Quantity: </td> <td><input type="text" name="Quantity" size="1"></td></tr><tr><td>TotalTracksPerCd: </td> <td><input type="text" name="TotalTracksPerCd" size="2"></td></tr><tr><td>Gender: </td> <td><input type="text" name="Gender" size="30"></td></tr></table><input type="Submit" name="Submit" value="Insert Record"> </form> </center></body> </html> INSERTRECORD.ASP <%@ Language=VBScript %> <% Option Explicit %> Dim myconn Dim RS Dim strGroupArtist Dim strTitle Dim strCD Dim strQuantity Dim strTotalTracksPerCD Dim strGenderstrGroupArtist = Request.Form("GroupArtist") strTitle = Request.Form("Title") strCD = Request.Form("CD") strQuantity = Request.Form("Quantity") strTotalTracksPerCD = Request.Form("TotalTracksPerCD") strGender = Request.Form("Gender")Set MyConn=Server.CreateObject("ADODB.Connection") Set RS=Server.CreateObject("ADODB.RecordSet")MyConn.open "cds"RS.Open "Select * From Table", MyConn, adOpenDynamic, adLockPessimistic, adCMDTextRS.AddNew RS("GroupArtist")= strGroupArtist RS("Title")= strTitle RS("CD")= strCD RS("Quantity")= strQuantity RS("TotalTracksPerCD")= strTotalTracksPerCD RS("Gender")= strGender RS.UpdateRS.Close MyConn.Close Set RS = Nothing Set MyConn = Nothing %> perito na sas po oti to insert record .asp to exo kanei kai me diaforetikous tropous.alla tothema einai oti den tin kanei add tin eggrafi.Xrisimopoio win 98 kai klasika personal web server.An mporei kapios na me boithisei tha to ektimousa para poli sas eyxaristo ek ton proteron

Johnis · 22 Νοεμβρίου 2001

tgalanopoulos,1) To FORMADD.ASP den exei logo na einai asp mias kai einai apli HTML. 2)Stin asp den diloneis se poio table/database na sindetheis 3)Episis den diloneis username kai pass (an den epitrepei to anonymous logon kai o anonymous na exei select kai insert dikeomata auto tha odigisei se error) 4)An mporeis kane mas ena copy paste to sfalma pou sou bgazei o browser sou.Filika Johnis.

tgalanopoulos · 23 Νοεμβρίου 2001

file gianni se eyxaristo gia to endiaferon sou :> as ta paroume siga siga ta pragmata kai ena ena :>1) To FORMADD.ASP den exei logo na einai asp mias kai einai apli HTML.orea dld mporo to formadd.asp na to kano mia apli html. pos apo kei mesa kalo to insertrecord.asp? me aplo link mou naigei ton browser kai mou deixnei ton kodika tou insertrecord opote tha einai kapia diaforetiki sindesi metaksi tous san link ksereis pos na ta linkaro? kai kati allo stin asp genika i arxiki selida ti prepei na einai se onoma opos leme se html index i home i arxiki stin aso pos einai? kai an prepei na onomaso ego kamia i na tis onomazo opos thelo ? 2)Stin asp den diloneis se poio table/database na sindetheisnai exeis dikio to exo kanei kai auto pou les alla mou ebgaze ena error. den ekane mesa ston kodika connect tin database eno tou eixa dosei ta sxetika server.mappath kai pinakes kai databases sou leo to exo kanei me xilious diaforetikous tropous.tora den kseor epidi katebazo samples apo net an o ISS einai idia GLosa me to PWs , diladi an oi sindeseis ston kodika einai oi idies entoles katalabes? ego xrisimopoio PWS win 98 :> 3)Episis den diloneis username kai pass (an den epitrepei to anonymous logon kai o anonymous na exei select kai insert dikeomata auto tha odigisei se error) Oson afora auto den ksero ego thelo na kano mia apli database na parousiazo eggrafes. asxeta oti meta tha kano ena link gia mena pou tha tou dino to password mou kai tha mpeno na kataxoro. Alla se auti tin apli sindesi kai eisagogi eggrafis se mia database prepei pali na kano anonimous login k.t.l dld na balo permissions? kai apo pou ta bazo auta?4)An mporeis kane mas ena copy paste to sfalma pou sou bgazei o browser sou.oso giauto epidi den exo xrono tora tha ksanaftiakso to file kai tha to trkso kai an einai tha sto steilo ma mail na deis ti problima mou bgazei. Liga info gia ton server pou exo brei oste na kano upload tin basi mou gia des ti ipostirizei.30 Mb Disk Space FTP Access Account Unlimited Bandwidth No Set Up Charges! Standard ASP Scripts No Monthly Fees! Free ODBC System DSN Setup auta ta oliga file pisteuo na se katatopisa kapos kai perimeno nea sou filika teo :>

tgalanopoulos · 23 Νοεμβρίου 2001

A kai pou se jonny exei sxesi pou o server autos o hoster ypostirizei win 2000 kai go to ftiaxno se PWS? kai kati allo epidi exo teliosei baseis dedomenon kai kala :> i access ypostirizei sql statments xalara otan omos pao na balo ston kodika sql entoles mou xtipane. Mipos prepei na katso pano ama thelo teties entoles ton SQL Server 7.0?Koita oti ksereis perimeno na me katatopiseis.exo ena books tis vb6 pou sta last kefalea leei gia asp merika pragmata alla xtes meso net parageila kai to asp 3.0 giati toso kairo pou psaxno exo dei kai exo mperdeutei alla lei o enas alla o allos me xiliades tropous kai eimai skata man se eyxaristo kai ta leme

Johnis · 24 Νοεμβρίου 2001

tgalanopoulos,Na paroume ligo ta pragmata apo tin arxi. Gia na sindeseis mia asp me mia database kai na doulepsei to olo thema ston ipologisti sou prepei na ftiakseis enan ODBC odigo. An den iparxei autos o odigos den mporeis na diloseis pos tha sindetheis me ti basi. Pigene loipon Control Panel -> ODBC DATA SOURCES kai des an iparxei DSN tis basis pou theleis na xrisimopiiseis.An iparxei tote eisai ok.An den iparxei prepei na dimiourgiseis ena. Tora gia Access den ksero tis rithmiseis ktl para mono gia mysql pou katexo. Eipes pos i access ipostirizei sql commands. Ligo xlomo mou fenete.Ksero oti ipostirizei standar VB alla gia sql... ! Eipes oti douleueis me PWs.Den exo idea ti einai.Prosopika douleuo mono me IIS. Sigoura prin sikoseis mia basi sto internet prepei na exeis dosei permissions analoga me to ti thes o telikos xristis na exei.Px an thes mono na emfaniseis ena table prepei na dimiourgiseis ena user pou tha exei Select dikeomata kai tipota allo!Pos bazeis permissions stin Access den ksero.Den exo poliasxolithei me auti.Gia web database xrisimopoio tin MySQL.Stin SQL einai eukolo na doseis apla permissions. Ena paradeigma gia to pos sindeeis mia sql database se mia asp einai to eksis: <% Dim rstTable Dim mConn Dim mCmdSet mConn = Server.CreateObject("ADODB.Connection") Set mCmd = Server.CreateObject("ADODB.Command") Set rstTable = Server.CreateObject("ADODB.Recordset")mConn.ComandTimeout = 40 mConn.CursorLocation = 1 'o parakato kodikas dilonei dsn,database,user k pass mConn.ConnectionString = "server=Localhost;driver=MySQL;db=databasename;uid=Tousername;pwd=okodikos" mConn.Open mCmd.ActiveConnection = mConn mCmd.CommandType = 1 'dilonei oti tha dinei promt entoles mCmd.CommandText = "SELECT * FROM onomatable" rstTable.Open mCmd,,,1 %>Tora gia to FORMADD.ASP, an to metonomaseis se FORMADD.HTM i FORMADD.HTML otan to sikoseis sto net i otan to trekseis meso IIS kai oxi san apli htm selida(kanonta double click) tha kaei oti akribos theleis.Den ksero kata poso apantisa stis apories sou.Aurio pou tha me pio ksekourastos tha simpliroso an ksexasa kati. [ 23-11-2001: Message edited by: Johnis ]

tgalanopoulos · 27 Νοεμβρίου 2001

gianni nai man an pas stin access sta modules pou exei vb code mporeis ekei mesa na xoseis sql commands.Anyway dns exo ftiaksei alla den ksero pou kolaei to olo skiniko kai den kanei add tin eggrafi.Anywayz filarako euxaristo gia ton xrono sou sou eixa pei kai oti exo paragilei to book asp 3.0 kai kati tha bgalo apo kei mesa sigoura tora oson afora to pws VS iis pisteuo oti o iis einai kaliteros alla den exo tis dinatotites hardware manta leme :>

Σύνδεση

Connect ASP DAtabase And Adding Records

Προτεινόμενες αναρτήσεις

tgalanopoulos

Johnis

tgalanopoulos

tgalanopoulos

Johnis

tgalanopoulos

Αρχειοθετημένο

Σύνδεση