-
I want to create a hierarchical recordset but I can't get the MSDataShape provider to work for some reason. I already tried using both MSDataShape and MSDataShape.1 and setting cursor type to client. I always get the message "Data Source not found and default driver not specified." Here is the code:
cnn.CursorLocation = adUseClient
cnn.Provider = "MSDataShape"
stri = "Provider=MSDataShape.1;Data Source=TestDatabase;" & _
"Connect Timeout=15;Data Provider=MSDASQL"
cnn.open stri
-
Which ADO library did you use?
-
You are specifying your provider twice, you only need to specify MSDataShape in the PROVIDER property
more help here: http://msdn.microsoft.com/library/ps...k/mdhi50br.htm
and a data shaping summary in case anyone cares: http://msdn.microsoft.com/library/ps...k/mdhi3mb0.htm
