Greetings Folks,
First off great site.
I'm using Powershell to "Walk" a Sharepoint site and pull some metadata about each web site. Such as SiteID, ParentID, etc... What this does is allow me to use the Org Wizard to represent a hierarchy of the web sites.
During the walk I gather permissions and build a single HTML string. All this data then gets put into a SQL Server database. During the Org chart wizard I need to configure an ODBC entry to connect. Once I connect I run through the wizard and it sets up hierarchy real nice like. Then using Data Graphics I can configure each shape to turn a different color based on when the site was last updated. I also have some code that pull the HTML string from the cell property and output to IE.
All very cool.
Now when I try to refresh the data I get an error:
ODBC Error: S1009
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'SPSha' does not exist. Make sure that the name is entered correctly.
The name of the database is "SPSharepoint". For some reason it truncates the name. I tried setting up another data source but it does the same thing.
Anyone know why this is happening?
Thanks,
-Matt