Some providers don t support all cursor types.
Check the documentation for the provider. If you don't specify a cursor type, ADO opens a forward-only cursor by default. ADO still creates a Connection object, but it doesn't assign that object to an object variable. If you do not use this object variable when opening your Recordset objects, ADO creates a new Connection object for each new Recordset , even if you pass the same connection string. You can create as many Recordset objects as needed.