Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

error 3996 vfp database using ODBCDIrect

 
   Database Help (Home) -> Visual Basic -> ODBC RSS
Next:  query-based update failed because the row to upda..  
Author Message
Utf-8BQWxleGFuZGVy

External


Since: Jan 16, 2004
Posts: 1



(Msg. 1) Posted: Fri Jan 16, 2004 3:36 am
Post subject: error 3996 vfp database using ODBCDIrect
Archived from groups: microsoft>public>vb>database>odbc (more info?)

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.

 >> Stay informed about: error 3996 vfp database using ODBCDIrect 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]