|
 |
asp_databases thread: Help!! Mail list
Message #1 by "stewart severino" <lux_seve@h...> on Mon, 30 Jul 2001 13:04:41 -0400
|
|
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another
I am trying to make a mail_list where you would enter an email address and
it would be saved to my access database.
Can someone help me with the above error.....This is the line with the
error......objRec.Open "emaillist", strConnect,
adOpenStatic,adLockOptimistic, adCmdTable
Thanks in advance,
Stu
>From: Sam Clohesy <sam@e...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] RE: Generic Code
>Date: Fri, 27 Jul 2001 12:12:09 +0100
>
><%
>'
>'
>'
>
>ConnString = "conneventsdiary"
>'ConnString = "DRIVER={Microsoft Access Driver (*.mdb)};
>DBQ=d:\users\asp-dev.ml.org\db\ubbs.mdb"
>
>
>BBTitle = "Discussion Forum"
>
>BadWordFiler = "true" ' True / False To use filter
>
>Smiles = "true" ' True/False to use Smiles
>
>ICQ = "true" ' True/False to use ICQ Graphics
>
>PageBGColor = "#D9A3C6"
>
>TitleImgLocation = "bboard.gif"
>
>DefaultFontFace = "Frutiger 45 Light, Arial, Helvetica"
>DefaultFontColor = "#000000"
>
>LinkColor = "#000000"
>LinkTextDecoration = "underline"
>
>VisitedLinkColor = "#008080"
>VisitedTextDecoration = "underline"
>
>ActiveLinkColor = "red"
>
>HoverFontColor = "red"
>HoverTextDecoration = "underline"
>
>HeadCellColor="#660066"
>HeadFontColor = "#ffffff"
>
>CategoryCellColor="#8080FF"
>CategoryFontColor="#CCCCCC"
>
>ForumCellColor = "#F4F2F4"
>AltForumCellColor = "#CCCCCC"
>
>ForumFontColor = "#000080"
>ForumLinkColor = "#000080"
>
>NewFontColor = "#000000"
>
>
>%>
>
>This came from a free forum download from Aspin.com
>
>Quite useful though
Message #2 by "Tomm Matthis" <matthis@b...> on Mon, 30 Jul 2001 13:48:35 -0400
|
|
Look at your last parameter.
Try it without the adCmdTable.
-- Tomm
> -----Original Message-----
> From: stewart severino [mailto:lux_seve@h...]
> Sent: Monday, July 30, 2001 1:05 PM
> To: ASP Databases
> Subject: [asp_databases] Help!! Mail list
>
>
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are
in
> conflict with one another
>
> I am trying to make a mail_list where you would enter an email
> address and
> it would be saved to my access database.
> Can someone help me with the above error.....This is the line with the
> error......objRec.Open "emaillist", strConnect,
> adOpenStatic,adLockOptimistic, adCmdTable
>
> Thanks in advance,
> Stu
Message #3 by "raghu bejgum" <raghu_hale@h...> on Tue, 31 Jul 2001 10:14:46 +0530
|
|
I think there is some conflict in the variable names i mean to say what ever
the variables u r using, they might be some reserve words.. why dont u try
using some other names.
Raghavendra.B
S/w Engineer
Globarena Group
>From: "stewart severino" <lux_seve@h...>
>Reply-To: "ASP Databases" <asp_databases@p...>
>To: "ASP Databases" <asp_databases@p...>
>Subject: [asp_databases] Help!! Mail list
>Date: Mon, 30 Jul 2001 13:04:41 -0400
>
>Error Type:
>ADODB.Recordset (0x800A0BB9)
>Arguments are of the wrong type, are out of acceptable range, or are in
>conflict with one another
>
>I am trying to make a mail_list where you would enter an email address and
>it would be saved to my access database.
>Can someone help me with the above error.....This is the line with the
>error......objRec.Open "emaillist", strConnect,
>adOpenStatic,adLockOptimistic, adCmdTable
>
>Thanks in advance,
>Stu
>
>
>
>
>
>
>
>
>>From: Sam Clohesy <sam@e...>
>>Reply-To: "ASP Databases" <asp_databases@p...>
>>To: "ASP Databases" <asp_databases@p...>
>>Subject: [asp_databases] RE: Generic Code
>>Date: Fri, 27 Jul 2001 12:12:09 +0100
>>
>><%
>>'
>>'
>>'
>>
>>ConnString = "conneventsdiary"
>>'ConnString = "DRIVER={Microsoft Access Driver (*.mdb)};
>>DBQ=d:\users\asp-dev.ml.org\db\ubbs.mdb"
>>
>>
>>BBTitle = "Discussion Forum"
>>
>>BadWordFiler = "true" ' True / False To use filter
>>
>>Smiles = "true" ' True/False to use Smiles
>>
>>ICQ = "true" ' True/False to use ICQ Graphics
>>
>>PageBGColor = "#D9A3C6"
>>
>>TitleImgLocation = "bboard.gif"
>>
>>DefaultFontFace = "Frutiger 45 Light, Arial, Helvetica"
>>DefaultFontColor = "#000000"
>>
>>LinkColor = "#000000"
>>LinkTextDecoration = "underline"
>>
>>VisitedLinkColor = "#008080"
>>VisitedTextDecoration = "underline"
>>
>>ActiveLinkColor = "red"
>>
>>HoverFontColor = "red"
>>HoverTextDecoration = "underline"
>>
>>HeadCellColor="#660066"
>>HeadFontColor = "#ffffff"
>>
>>CategoryCellColor="#8080FF"
>>CategoryFontColor="#CCCCCC"
>>
>>ForumCellColor = "#F4F2F4"
>>AltForumCellColor = "#CCCCCC"
>>
>>ForumFontColor = "#000080"
>>ForumLinkColor = "#000080"
>>
>>NewFontColor = "#000000"
>>
>>
>>%>
>>
>>This came from a free forum download from Aspin.com
>>
>>Quite useful though
Message #4 by Steve Carter <Steve.Carter@t...> on Tue, 31 Jul 2001 10:19:12 +0100
|
|
If the emaillist is a table then there should be no problem with this.
My guess is that you haven't included adovbs.inc, so the constants
adOpenStatic, adLockOptimistic, and adCmdTable are not instantiated,
and are evaluating to 0. This is equivalent to saying
adOpenForwardOnly
and leaving off the other two parameters.
HTH,
Steve.
> -----Original Message-----
> From: Tomm Matthis [mailto:matthis@b...]
> Sent: 30 July 2001 18:49
> To: ASP Databases
> Subject: [asp_databases] RE: Help!! Mail list
>
>
> Look at your last parameter.
> Try it without the adCmdTable.
>
> -- Tomm
>
> > -----Original Message-----
> > From: stewart severino [mailto:lux_seve@h...]
> > Sent: Monday, July 30, 2001 1:05 PM
> > To: ASP Databases
> > Subject: [asp_databases] Help!! Mail list
> >
> >
> > Error Type:
> > ADODB.Recordset (0x800A0BB9)
> > Arguments are of the wrong type, are out of acceptable
> range, or are in
> > conflict with one another
> >
> > I am trying to make a mail_list where you would enter an email
> > address and
> > it would be saved to my access database.
> > Can someone help me with the above error.....This is the
> line with the
> > error......objRec.Open "emaillist", strConnect,
> > adOpenStatic,adLockOptimistic, adCmdTable
> >
> > Thanks in advance,
> > Stu
>
Message #5 by "stewart severino" <lux_seve@h...> on Tue, 31 Jul 2001 10:12:56 -0400
|
|
Thnaks steve but I did include the ADOVBS.inc file but I gave it the
extstention .asp would that be a problem???
Stewart Severino
>From: Steve Carter
>Reply-To: "ASP Databases"
>To: "ASP Databases"
>Subject: [asp_databases] RE: Help!! Mail list
>Date: Tue, 31 Jul 2001 10:19:12 +0100
>
>If the emaillist is a table then there should be no problem with this.
>
>My guess is that you haven't included adovbs.inc, so the constants
>adOpenStatic, adLockOptimistic, and adCmdTable are not instantiated,
>and are evaluating to 0. This is equivalent to saying adOpenForwardOnly
>and leaving off the other two parameters.
>
>HTH,
>
>Steve.
>
>
>
> > -----Original Message-----
> > From: Tomm Matthis [mailto:matthis@b...]
> > Sent: 30 July 2001 18:49
> > To: ASP Databases
> > Subject: [asp_databases] RE: Help!! Mail list
> >
> >
> > Look at your last parameter.
> > Try it without the adCmdTable.
> >
> > -- Tomm
> >
> > > -----Original Message-----
> > > From: stewart severino [mailto:lux_seve@h...]
> > > Sent: Monday, July 30, 2001 1:05 PM
> > > To: ASP Databases
> > > Subject: [asp_databases] Help!! Mail list
> > >
> > >
> > > Error Type:
> > > ADODB.Recordset (0x800A0BB9)
> > > Arguments are of the wrong type, are out of acceptable
> > range, or are in
> > > conflict with one another
> > >
> > > I am trying to make a mail_list where you would enter an email
> > > address and
> > > it would be saved to my access database.
> > > Can someone help me with the above error.....This is the
> > line with the
> > > error......objRec.Open "emaillist", strConnect,
> > > adOpenStatic,adLockOptimistic, adCmdTable
> > >
> > > Thanks in advance,
> > > Stu
Message #6 by Steve Carter <Steve.Carter@t...> on Tue, 31 Jul 2001 15:59:47 +0100
|
|
No problem as long as you called it .asp in noth the filename and in the
include tag!
Did you include the file at the top of your code (i.e. before using ADO?)
It may sound like a stupid question but I'm just being thorough!
> -----Original Message-----
> From: stewart severino [mailto:lux_seve@h...]
> Sent: 31 July 2001 15:13
> To: ASP Databases
> Subject: [asp_databases] RE: Help!! Mail list
>
>
> Thnaks steve but I did include the ADOVBS.inc file but I gave it the
> extstention .asp would that be a problem???
>
Message #7 by "stewart severino" <lux_seve@h...> on Tue, 31 Jul 2001 11:24:19 -0400
|
|
Yes I did.....But I am still getting that dam error. Could it be a problem with my DB connection????
Stewart Severino
>From: Steve Carter
>Reply-To: "ASP Databases"
>To: "ASP Databases"
>Subject: [asp_databases] RE: Help!! Mail list
>Date: Tue, 31 Jul 2001 15:59:47 +0100
>
>No problem as long as you called it .asp in noth the filename and in the
>include tag!
>
>Did you include the file at the top of your code (i.e. before using ADO?)
>
>It may sound like a stupid question but I'm just being thorough!
>
> > -----Original Message-----
> > From: stewart severino [mailto:lux_seve@h...]
> > Sent: 31 July 2001 15:13
> > To: ASP Databases
> > Subject: [asp_databases] RE: Help!! Mail list
> >
> >
> > Thnaks steve but I did include the ADOVBS.inc file but I gave it the
> > extstention .asp would that be a problem???
|
|
|
View Cart
