p2p.wrox.com: Archives - asp

asp_databases thread: Microsoft JET Database Engine error '80040e29'

Message #1 by "Ralph Porter" <RalphPorter@1...> on Wed, 13 Dec 2000 16:19:07 -0000

I am issuing a Find command on and access table connected via ADODB, and I

get the message 'The rowset cannot scroll backwards', I don't understand,

can anyone help me please, the statements look like this:



UserRecord.Open "Users", strConn, adOpenDynamic,,adCmdTable 

UserRecord.Find ("UserName = 'Admin'") 



Thank you.



         Ralph.



--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Message #2 by pdf@b... on Wed, 13 Dec 2000 13:52:42 -0500


Do you first need to move to the first record?



UserRecord.MoveFirst



I'm fairly new to ASP and database connectivity, so this is just a guess.  :)

-Pete











"Ralph Porter" <RalphPorter@1...> on 12/13/2000 11:19:07 AM



Please respond to "ASP Databases" <asp_databases@p...>



To:   "ASP Databases" <asp_databases@p...>

cc:    (bcc: Peter Foti)



Subject:  [asp_databases] Microsoft JET Database Engine error '80040e29'







I am issuing a Find command on and access table connected via ADODB, and I

get the message 'The rowset cannot scroll backwards', I don't understand,

can anyone help me please, the statements look like this:



UserRecord.Open "Users", strConn, adOpenDynamic,,adCmdTable

UserRecord.Find ("UserName = 'Admin'")



Thank you.



         Ralph.





--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Message #3 by Imar Spaanjaars <Imar@S...> on Wed, 13 Dec 2000 20:57:39 +0100

This is very weird. The syntax is correct. I tried a variation of your code 

on a sample Access database. No problem at all.

Can you post some more code, like the way you create and open the 

connection for example. What ADO version are you using?



BTW, if all else fails: Open the recordset with an SQL statement instead of 

the Find method. As an extra benefit, this will perform faster.



Dim sSQL

sSQL = "SELECT UserName, anOtherField FROM Users WHERE UserName = 'Admin'"

UserRecord.Open sSQL, strConn, adOpenDynamic,,adCmdTable



or use the Filter property of the recordset





HtH



Imar





At 01:52 PM 12/13/2000 -0500, you wrote:



>Do you first need to move to the first record?

>

>UserRecord.MoveFirst

>

>I'm fairly new to ASP and database connectivity, so this is just a guess.  :)

>-Pete

>

>

>

>

>

>"Ralph Porter" <RalphPorter@1...> on 12/13/2000 11:19:07 AM

>

>Please respond to "ASP Databases" <asp_databases@p...>

>

>To:   "ASP Databases" <asp_databases@p...>

>cc:    (bcc: Peter Foti)

>

>Subject:  [asp_databases] Microsoft JET Database Engine error '80040e29'

>

>

>

>I am issuing a Find command on and access table connected via ADODB, and I

>get the message 'The rowset cannot scroll backwards', I don't understand,

>can anyone help me please, the statements look like this:

>

>UserRecord.Open "Users", strConn, adOpenDynamic,,adCmdTable

>UserRecord.Find ("UserName = 'Admin'")

>

>Thank you.

>

>          Ralph.

>





--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Message #4 by "Ralph Porter" <RalphPorter@1...> on Thu, 14 Dec 2000 09:28:43 -0000

Hi,



I have a problem with the following code that I just can't figure out, the

error I am getting is 'The rowset cannot scroll backwards'. I don't

understand why a find would result in this error even if the recordset

couldn't scroll backwards? this is an ADODB connection to an access 97

Database, any ideas would be very welcome. The code:



Set UserRecord = Server.CreateObject("ADODB.Recordset")



UserRecord.Open "Users", strConn, adOpenStatic, ,adCmdTable 



StrUser = Request.Form("UserName") 



FindStr = "UserName = '" & StrUser & "'"



UserRecord.Find FindStr 



Thank you very much.



Ralph.



---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Message #5 by "Ken Schaefer" <ken@a...> on Fri, 15 Dec 2000 11:18:02 +1100

Why don't you do it this way:



<%

strUser = Replace(Request.Form("UserName"), "'", "''")



strSQL = "SELECT * "

strSQL = strSQL & "FROM Users "

strSQL = strSQL & "WHERE UserName = '" & strUser & "'"



objRS.Open strSQL, strConn, adOpenForwardOnly, adLockReadOnly, adCmdText

%>





I guarentee that it will be faster since you're only returning the one

record you require, rather than the entire table, and then searching within

the table.



Cheers

Ken



----- Original Message -----

From: "Ralph Porter" <RalphPorter@1...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, December 14, 2000 8:28 PM

Subject: [asp_databases] Microsoft JET Database Engine error '80040e29'





> Hi,

>

> I have a problem with the following code that I just can't figure out, the

> error I am getting is 'The rowset cannot scroll backwards'. I don't

> understand why a find would result in this error even if the recordset

> couldn't scroll backwards? this is an ADODB connection to an access 97

> Database, any ideas would be very welcome. The code:

>

> Set UserRecord = Server.CreateObject("ADODB.Recordset")

>

> UserRecord.Open "Users", strConn, adOpenStatic, ,adCmdTable

>

> StrUser = Request.Form("UserName")

>

