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

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