On 7/25/06, Mathieu Pitre <[EMAIL PROTECTED]> wrote:
Yes I have the same problem: "invalid column name". What Can I do now? I am selecting the proper ARS ODBC driver but it does not seem to work properly.
Any suggestion?
Mathieu Pitre
IT Business Systems Analyst
Production Operation
Computer Sciences Corporation
Pratt & Whitney Canada, Plant 1
Sametime: Mathieu Pitre
office: 450-647-8008 x7030
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Ed White <[EMAIL PROTECTED] >
Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG>25/07/2006 12:46 PM
arslist@ARSLIST.ORG
arslist@ARSLIST.ORG Re: OT: Visio / ARS
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:arslist@ARSLIST.ORG] 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:
> arslist@ARSLIST.ORG] 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: arslist@ARSLIST.ORG] 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:arslist@ARSLIST.ORG] 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: arslist@ARSLIST.ORG] 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
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___
