|
 |
access_asp thread: Error Adding New Record
Message #1 by "Vinni" <vin_sax@y...> on Wed, 27 Feb 2002 15:58:04
|
|
Hi all,
I'm getting an error while inserting record in access database. Please
help and let me know where I'm going wrong.
Thanks,
Vinni
<!-- METADATA TYPE="C:\WINDOWS\SYSTEM32\typelib.dll"
FILE="C:\Program Files\Comman Files\System\ado\msado15.dll"-->
<%
Dim strConnect, objRs
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\datastores\Movie2000.mdb;" & _
"Persist Security Info=False"
Set objRS=Server.CreateObject ("ADODB.Recordset")
objRS.Open "Movies", strConnect,adOpenStatic,adLockOptimistic ,adCmdTable
objRs.AddNew
objRs("Title") = "Psycho"
objRs.Update
objRs.Close
%>
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
Message #2 by "Peter Rooney" <peter.rooney@p...> on Wed, 27 Feb 2002 16:09:42 -0000
|
|
Vinni,
Two things firstly you have an upper case S on the recordset you are trying
to open objRS instead of objRs. If that doesn't work try adding the
"adovbs.inc" file to the asp document, call it in like <!--#include
file="adovbs.inc" --> you can find this file by doing a search on you
machine then just copy it and paste it into you web directory
HTH
Peter
-----Original Message-----
From: Vinni [mailto:vin_sax@y...]
Sent: 27 February 2002 15:58
To: Access ASP
Subject: [access_asp] Error Adding New Record
Hi all,
I'm getting an error while inserting record in access database. Please
help and let me know where I'm going wrong.
Thanks,
Vinni
<!-- METADATA TYPE="C:\WINDOWS\SYSTEM32\typelib.dll"
FILE="C:\Program Files\Comman Files\System\ado\msado15.dll"-->
<%
Dim strConnect, objRs
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\datastores\Movie2000.mdb;" & _
"Persist Security Info=False"
Set objRS=Server.CreateObject ("ADODB.Recordset")
objRS.Open "Movies", strConnect,adOpenStatic,adLockOptimistic ,adCmdTable
objRs.AddNew
objRs("Title") = "Psycho"
objRs.Update
objRs.Close
%>
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
--
Virus scanned by edNET.
Message #3 by "Vinni" <vin_sax@y...> on Wed, 27 Feb 2002 19:33:15
|
|
Thanks Peter,
You suggestion of adding the adovbs.inc file solved my problem and it
worked. Thanks a lot as i was struggling with this problem for the last
couple of days. I really appreciate your timely help, as I'm new to ASP
your help has given a boost to my learning.
Vinni
> Vinni,
>
> Two things firstly you have an upper case S on the recordset you are
trying
> to open objRS instead of objRs. If that doesn't work try adding the
> "adovbs.inc" file to the asp document, call it in like <!--#include
> file="adovbs.inc" --> you can find this file by doing a search on you
> machine then just copy it and paste it into you web directory
>
> HTH
>
> Peter
>
> -----Original Message-----
> From: Vinni [mailto:vin_sax@y...]
> Sent: 27 February 2002 15:58
> To: Access ASP
> Subject: [access_asp] Error Adding New Record
>
>
>
> Hi all,
>
> I'm getting an error while inserting record in access database. Please
> help and let me know where I'm going wrong.
>
> Thanks,
>
> Vinni
>
> <!-- METADATA TYPE="C:\WINDOWS\SYSTEM32\typelib.dll"
> FILE="C:\Program Files\Comman Files\System\ado\msado15.dll"-->
> <%
> Dim strConnect, objRs
>
> strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=C:\datastores\Movie2000.mdb;" & _
> "Persist Security Info=False"
>
> Set objRS=Server.CreateObject ("ADODB.Recordset")
> objRS.Open "Movies",
strConnect,adOpenStatic,adLockOptimistic ,adCmdTable
>
> objRs.AddNew
> objRs("Title") = "Psycho"
> objRs.Update
> objRs.Close
> %>
>
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
>
> --
> Virus scanned by edNET.
>
Message #4 by "Peter Rooney" <peter.rooney@w...> on Wed, 27 Feb 2002 20:34:59 -0000
|
|
Glad to be of help Vinni
-----Original Message-----
From: Vinni [mailto:vin_sax@y...]
Sent: 27 February 2002 19:33
To: Access ASP
Subject: [access_asp] RE: Error Adding New Record
Thanks Peter,
You suggestion of adding the adovbs.inc file solved my problem and it
worked. Thanks a lot as i was struggling with this problem for the last
couple of days. I really appreciate your timely help, as I'm new to ASP
your help has given a boost to my learning.
Vinni
> Vinni,
>
> Two things firstly you have an upper case S on the recordset you are
trying
> to open objRS instead of objRs. If that doesn't work try adding the
> "adovbs.inc" file to the asp document, call it in like <!--#include
> file="adovbs.inc" --> you can find this file by doing a search on you
> machine then just copy it and paste it into you web directory
>
> HTH
>
> Peter
>
> -----Original Message-----
> From: Vinni [mailto:vin_sax@y...]
> Sent: 27 February 2002 15:58
> To: Access ASP
> Subject: [access_asp] Error Adding New Record
>
>
>
> Hi all,
>
> I'm getting an error while inserting record in access database. Please
> help and let me know where I'm going wrong.
>
> Thanks,
>
> Vinni
>
> <!-- METADATA TYPE="C:\WINDOWS\SYSTEM32\typelib.dll"
> FILE="C:\Program Files\Comman Files\System\ado\msado15.dll"-->
> <%
> Dim strConnect, objRs
>
> strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=C:\datastores\Movie2000.mdb;" & _
> "Persist Security Info=False"
>
> Set objRS=Server.CreateObject ("ADODB.Recordset")
> objRS.Open "Movies",
strConnect,adOpenStatic,adLockOptimistic ,adCmdTable
>
> objRs.AddNew
> objRs("Title") = "Psycho"
> objRs.Update
> objRs.Close
> %>
>
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
>
$subst('Email.Unsub').
> --
> Virus scanned by edNET.
>
--
Virus scanned by edNET.
Message #5 by "Vinni" <vin_sax@y...> on Thu, 28 Feb 2002 15:52:06
|
|
Peter,
Can i have your email id. as it does not appear clearly on this forum.
Just to be in touch with you..my email id is clearly seen on this page.
Thanks,
Vinni
> Glad to be of help Vinni
>
> -----Original Message-----
> From: Vinni [mailto:vin_sax@y...]
> Sent: 27 February 2002 19:33
> To: Access ASP
> Subject: [access_asp] RE: Error Adding New Record
>
>
>
> Thanks Peter,
>
> You suggestion of adding the adovbs.inc file solved my problem and it
> worked. Thanks a lot as i was struggling with this problem for the last
> couple of days. I really appreciate your timely help, as I'm new to ASP
> your help has given a boost to my learning.
>
> Vinni
>
>
>
> > Vinni,
> >
> > Two things firstly you have an upper case S on the recordset you are
> trying
> > to open objRS instead of objRs. If that doesn't work try adding the
> > "adovbs.inc" file to the asp document, call it in like <!--#include
> > file="adovbs.inc" --> you can find this file by doing a search on you
> > machine then just copy it and paste it into you web directory
> >
> > HTH
> >
> > Peter
> >
> > -----Original Message-----
> > From: Vinni [mailto:vin_sax@y...]
> > Sent: 27 February 2002 15:58
> > To: Access ASP
> > Subject: [access_asp] Error Adding New Record
> >
> >
> >
> > Hi all,
> >
> > I'm getting an error while inserting record in access database. Please
> > help and let me know where I'm going wrong.
> >
> > Thanks,
> >
> > Vinni
> >
> > <!-- METADATA TYPE="C:\WINDOWS\SYSTEM32\typelib.dll"
> > FILE="C:\Program Files\Comman Files\System\ado\msado15.dll"-->
> > <%
> > Dim strConnect, objRs
> >
> > strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> > "Data Source=C:\datastores\Movie2000.mdb;" & _
> > "Persist Security Info=False"
> >
> > Set objRS=Server.CreateObject ("ADODB.Recordset")
> > objRS.Open "Movies",
> strConnect,adOpenStatic,adLockOptimistic ,adCmdTable
> >
> > objRs.AddNew
> > objRs("Title") = "Psycho"
> > objRs.Update
> > objRs.Close
> > %>
> >
> > Error Type:
> > ADODB.Recordset (0x800A0BB9)
> > Arguments are of the wrong type, are out of acceptable range, or are in
> > conflict with one another.
> >
> $subst('Email.Unsub').
> > --
> > Virus scanned by edNET.
> >
>
> --
> Virus scanned by edNET.
>
>
|
|
|
View Cart
