Al Edlund... How do I declare the ADODB

[Chuck]

Hi Al

Following the ealier post... I have tried the code sample your suggested -
but have trouble with the ADODB - how do I define this - or what kind of
reference do I need to set to make it work?

I also get an error when I try to get the database path - the statement

visPage.PageSheet.Cells("prop.database_file.value").ResultStr("")

fails.

Chuck

 

[Al Edlund]

the adodb references ado 2.7 and ado 2.7 extensions and security (these are
the drivers for access to the database). You have to tell a database call
roughly three basics: the name of the database (in this case is stored in a
custom property in the document), the name of the index that has all of the
unique identifiers of the shapes you want to track, and the id of the shape
you want to track. Finally this routine uses one other piece of information,
the value of the field you want to update in the record.
there is a great example of database writing on msdn that is labeled
something like "dao to ado conversion".
al

 

[Chuck]

Thanks Al - got the references right now. But I still have trouble
retrieving the database path from my visio-document. Somehow it can't use
the string "prop.database_file.value" - it fails with "Unexpected end of
file". Any ideas..?

I guess I can just write the path to the database myself - but I am not sure
about the format.

Chuck

 

[Al Edlund]

The reason you can't find it is that it is in a custom property named
"prop.database_file" on the first page in my document. the format is nothing
more than the file name (Infrastructure Component Database.mdb) of the
database. Since it is in the same directory as the document it doesn't need
a path appended to it. For a simple example of database interaction and
visio you can look in MSDN under visio 2000 articles for netconfigdemo.
Al