access_asp thread: Help!!!!!!
Message #1 by "Kai Fu" <CSMH@G...> on Thu, 2 Aug 2001 22:28:40
|
|
Hi, everyone:
I got all my ASP worked in my local computer, then I put all these ASP
files, UDL link file, and Access Database file onto the our web server.
when I tried to add new record or update a record, it gives me following
error message:
ADODB.Recordset (0x800A0CB3)
Object or provider is not capable of performing requested operation.
My code:
Dim rsFM, rsCli, rsCAP, rsMD, rsVR, rsCS
set rsFM=Server.CreateObject("ADODB.Recordset")
set rscli=Server.CreateObject("ADODB.Recordset")
set rsHH=server.createObject("ADODB.Recordset")
set rsCAP=Server.createObject("ADODB.Recordset")
set rsMD=Server.createObject("ADODB.Recordset")
set rsVR=Server.createObject("ADODB.Recordset")
set rsCS=server.createObject("ADODB.Recordset")
set rsCC=server.createObject("ADODB.Recordset")
rsFM.open "[Family Member Table]", objConn, adOpenforwardOnly,
adLockOptimistic, adCmdTable
rsCli.open "[clienttable]",objConn,adOpenforwardOnly,adLockOptimistic,
adCmdTable
rsHH.open "[Household table]", objConn, adOpenforwardOnly,
adLockOptimistic, adCmdTable
rsCAP.open "[Client Address/Phone table]", objConn, adOpenforwardOnly,
adLockOptimistic, adCmdTable
rsMD.open "Modification", objConn, adOpenforwardOnly,
adLockOptimistic, adCmdTable
rsVR.open "Verification", objConn, adOpenforwardOnly,
adLockOptimistic, adCmdTable
rsCS.open "ClientServices", objConn, adOpenforwardOnly,
adLockOptimistic, adCmdTable
rsCC.open "[Client Comment Table]", objConn, adOpenforwardOnly,
adLockOptimistic, adCmdTable
rsFM.AddNew
rsCli.AddNew
rsHH.AddNew
Is anyone could help? thanks!
Kai
Message #2 by sathish kumar <sathish297@y...> on Thu, 2 Aug 2001 21:32:47 -0700 (PDT)
|
|
Hi,
Include this piece of code in the beggining of the
page
set objcon=Server.CreateObject("ADODB.connection")
objcon.open "DSNName"
--- Kai Fu <CSMH@G...> wrote:
> Hi, everyone:
> I got all my ASP worked in my local computer,
> then I put all these ASP
> files, UDL link file, and Access Database file onto
> the our web server.
> when I tried to add new record or update a record,
> it gives me following
> error message:
> ADODB.Recordset (0x800A0CB3)
> Object or provider is not capable of performing
> requested operation.
>
> My code:
> Dim rsFM, rsCli, rsCAP, rsMD, rsVR, rsCS
> set rsFM=Server.CreateObject("ADODB.Recordset")
> set rscli=Server.CreateObject("ADODB.Recordset")
> set rsHH=server.createObject("ADODB.Recordset")
> set rsCAP=Server.createObject("ADODB.Recordset")
> set rsMD=Server.createObject("ADODB.Recordset")
> set rsVR=Server.createObject("ADODB.Recordset")
> set rsCS=server.createObject("ADODB.Recordset")
> set rsCC=server.createObject("ADODB.Recordset")
> rsFM.open "[Family Member Table]", objConn,
> adOpenforwardOnly,
> adLockOptimistic, adCmdTable
> rsCli.open
>
"[clienttable]",objConn,adOpenforwardOnly,adLockOptimistic,
> adCmdTable
> rsHH.open "[Household table]", objConn,
> adOpenforwardOnly,
> adLockOptimistic, adCmdTable
> rsCAP.open "[Client Address/Phone table]", objConn,
> adOpenforwardOnly,
> adLockOptimistic, adCmdTable
> rsMD.open "Modification", objConn,
> adOpenforwardOnly,
> adLockOptimistic, adCmdTable
> rsVR.open "Verification", objConn,
> adOpenforwardOnly,
> adLockOptimistic, adCmdTable
> rsCS.open "ClientServices", objConn,
> adOpenforwardOnly,
> adLockOptimistic, adCmdTable
> rsCC.open "[Client Comment Table]", objConn,
> adOpenforwardOnly,
> adLockOptimistic, adCmdTable
>
> rsFM.AddNew
> rsCli.AddNew
> rsHH.AddNew
>
> Is anyone could help? thanks!
>
> Kai
|
View Cart
