ODBC error when trying to refresh a Visio document.

[MattM1121]

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