-
Error 80040e21
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
-
Error 80040e21 (reply)
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
-
Error 80040e21 (reply)
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"
cmdProduct.ActiveConnection = "DSN=xxxx;UID=xxxx;PWD=xxxx;"
cmdProduct.CommandText = "qProduct"
cmdProduct.CommandType = 4
Set prmProduct = cmdProduct.CreateParameter("pProductID"
prmProduct.Type = adTinyint
prmProduct.Direction = adParamInput
prmProduct.Size = Len(ProductID)
prmProduct.Value = ProductID
cmdProduct.Parameters.Append prmProduct
Set rsProduct = Server.CreateObject("ADODB.Recordset"
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
-
Error 80040e21 (reply)
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"
cmdProduct.ActiveConnection
> = "DSN=xxxx;UID=xxxx;PWD=xxxx;"
cmdProduct.CommandText =
> "qProduct"
cmdProduct.CommandType = 4
Set prmProduct =
> cmdProduct.CreateParameter("pProductID"
prmProduct.Type =
> adTinyint
prmProduct.Direction = adParamInput
prmProduct.Size =
> Len(ProductID)
prmProduct.Value =
> ProductID
cmdProduct.Parameters.Append prmProduct
Set rsProduct =
> Server.CreateObject("ADODB.Recordset"
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
-
Error 80040e21 (reply)
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"
cmdProduct.ActiveConnection
>
> = "DSN=xxxx;UID=xxxx;PWD=xxxx;"
cmdProduct.CommandText =
>
> "qProduct"
cmdProduct.CommandType = 4
Set prmProduct =
>
> cmdProduct.CreateParameter("pProductID"
prmProduct.Type =
>
> adTinyint
prmProduct.Direction = adParamInput
prmProduct.Size =
>
> Len(ProductID)
prmProduct.Value =
>
> ProductID
cmdProduct.Parameters.Append prmProduct
Set rsProduct =
>
> Server.CreateObject("ADODB.Recordset"
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|