MSDataShape provider problem

[jwatson]

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

[judy]

Which ADO library did you use?

[Clunietp]

You are specifying your provider twice, you only need to specify MSDataShape in the PROVIDER property

more help here: http://msdn.microsoft.com/library/psdk/dasdk/mdhi50br.htm

and a data shaping summary in case anyone cares: http://msdn.microsoft.com/library/psdk/dasdk/mdhi3mb0.htm