News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

ODBC error when trying to refresh a Visio document.

Started by MattM1121, February 22, 2012, 07:38:55 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 131 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1049KB.
Tokens: post-login.
Cache hits: 14: 0.00295s for 26,764 bytes (show)
Cache misses: 3: (show)
Queries used: 17.

[Show Queries]