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]
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hsp7juv/M=362329.6886308.7839368.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1124434378/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</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/
