connect vfp database using ODBCDirect

  • Thread starter Thread starter Alexander
  • Start date Start date
A

Alexander

Me problem is error message with error number: 3669

It showns then my recordset take more then 100000 records,
when recordset takes records <=100000 then all ok

When i'm using other connections using OLE DB Providers ,
or such as ADODC Control, VB application is currently
stops and trying send error message to microsoft

Please tell me what can I do?
 
Alexander,

This isn't much information. Are you getting the error on fill? Is this a
..NET application?

There is rarely a good reason to retrieve 100,000 records. Maybe you just
need to specify a filter on your SQL statement.
 
This error message is showns in vb6.
This code:
'////////////////////////////////////////////////////////

' Create ODBCDirect workspace.
Set wrk = DBEngine.CreateWorkspace
("ODBCDirect", "Admin", "", dbUseODBC)
' Set default cursor driver to dbUseClientBatchCursor.
wrk.DefaultCursorDriver = dbUseServerCursor


' Create connect string.
strConnect = "ODBC;DSN=333"
' Open connection.
Set cnn = wrk.OpenConnection("", dbDriverNoPrompt,
False, strConnect)
' Open recordset on connection.

Set qdf = cnn.CreateQueryDef("", "SELECT * from dayn1
WHERE ind_z in (SELECT ind_z from naznach5 WHERE
day_1>=CTOD('08/08/2003') AND day_1 <= CTOD
('11/11/2003'))")
qdf.CacheSize = 1
' Open recordset on QueryDef.

' Set rst = _
' cnn.OpenRecordset("SELECT * from dayn1 WHERE ind_z
in (SELECT ind_z from naznach5 WHERE day_1>=CTOD
('08/08/2003') AND day_1 <= CTOD('11/11/2003'))",
dbOpenDynamic, 0, dbOptimistic)

Set rst = qdf.OpenRecordset(4)

'////////////////////////////////////////////////////////

DSN - Microsoft Visual FoxPRO Driver


When i'm trying connect the same database using vb.net
and OLEDB for ODBC driver or the same DSN, on fill event
application is closing and trying to send error message
to microsoft (Windows XP). But then recordset some
smaller then 100,000 records, ado.net takes records very
long.
 
Back
Top