|
Subject:
|
ASP
|
|
Posted By:
|
Swaragh
|
Post Date:
|
1/9/2006 4:14:58 PM
|
Hi,
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/cms6/conn.asp, line 40
<%
dim oConnstring
dim oConn
dim objcmd
oConnstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\Inetpub\WWWroot\cms6\INCLUDES\DB\db1.mdb"
Url="http://swaragh/cms6/"
path="G:\cms"
Set oConn = Server.Createobject("ADODB.Connection")
oConn.Open oConnstring
set objcmd=Server.CreateObject("ADODB.Command")
objcmd.ActiveConnection=oConnstring
objcmd.CommandText = "UPDATE Test SET Item_Name='Raghavendra' where Item_No=1"
objcmd.CommandType = adCmdText
objcmd.Execute
'objcmd.CommandText = "Insert into Users(User_ID, J_Name, J_Password) values(9,'Rky','rky')"
'objcmd.CommandType = adCmdText
'objcmd.Execute
Set objcmd = Nothing
Set oConn = Nothing
%>
I had executed the above quires in MS ACCESS its working fine.
I am using MS ACCESS 2002.
OS-windows 2000 Professional.
I am not able to update and insert any records,
but I can retrive records.
Pls help me out.
Waiting for ur reply.
regards,
Raghavendra
|
|
Reply By:
|
mat41
|
Reply Date:
|
1/9/2006 5:18:31 PM
|
Have you tryed asking google? Always ask google first - your solution is everywhere on ther first result page.
Problem : You have not defined the constants adOpenForwardOnly, asLockOptimistic, and adCmdTable
Solution : You need to include the file adovbs.inc in your page. For more on this topic, see:
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=123
If you searched this forum your solution is also here:
http://p2p.wrox.com/topic.asp?TOPIC_ID=13349
(this post has been addressed by Mr ASP, lucky you...)
FYI : Make sure the IUSER has the proper permissions to the dir where your .mdb file sits within each of your web sites.
Wind is your friend
Matt
|
|
