| VB6 OraOLEDB problems with fetch [message #100614] |
Thu, 06 March 2003 09:37 |
Beat Jörg
Messages: 1
Registered: March 2003
|
Junior Member |
|
|
I have a problem with fetching data via OraOLEDB
I use this code in VB6:
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "Provider=OraOLEDB.Oracle;Data Source=XXX;User Id=XXX;Password=XXX;"
Set rst = New Recordset
rst.Open "select ID, COUNTRY_DE from COUNTRIES Order by COUNTRY_DE", db, , , adCmdText
rst.MoveFirst
While Not rst.EOF
debug.print rst!Country_De
rst.MoveNext
Wend
Only the first 100 items are printed correctly, then only strings with ??? are printed.
If I set the FetchSize to 20 only 20 items are fetched correctly. Generally, the number of the FetchSize determine the records that are fetched correctly.
I seems, that only the first fetch success.
Can anyone help me?
Greetings from Switzerland
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
