ADOB recordset limit?

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

ADOB recordset limit?

Logged in as: Guest

arrSession:exec spGetSession 2,5,39605

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> Windows PowerShell >> ADOB recordset limit?
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

ADOB recordset limit? - 11/10/2006 8:06:56 AM

ziminski

Posts: 79
Score: 2
Joined: 1/8/2006
Status: offline

I am using
$objConnection = New-Object -comobject ADODB.Connection
$objRecordset = New-Object -comobject ADODB.Recordset

I can connect to the db (oracle) and pull back the record set ,
$objRecordset.MoveFirst()
do {$objRecordset.Fields.Item("terminalipaddress").Value; $objRecordset.MoveNext()} until
($objRecordset.EOF -eq $True)

however the list of ips returned has the 1st 100 correct and the remaining 100 rows as ???????? ( literly as question marks)

Is there a limit to how many rows can be returned from ADOB ?
Is there a parameter I can set?

Rick

Post #: 1

RE: ADOB recordset limit? - 11/13/2006 1:12:50 AM

SAPIENScripter

Posts: 270
Score: 2
Joined: 11/1/2006
From: SAPIEN Technologies
Status: offline

The limits are to prevent anyone from exhausting a database server's resources. You need to use paging. Modify your script to create an ADODB.Command object. I use properties like these:

page size = 100
timeout = 30
size limit=5000

_____________________________

Jeffery Hicks
Windows PowerShell MVP
SAPIEN Technologies - Scripting, Simplified. www.SAPIEN.com

Follow Me: http://www.twitter.com/JeffHicks

(in reply to ziminski)

Post #: 2

RE: ADOB recordset limit? - 11/13/2006 4:18:48 AM

ziminski

Posts: 79
Score: 2
Joined: 1/8/2006
Status: offline

Thanks I'll give it a try. But I also found that if I specified more than one object in my select statement, all values would then be returned. Weird?

Rick

(in reply to SAPIENScripter)