When I try to do this against any ARSystem table, I get the error invalid column name. I am using Visio 2003 against ARS 6.3 patch 17 on SQL server 2000. Has anyone seen this and if so, how did you fix it.
Thanks for any responses. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michiel Beijen Sent: Wednesday, July 19, 2006 5:05 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Visio / ARS Susan, There are different editions for Visio. You will need Professional edition, it is not featured in Standard edition. See http://www.microsoft.com/office/visio/prodinfo/editions.mspx They call the feature "Database diagrams with reverse engineering of any ODBC compliant data source" Kind regards, Michiel On 7/18/06, Susan Palmer <[EMAIL PROTECTED]> wrote: > ** I never did get a Database menu and it did not bring any information into > the visio file. So I was not successful in V2003. > > > On 7/18/06, Susan Bentley <[EMAIL PROTECTED]> wrote: > > > > ** > > > > > > > > Is this possible in Visio 2002? Don't seem to have the same options for > linking to database. > > > > > > > > > > Susan Bentley > > Service Management Analyst > > ICT Services > > Corporate Resources Directorate > > West G > > East Sussex County Council > > P.O. Box 3 > > County Hall > > St. Anne's Crescent > > Lewes BN7 1SF > > Tel: (01273) 481610 > > Fax: (01273) 481978 > > Email: [EMAIL PROTECTED] > > > > Come and visit us at the ICT Services Roadshow, coming to an office near > you, throughout July/August 2006! > > Find out more on the ICT Services Intranet pages or contact the Corporate > Servicedesk. > > > > > > "We are committed to providing a professional and quality service. We > welcome feedback so please let us know when we have done well and when and > how we could improve our service. Thank you." > > > > Please do not print this email unless necessary. > > > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] On Behalf Of Susan Palmer > > Sent: 17 July 2006 18:42 > > To: arslist@ARSLIST.ORG > > Subject: Re: OT: Visio / ARS > > > > > > > > > > ** > > > > > > Found it under Tools / Add-Ons / Link to Database and a wizard appears. > You log in via the odbc connection and select a table. > > > > > > > > > > > > I haven't gotten any output so apparently I'm not doing something right > from that point but will keep working at it. > > > > > > > > > > > > Susan > > > > > > > > > > On 7/17/06, Susan Palmer < [EMAIL PROTECTED]> wrote: > > > > > > > > Hi Roger, > > > > > > > > > > > > I'm looking for that template. I have Visio 2003 and even went to the > website but do not find anything referring to Database Model, alot of > Network Diagrams. It's not in my full install of Visio either. Any hints > as to where to find it? > > > > > > > > > > > > Thanks, > > > > > > > > Susan > > > > > > > > > > > > On 7/16/06, Roger Medsker < [EMAIL PROTECTED]> wrote: > > > > > > > > Visio will allow you to reverse engineer a database. It seems to me you > > could do this with Visio 2002 but I no longer have that version so can't > > verify. Visio 2003 will do it. As Herb said create a new drawing using the > > Database Model Diagram template. That adds a "Database" menu. Choose > > Database -> Reverse Engineer. This starts a wizard that will allow you to > > connect to any ODBC compliant database and Visio will create database > > entities for each table you choose. > > > > Roger Medsker > > Bluestem Consulting Group LLC > > Office: 319-354-0413 Mobile: 319-400-2828 > > [EMAIL PROTECTED] > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto: [EMAIL PROTECTED] On Behalf Of Tyrone Dee > > Sent: Friday, July 14, 2006 7:38 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: OT: Visio / ARS > > > > Herb - does it still do this? If so what version do I need, etc.. > > > > Thanks. > > > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Herb Partlow > > Sent: July 13, 2006 7:26 PM > > To: arslist@ARSLIST.ORG > > Subject: Re: OT: Visio / ARS > > > > It can. I used it on several occasion. After creating the drawing I sent > the > > drawing to my wife and she changed the setting of the drawing and ran it > off > > on her plotter. I had a nice wall size drawing I used to show staff and > > other developers where we were at. > > > > Herb > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto: arslist@ARSLIST.ORG ] On Behalf Of Tyrone Dee > > Sent: Thursday, July 13, 2006 4:18 PM > > To: arslist@ARSLIST.ORG > > Subject: Re: OT: Visio / ARS > > > > I was certain that Visio could document your workflow on it's own. > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:arslist@ARSLIST.ORG ] On Behalf Of Herb Partlow > > Sent: July 13, 2006 2:38 PM > > To: arslist@ARSLIST.ORG > > Subject: Re: OT: Visio / ARS > > > > You can use Visio to document/draw relationships diagram. > > Open visio > > Choose Database Template > > Choose database model diagram > > > > And then experiment with what works best for you > > > > Herb > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto: [EMAIL PROTECTED] On Behalf Of Bill Estep > > Sent: Thursday, July 13, 2006 11:22 AM > > To: arslist@ARSLIST.ORG > > Subject: Re: OT: Visio / ARS > > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > Howdy, > > > > The IT Masters Suite did this, but it was absorbed by Remedy and > > discontinued. Some folks have said it became part of the developers > suite, > > but that is a product I am not familiar with. > > > > I don't know of anything that will do this today. > > > > Bill Estep > > http://www.clubreading.com > > > > On Jul 13, 2006, at 9:24 AM, T. Dee wrote: > > > > > A long time ago in a galaxy far far away ... Visio use to draw a > > > diagram / flow chart from integrating with ARS. > > > > > > Does anyone remember this? > > > > > > Can this still be done? If so what version of Visio will this work > > > with? > > > > > > THANKS! > > > > > > > ______________________________________________________________________ > > > > > _________ > > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > > > > -----BEGIN PGP SIGNATURE----- > > Version: GnuPG v1.4.3 (Darwin) > > > > > iD8DBQFEto9FgPRYzF5ewtERAjnCAJsFhYJ/j2KNzcZCMiKNUVOZDUJouACgrymJ > > vs6MURBX0zUydJ3L9383gfc= > > =/UNd > > -----END PGP SIGNATURE----- > > > > > ________________________________________________________________________ > > _______ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > > ________________________________________________________________________ > > ____ > > ___ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > > ________________________________________________________________________ > > _______ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > > ____________________________________________________________________________ > > ___ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > > ____________________________________________________________________________ > > ___ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > > _____________________________________________________________________________ __ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > > > > > > > > > > > __20060125_______________________This posting was > submitted with HTML in it___ > > > > > > > > > > This message is intended for the use of the addressee only and may contain > confidential or privileged information. If you have received it in error > please notify the sender and destroy it. You may not use it or copy it to > anyone else. > > > > E-mail is not a secure communications medium. Please be aware of this when > replying. > > > > Although East Sussex County Council has taken steps to ensure that this > e-mail and any attachments are virus free, we can take no responsibility if > a virus is actually present and you are advised to ensure that the > appropriate checks are made. > > > > You can visit our website at http://www.eastsussex.gov.uk > > __20060125_______________________This posting was > submitted with HTML in it___ > > __20060125_______________________This posting was submitted > with HTML in it___ _____________________________________________________________________________ __ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org