> FindStr = "UserName = '" & StrUser & "'"

>

> UserRecord.Find FindStr

>

> Thank you very much.

>

> Ralph.

>

> ---

> FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

> IN YOUR INBOX!

> Get the latest and best HTML, XML, and JavaScript tips, tools, and

> developments from the experts.  Sign up for one or more of EarthWeb's

> FREE IT newsletters at http://www.earthweb.com today!




leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

>





---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Message #6 by "Colin Gourlay" <colin.gourlay@c...> on Sat, 16 Dec 2000 15:04:23 -0000

I suggest changing the constant ==> adOpenStatic to adOpenDynamic



Perhaps this may help?



Regards



Colin Gourlay

CG Systems



http://www.cgsystems.org.uk





-----Original Message-----

From: Ralph Porter [mailto:RalphPorter@1...]

Sent: 14 December 2000 09:29

To: ASP Databases

Subject: [asp_databases] Microsoft JET Database Engine error '80040e29'



Hi,



I have a problem with the following code that I just can't figure out, the

error I am getting is 'The rowset cannot scroll backwards'. I don't

understand why a find would result in this error even if the recordset

couldn't scroll backwards? this is an ADODB connection to an access 97

Database, any ideas would be very welcome. The code:



Set UserRecord = Server.CreateObject("ADODB.Recordset")



UserRecord.Open "Users", strConn, adOpenStatic, ,adCmdTable



StrUser = Request.Form("UserName")



FindStr = "UserName = '" & StrUser & "'"



UserRecord.Find FindStr



Thank you very much.



Ralph.





--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Message #7 by "Ken Schaefer" <ken@a...> on Mon, 18 Dec 2000 11:42:32 +1100

The Jet Provider only supports adOpenKeyset and adOpenForwardOnly

cursors...adOpenStatic and adOpenDynamic are not supported.



Cheers

Ken



----- Original Message -----

From: "Colin Gourlay" <colin.gourlay@c...>

To: "ASP Databases" <asp_databases@p...>

Sent: Sunday, December 17, 2000 2:04 AM

Subject: [asp_databases] RE: Microsoft JET Database Engine error '80040e29'





> I suggest changing the constant ==> adOpenStatic to adOpenDynamic

>

> Perhaps this may help?

>

> Regards

>

> Colin Gourlay

> CG Systems

>

> http://www.cgsystems.org.uk

>







---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Message #8 by Arun Venkatesh Kumar <arun_vk@t...> on Mon, 18 Dec 2000 10:22:42 +0530

hope this MSDN document may help you



****************************************************************************

****

****************************************************************************

****

****************************************************************************

****

FIX: Sybase Cursor Can't Scroll Back in a DataForm-Wizard Form

ID: Q168271 



----------------------------------------------------------------------------

----

The information in this article applies to:

Microsoft Visual InterDev, version 1.0

----------------------------------------------------------------------------

----



SYMPTOMS

The following error occurs when attempting to scroll backward on a DataForm

Wizard-generated form that is connected to a Sybase table: 



"Microsoft OLE DB Provider for ODBC Drivers error '80040e29' The rowset

cannot scroll backward" 



STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at

the beginning of this article. This bug has been corrected in Visual Studio

97 Service Pack 1. 



For additional information about the Visual Studio 97 Service Pack 1, please

see the following article in the Microsoft Knowledge Base: 



Q170365 INFO: Visual Studio 97 Service Packs - What, Where, and Why 



MORE INFORMATION

Steps to Reproduce Behavior

Insert a connection to a Sybase database into a web project. 



Run the Data Form Wizard and choose a table from the Sybase connection. 



Preview the xxxFORM.ASP. 





Additional query words: 



Keywords : kb3rdparty kberrmsg kbADO kbVisID100 kbVisID600fix kbVS97sp1fix

kbVS97sp2fix kbGrpASP 

Version : WINDOWS:1.0 

Platform : WINDOWS 

Issue type : kbbug 

****************************************************************************

****

****************************************************************************

****

****************************************************************************

****



regards,



arun



-----Original Message-----

From: Colin Gourlay [mailto:colin.gourlay@c...]

Sent: Saturday, December 16, 2000 8:34 PM

To: ASP Databases

Subject: [asp_databases] RE: Microsoft JET Database Engine error

'80040e29'





I suggest changing the constant ==> adOpenStatic to adOpenDynamic



Perhaps this may help?



Regards



Colin Gourlay

CG Systems



http://www.cgsystems.org.uk





-----Original Message-----

From: Ralph Porter [mailto:RalphPorter@1...]

Sent: 14 December 2000 09:29

To: ASP Databases

Subject: [asp_databases] Microsoft JET Database Engine error '80040e29'



Hi,



I have a problem with the following code that I just can't figure out, the

error I am getting is 'The rowset cannot scroll backwards'. I don't

understand why a find would result in this error even if the recordset

couldn't scroll backwards? this is an ADODB connection to an access 97

Database, any ideas would be very welcome. The code:



Set UserRecord = Server.CreateObject("ADODB.Recordset")



UserRecord.Open "Users", strConn, adOpenStatic, ,adCmdTable



StrUser = Request.Form("UserName")



FindStr = "UserName = '" & StrUser & "'"



UserRecord.Find FindStr



Thank you very much.



Ralph.







--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Return to Index

P2P Archives