Re: OT: Visio / ARS

Tue, 25 Jul 2006 13:15:39 -0700

**
I dont think so.  I tried it with the ODBC setting checked and with it unchecked and I still got the same result.
I doubt this can work since the ODBC driver was compiled and setup specifically for Crystal Reports.

Thanks
Peter Lammey
ESPN MIT Technical Services & Applications Management
860-766-4761

 

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso
Sent: Tuesday, July 25, 2006 2:27 PM
To: [email protected]
Subject: Re: OT: Visio / ARS

** Is this an issue of setting Use Underscores in the ODBC config area?

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)" <[email protected]>

25/07/2006 12:46 PM

Please respond to
[email protected]
To
 [email protected]
cc
Subject
 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:[email protected]] On Behalf Of Michiel Beijen
Sent: Wednesday, July 19, 2006 5:05 PM
To: [email protected]
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: [email protected]
> > 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: [email protected]
> > 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: [email protected]
> > 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: [email protected] ] On Behalf Of Tyrone Dee
> > Sent: Thursday, July 13, 2006 4:18 PM
> > To: [email protected]
> > 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:[email protected] ] On Behalf Of Herb Partlow
> > Sent: July 13, 2006 2:38 PM
> > To: [email protected]
> > 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: __20060125_______________________This posting was submitted with HTML in it___

Reply via email to