I have a remote database (MySQL) connection, and would like to load a local recordset asynchronously using the adAsyncFetch modifier. However, when I run it, ADO does not fetch it asynchronously. Am I missing something?
cnAsync is an asynchronous connection
rs.CursorLocation = adUseClient
rs.CursorType = adOpenStatic
rs.LockType = adLockBatchOptimistic
rs.Properties("Initial fetch size") = 1
rs.Properties("Background fetch size") = 100
rs.Open strSQL, cnAsync, , , adAsyncFetch
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!