Saving Visio shapes to file/db (Visio 2000)
Thanks for the Advice Al, although this does not solve my
problem. This example is fine for retrieving associated
shape information from a db, but doesn't help me in my
quest to save the 'physical' shape to the database. I
need to know how to either create a s{*filter*}file (without
dragging/dropping the shape object) of the shape or to
somehow stream the binary image of the shape to the DB.
Cheers,
Tommy
Quote:
>-----Original Message-----
>I'd suggest to look at two pieces of demo code that are
>out on the download system. The first is the
netconfigdemo
>that shows how to tie visio into excel, word, and
>powerpoint. This gets the basics on selecting what you
>want to grab. The second would be their facilities
>management demo. That has the code (and embedded forms)
>for doing database updates, although it isn't SQL
>specific. Most of my database access stuff is external
not
>using VBA, although there are some ADO(X) developer kits
>out there that give some real help in understanding how
to
>go against databases. Right now I'm using ADO.NET and
>wouldn't recommend it to anybody using a standalone
system.
>Hope this helps,
>Al
>>-----Original Message-----
>>great for drawings....but what about shapes?
>>thanks.
>>>-----Original Message-----
>>>i just opened a drawing (visio2002)
>>>select tools => export to database
>>>select localserver (sql2000 is on workstation)
>>>select create
>>>logon on to server
>>>select database
>>>select table name
>>>select ok (got error message about size)
>>>select ok again and it saved the drawing into the table
>>>Al
>>>>-----Original Message-----
>>>>Does anyone know how to save a shape to a SQL Server
db
>>>>(or to a file from which i can stream to the
database)?
>>>>I've tried all sorts of export functions, but these
>>only
>>>>export shapes to an image file which cannot be re-
>>>>imported to a visio drawing in its original form.
>>>>Is is possible to persist visio objects in VB
>>persistable
>>>>classes in a property bag?
>>>>Much thanks!
>>>>Tommy.
>>>>.
>>>.
>>.
>.
