Re: OT: Visio / ARS

[Ed White]

** Thank you, I tried with the SQL ODBC driver and got it to work.   From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michiel Beijen Sent: Wednesday, July 26, 2006 10:35 AM To: arslist@ARSLIST.ORG Subject: Re: OT: Visio / ARS   ** 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     mitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___