cn is the connection object so u cannot assign any value to the variable. use the following: cn.open ="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath ("/access_db/wecommerce.mdb")
All the Best On 8/19/05, Jegatha <[EMAIL PROTECTED]> wrote: > > My code is > <% > dim username,password,bidamount,noofdays,details,count > dim budget,bidno,cn,rs,bidno1,pro,project,sql > project=session("project") > bidno=session("bidno") > pro=session("projectname") > bidno1=bidno+1 > response.write project > response.write bidno > response.write pro > set cn=server.createobject("ADODB.connection") > set rs=server.createobject("ADODB.recordset") > set rs1=server.createobject("ADODB.recordset") > set rs2=server.createobject("ADODB.recordset") > set sql=server.createobject("ADODB.recordset") > cn="DRIVER={Microsoft Access Driver (*.mdb)}; " > cn=cn & "DBQ=" & Server.MapPath("/access_db/wecommerce.mdb") > rs1.open "select * from 3dmaxsubmit",cn,1,2 > rs2.open "select * from 3dmax",cn,1,2 > rs.open "select * from 3dmax",cn,1,2 > sql="update 3dmax set Bids="&bidno1&" where ProjectNumber="&project&" " > cn.execute sql > %> > > Jeg > > Dan Powderhill <[EMAIL PROTECTED]> wrote: > Can you show us the code which opens your database connection? > > Dan > > ________________________________ > > From: AspClassicAnyQuestionIsOk@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha > Sent: 18 August 2005 11:56 > To: Asp > Subject: [AspClassicAnyQuestionIsOk] update error > > > using the following code for updation, > > sql="update 3dmax set Bids="&bidno1&" where ProjectName='"&pro&"' " > cn.execute sql /*****line 32***/ > > it shows error as, > Microsoft VBScript runtime error '800a01a8' > > Object required: 'DRIVER={Microsoft Ac' > /wecommerce/3dmax2submit.asp, line 32 > > any one tell what will be the error?!! > > thanks in adv > > Jegatha > > > > > --------------------------------- > Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and > lots more. > http://in.promos.yahoo.com/rakhi/index.html > > [Non-text portions of this message have been removed] > > > > ________________________________ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AspClassicAnyQuestionIsOk > <http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] > subscribe> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > ________________________________ > > > > > [Non-text portions of this message have been removed] > > > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "AspClassicAnyQuestionIsOk" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > --------------------------------- > Check out Yahoo! India Rakhi Special for Rakhi shopping, contests and lots > more. > http://in.promos.yahoo.com/rakhi/index.html > > [Non-text portions of this message have been removed] > > > > SPONSORED LINKS > Programming > languages<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Programming+languages&w2=C+programming+language&w3=Computer+programming+languages&w4=Java+programming+language&w5=C+++programming+language&w6=History+of+computer+programming+language&c=6&s=198&.sig=hjFSMmldhVc3zrT5SqL9xQ> > C > programming > language<http://groups.yahoo.com/gads?t=ms&k=C+programming+language&w1=Programming+languages&w2=C+programming+language&w3=Computer+programming+languages&w4=Java+programming+language&w5=C+++programming+language&w6=History+of+computer+programming+language&c=6&s=198&.sig=td85HQ93XfErfw7wfLZ86A> > Computer > programming > languages<http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=Programming+languages&w2=C+programming+language&w3=Computer+programming+languages&w4=Java+programming+language&w5=C+++programming+language&w6=History+of+computer+programming+language&c=6&s=198&.sig=BMtgOo7dpsC1xzn1YgpBPg> > Java > programming > language<http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Programming+languages&w2=C+programming+language&w3=Computer+programming+languages&w4=Java+programming+language&w5=C+++programming+language&w6=History+of+computer+programming+language&c=6&s=198&.sig=8IuywkhSLTtpB6_iFiJoCQ> > C > programming > language<http://groups.yahoo.com/gads?t=ms&k=C+++programming+language&w1=Programming+languages&w2=C+programming+language&w3=Computer+programming+languages&w4=Java+programming+language&w5=C+++programming+language&w6=History+of+computer+programming+language&c=6&s=198&.sig=jpmDiGf8qD8AqZNqFwDO7w> > History > of computer programming > language<http://groups.yahoo.com/gads?t=ms&k=History+of+computer+programming+language&w1=Programming+languages&w2=C+programming+language&w3=Computer+programming+languages&w4=Java+programming+language&w5=C+++programming+language&w6=History+of+computer+programming+language&c=6&s=198&.sig=9slR1_vZJlvyOINA4iLkow> > > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group > "AspClassicAnyQuestionIsOk<http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk>" > > on the web. > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ > -- Balaji V [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hph93e6/M=362335.6886445.7839731.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124523217/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/">In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/