error 3996 vfp database using ODBCDIrect

This is a discussion on error 3996 vfp database using ODBCDIrect within the ODBC forums in Framework and Interface Programming category; This error message is showns in vb6. This code '/////////////////////////////////////////////////////// ' Create ODBCDirect workspace Set wrk = DBEngine.CreateWorkspac ("ODBCDirect", "Admin", "", dbUseODBC ' Set default cursor driver to dbUseClientBatchCursor wrk.DefaultCursorDriver = dbUseServerCurso ' 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 <= CTO ('11/11/2003'))" qdf.CacheSize = ' Open recordset on QueryDef ' Set rst = ' cnn.OpenRecordset("SELECT * from dayn1 WHERE ind_z in (SELECT ind_z from naznach5 WHERE ...

Go Back   Application Development Forum > Framework and Interface Programming > ODBC

Object Mix

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 01-16-2004, 03:36 AM
=?Utf-8?B?QWxleGFuZGVyIEtpc2VsZXY=?=
Guest
 
Default error 3996 vfp database using ODBCDIrect

This error message is showns in vb6.
This code
'///////////////////////////////////////////////////////

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

' 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 <= CTO
('11/11/2003'))"
qdf.CacheSize =
' Open recordset on QueryDef

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

Set rst = qdf.OpenRecordset(4

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

DSN - Microsoft Visual FoxPRO Drive

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


Reply With Quote
Reply


Thread Tools
Display Modes


All times are GMT -5. The time now is 06:26 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vB Ad Management by =RedTyger=

In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.