
April 18th, 2003, 07:50 PM
|
|
Registered User
|
|
Join Date: Apr 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
HELP I can't insert into a database
Hi, I hope somebody help me. I was try from same ways to insert something into my database and I don't know what I'm doing bad. Here is my Code to insert (is simple):<br><%<br><br> Name=Request.Form("Name")<br> SET Obj_Conn = Server.CreateObject("ADODB.Connection")<br><br> Obj_Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Alumnos.mdb"))<br> SQL="INSERT INTO table (Name) VALUES ('"&Name&"')"<br> Set Obj_Rs = Obj_Conn.Execute(SQL)<br> <br> Obj_Rs.Close<br> Obj_Conn.Close<br> Obj_Rs=Nothing<br> Obj_Rs=Nothing<br>%><br><br>I got to belive that maybe is my server that don't give to me permission to write the database. PLEASE SOME BODY HELP!!<br>HERE IS THE PAGE: <br>http://www.nomada.com/Pruebas/ejemploBD.asp<br> <img border="0" src="/forum/emoticons/yeah.gif" height="25" width="19" alt="yeah" />
|