Re: OT: Visio / ARS

Wed, 26 Jul 2006 07:37:14 -0700

** In despite of the odbc driver beiing developed for Crystal Reports, you can use it to populate for instance MS Excel, MS Access or SQL Server databases - with limitations.
However, you can not use it to 'reverse engineer' the database as MS Visio 2003 does. See the errors listed underneath.
This is because the ODBC driver does not seem to provide certain details about the columns that Visio uses.
If you set up an ODBC connection to your database (either Oracle or MS SQL) instead of using the AR System ODBC driver you should be fine.

--
Michiel

Reverse engineering from database '<arserver>' on server ''...
Extracting columns of table 'AP-Sample:Company'.
Error! Cannot extract column definition for the table/view 'AP-Sample:Company'.  The definition is not available or you may not have sufficient privileges.  Please check with your database administrator.
Extracting columns of table 'AP-Sample:Lunch Scheduler'.
Error! Cannot extract column definition for the table/view 'AP-Sample:Lunch Scheduler'.  The definition is not available or you may not have sufficient privileges.  Please check with your database administrator.
Extracting columns of table 'AP-Sample:Lunch-Detail'.
Error! Cannot extract column definition for the table/view 'AP-Sample:Lunch-Detail'.  The definition is not available or you may not have sufficient privileges.  Please check with your database administrator.
Visio is checking the reverse engineered model ...
Fixing up the diagram ...
------------------------------------------------
Tables reverse engineered : 3; Time taken (in secs) : 5.41
Check Clauses Reverse Engineered : 0; Time Taken (in secs) : 0.00
Primary Keys reverse engineered : 0; Time taken (in secs) : 0.00
Foreign Keys reverse engineered : 0; Time taken (in secs) : 0.00
Indexes reverse engineered : 0; Time taken (in secs) : 0.00
Triggers reverse engineered : 0; Time taken (in secs): 0.00
Views Reverse Engineered : 0; Time Taken (in secs) : 0.00
Procedures reverse engineered : 0; Time taken (in secs): 0.00
Total elapsed time(in secs): 5.42

On 7/25/06, Lammey, Peter A. <[EMAIL PROTECTED]> wrote:
**
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 __20060125_______________________This posting was submitted with HTML in it___

Reply via email to