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: [email protected]
> [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/
