Error 80040e21

[Andy Milk]

I'm getting this message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Errors occurred


When I try to pull up a page with an primary key ID that's larger than 127.

Has anyone seen this problem or know what this error is?

-Andy Milk

[John]

Hi Andy,

Define "pull up a page"? You're using ASP-db to do this?

What database?

Does this only happen when the key value exceeds 127?

What line are you getting the error on?

Do you get this error when you run pureasp.asp ?

This will help us troubleshoot with you.

Thanks,
John


On 2/9/99 4:33:50 PM, Andy Milk wrote:
> I'm getting this message:

Microsoft OLE DB Provider for ODBC Drivers
> error '80040e21'

Errors occurred


When I try to pull up a
> page with an primary key ID that's larger than 127.

Has anyone seen
> this problem or know what this error is?

-Andy Milk

[Andy Milk]

I'm sorry, I wasn't very specific about my problem.

I am using ASP with SQL Server 6.5

The code that I'm using is:

SET cmdProduct = Server.CreateObject("ADODB.Command&#34
cmdProduct.ActiveConnection = "DSN=xxxx;UID=xxxx;PWD=xxxx;"
cmdProduct.CommandText = "qProduct"
cmdProduct.CommandType = 4
Set prmProduct = cmdProduct.CreateParameter("pProductID&#34
prmProduct.Type = adTinyint
prmProduct.Direction = adParamInput
prmProduct.Size = Len(ProductID)
prmProduct.Value = ProductID
cmdProduct.Parameters.Append prmProduct

Set rsProduct = Server.CreateObject("ADODB.Recordset&#34
rsProduct.Open cmdProduct, , adOpenKeyset, adCmdTable


I'm creating a command object with an ActiveConnection, adding a parameter to it, and then creating a recordset with the command.

The last line of code gives me the error, when I open the recordset. When I create this recordset using any of the records under 128, I don't get the error. The stored procedure returns 5 or 6 fields, one of which is the primary key called "ID".

Thanks for any help you can give me,
Andy Milk




On 2/9/99 9:40:39 PM, John wrote:
> Hi Andy,

Define "pull up a page"? You're using ASP-db to do
> this?

What database?

Does this only happen when the key value exceeds
> 127?

What line are you getting the error on?

Do you get this error
> when you run pureasp.asp ?

This will help us troubleshoot with
> you.

Thanks,
John


On 2/9/99 4:33:50 PM, Andy Milk wrote:
>
> I'm getting this message:

Microsoft OLE DB Provider for ODBC Drivers
>
> error '80040e21'

Errors occurred


When I try to pull
> up a
> page with an primary key ID that's larger than 127.

Has
> anyone seen
> this problem or know what this error is?

-Andy Milk

[John]

Hi Andy,

As I mentioned in the first line of my reply, "You're using ASP-db to do this?"

This forum is dedicated to the product support of ASP-db. There's an ASP
support forum that is frequented by the people you want to post this in
front of. You also may get a good response in the SQL forum where they'd
be more familiar with the ODBC errors.

Thanks,
John


On 2/10/99 8:16:19 AM, Andy Milk wrote:
>
I'm sorry, I wasn't very specific about my problem.

I am using
> ASP with SQL Server 6.5

The code that I'm using is:

SET
> cmdProduct =
> Server.CreateObject("ADODB.Command&#34
cmdProduct.ActiveConnection
> = "DSN=xxxx;UID=xxxx;PWD=xxxx;"
cmdProduct.CommandText =
> "qProduct"
cmdProduct.CommandType = 4
Set prmProduct =
> cmdProduct.CreateParameter("pProductID&#34
prmProduct.Type =
> adTinyint
prmProduct.Direction = adParamInput
prmProduct.Size =
> Len(ProductID)
prmProduct.Value =
> ProductID
cmdProduct.Parameters.Append prmProduct

Set rsProduct =
> Server.CreateObject("ADODB.Recordset&#34
rsProduct.Open
> cmdProduct, , adOpenKeyset, adCmdTable


I'm creating a command
> object with an ActiveConnection, adding a parameter to it, and then
> creating a recordset with the command.

The last line of code gives me
> the error, when I open the recordset. When I create this recordset using
> any of the records under 128, I don't get the error. The stored
> procedure returns 5 or 6 fields, one of which is the primary key called
> "ID".

Thanks for any help you can give me,
Andy
> Milk




On 2/9/99 9:40:39 PM, John wrote:
> Hi Andy,

Define
> "pull up a page"? You're using ASP-db to do
> this?

What
> database?

Does this only happen when the key value exceeds
>
> 127?

What line are you getting the error on?

Do you get this error
>
> when you run pureasp.asp ?

This will help us troubleshoot with
>
> you.

Thanks,
John


On 2/9/99 4:33:50 PM, Andy Milk wrote:
>
>
> I'm getting this message:

Microsoft OLE DB Provider for ODBC Drivers
>
>
> error '80040e21'

Errors occurred


When I try to
> pull
> up a
> page with an primary key ID that's larger than
> 127.

Has
> anyone seen
> this problem or know what this error
> is?

-Andy Milk

[Veena]

Hi
I am getting the error called "error 80040e21" when i am trying to display records from DB.I have only 2 records in my database.
Coluld you please help me to correct in this

On 2/10/99 5:38:35 PM, John wrote:
> Hi Andy,

As I mentioned in the first line of my reply, "You're
> using ASP-db to do this?"

This forum is dedicated to the product
> support of ASP-db. There's an ASP
support forum that is frequented by
> the people you want to post this in
front of. You also may get a good
> response in the SQL forum where they'd
be more familiar with the ODBC
> errors.

Thanks,
John


On 2/10/99 8:16:19 AM, Andy Milk wrote:
>
>
I'm sorry, I wasn't very specific about my problem.

I am using
>
> ASP with SQL Server 6.5

The code that I'm using is:

SET
>
> cmdProduct =
>
> Server.CreateObject("ADODB.Command&#34
cmdProduct.ActiveConnection
>
> = "DSN=xxxx;UID=xxxx;PWD=xxxx;"
cmdProduct.CommandText =
>
> "qProduct"
cmdProduct.CommandType = 4
Set prmProduct =
>
> cmdProduct.CreateParameter("pProductID&#34
prmProduct.Type =
>
> adTinyint
prmProduct.Direction = adParamInput
prmProduct.Size =
>
> Len(ProductID)
prmProduct.Value =
>
> ProductID
cmdProduct.Parameters.Append prmProduct

Set rsProduct =
>
> Server.CreateObject("ADODB.Recordset&#34
rsProduct.Open
>
> cmdProduct, , adOpenKeyset, adCmdTable


I'm creating a command
>
> object with an ActiveConnection, adding a parameter to it, and then
>
> creating a recordset with the command.

The last line of code gives me
>
> the error, when I open the recordset. When I create this recordset
> using
> any of the records under 128, I don't get the error. The
> stored
> procedure returns 5 or 6 fields, one of which is the primary key
> called
> "ID".

Thanks for any help you can give me,
Andy
>
> Milk




On 2/9/99 9:40:39 PM, John wrote:
> Hi Andy,

Define
>
> "pull up a page"? You're using ASP-db to do
>
> this?

What
> database?

Does this only happen when the key value
> exceeds
>
> 127?

What line are you getting the error on?

Do you
> get this error
>
> when you run pureasp.asp ?

This will help us
> troubleshoot with
>
> you.

Thanks,
John


On 2/9/99 4:33:50 PM,
> Andy Milk wrote:
>
>
> I'm getting this message:

Microsoft OLE
> DB Provider for ODBC Drivers
>
>
> error '80040e21'
>

Errors occurred


When I try to
> pull
> up a
> page with an
> primary key ID that's larger than
> 127.

Has
> anyone seen
>
> this problem or know what this error
> is?

-Andy Milk