Database problem

Results 1 to 2 of 2

Thread: Database problem

  1. #1
    Nauman Awan Guest

    Default Database problem

    &#060;%option explicit%&#062;<BR><BR>&#060;% dim objconn, strsql<BR>set objconn=server.createobject("adodb.connection")<BR > "provider=microsoft.jet.oledb.4.0;"&_<BR>"data source=c:datastoresmydatabase.mdb;"&_<BR>"persist security info=false;"<BR>strsql="insert into userlogin(userid, username, password, email)"&_<BR>"values (9, &#039;xyz&#039;, &#039;lpj&#039;, &#039;;);"<BR><BR><BR>%&#062;<BR>& #060;!--metadata type="typelib"<BR>file="c:program filescommon filessystemadomsado15.dll"--&#062;<BR><BR>&#060;%dim objcomm<BR><BR>set objcomm=server.createobject("adodb.command")<BR><B R> with objcomm<BR><BR> .activeconnection=objconn<BR> .commandtext=strsql<BR> .commandtype=adcmdtext<BR> .execute=strsql<BR><BR> end with<BR><BR>set objcomm=nothing<BR>%&#062;<BR><BR>This is the error which i get when i load this page<BR><BR>Microsoft JET Database Engine error &#039;80040e14&#039; <BR><BR>Syntax error in INSERT INTO statement. <BR><BR>/database/record.asp, line 11 <BR><BR>this line points to the objcomm.execute strsql line<BR>This problem does not surface when i add enteries in access 97. it is only when i try to add it in office 2000 or office xp it generates an error<BR><BR>if any one can help me with this problem<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Database problem

    password is a reserved word in Jet SQL.<BR><BR>Rename it or use [password]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts