VB Forum / Database Access / September 2005

If I am querying a SQLServer database I normally use a connection string
based on the following:

Provider=SQLOLEDB;Password=****;Persist Security Info=True;User ID=**;Data
Source=*******;Initial Catalog=*****

However, if I want to bring back hierarchical data (shaped record sets), I
have to use the following connection string:

Provider=MSDataShape;Data Provider=SQLOLEDB;Persist Security
Info=True;Initial Catalog=****;Password=****;User ID=****;Data Source*****

Now, my question is this:

Is there a performance overhead in always using the second connection string
(the one that allows shaping)?

If not, then a) one might as well forget the first method and b) implore
Microsoft to change Query Analyzer to use the hierarchical one (and of
course change the display to handle hierarchical data).