Clipboard
Aug 1, 2001Does anyone know or have a stored procedure that puts data in the clipboard?
View 3 Replies
ADVERTISEMENT
Diagram To Clipboard
Oct 24, 2007Does anyone know how to automate the copying of a sql server 2005 database diagram to the clipboard so that this could for instance be accomplished from a word template. Does SQL Server 2005 expose an interface so that you can do this?
I am trying to automate the copying of a database diagram into a word doc - can be done manually by right clicking on the diagram and sending to clipboard, pasting it into the doc. The clipboard is easily accessed from within word.
Clipboard Error Creating Aggregations Via DSO
May 20, 2008We are trying to compile a difinitive procedure for our customers moving from SSAS 2000 (where we use DSO) to 2005 (where we use AMO). However, we are running into problems getting even the 2000 environment set up according to the specs.
The requirement is a domain environment where the web server and the DB server are 2 different machines. We are replicating this environment locally using 3 Virtual Machines in VMWare Player. All have Windows Server 2003 Enterprise with SP2 installed. One is our domain controller, one is the DB server (SQL Server 2000 and SSAS 2000 SP4 with the hotfix rollup installed) where almost none of our application components are installed, one is the web server with IIS and our ASP.NET application and COM components, which bundles DSO and dependencies, but no database client tools installed. We set up ASP.NET to run as a domain user, a member of Administrators group on the domain and both server machines, and also OLAP Admins on the DB server (we can limit access later once everything works).
I can successfully create the database, cube, dimensions, and partitions from the ASP.NET code calligng COM components written in VB6 which use DSO. However, creating aggregations results in a clipboard error. Here is the code:
1380
Set dsoPartition = m_dsoServer.MDStores(mvarDBName).MDStores(cubeName).MDStores(1)
dsoPartition.OlapMode = olapmodeMolapIndex
1385
' get the partition analyzer
Dim dsoPartitionAnalyzer As DSO.PartitionAnalyzer
Set dsoPartitionAnalyzer = dsoPartition.Analyzer
' initialize the analyzer
dsoPartitionAnalyzer.InitializeDesign
1390
There is more, but the error occurs on one of the three statements between 1385 and 1390
The error is: "Can't open Clipboard" number 521 Source "DSO"
Creating the aggregations via the Storage Design wizard on the DB server directly seems to succeed.
Can somebody help with this?
Thanks,
Boris Zakharin, MCAD