Using CONNX with Microsoft Visual Basic
Microsoft Visual Basic has two methods of retrieving data: dynasets and snapshots.
When creating read/only queries, use snapshots instead of dynasets.
Take advantage of RDO (Remote Data Objects) available in Visual Basic 4 and Visual Basic 5.
Remote Data Objects bypass the snapshot versus dynaset issues by sending SQL directly to the CONNX ODBC driver, without any Jet Engine processing. This results in optimum performance for Visual Basic applications that need to communicate with ODBC databases.
If using Visual Basic 4 or 5 with DAO, create the registry entry:
\Hkey_Local_Machine\Software\Microsoft\Jet\3.5\Engines\ODBC
In this key, add the numeric DWORD value QUERYTIMEOUT=0.
Create the registry entry:
\Hkey_Local_Machine\Software\Microsoft\\Jet\3.5\Engines\ODBC
In this key, add the numeric DWORD value TRYJETAUTH=0.