Congrats Connie!
And thanks for now placing a working solution into the 3000-L Archives for any of us who need it later!
Good Job!
Art "Always like learning a new idea!" Bahrs
Art Bahrs, CISSP
Security Engineer (Oregon Region)
(503) 216-2722
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Connie Sellitto
Sent: Wednesday, March 16, 2011 6:56 AM
To: [log in to unmask]
Subject: Wireframe diagram/ODBC connection used in Visio - success
Hello List,
First, thanks to all who posted on this topic, and all the suggestions.
Using Minisoft's ODBC driver, I was first able to connect to my
database using MS Query, so I knew the ODBC part was set up correctly.
However, Visio2010 did not recognize the names of the datasets nor
data items. Apparently, this is due to its use of unicode, rather
than the ASCII names on the HP3000. Minisoft support was most
helpful; they indicated they working on a version of ODBC that will
wort with Visio2010, and suggested trying an older version of Visio,
which the migration company supplied.
Downloaded a copy of Visio2003, connected with the ODBC HP3000
driver, Voila! Worked like a charm! Checking the 'Load Automatic
Masters' box in the ODBC setup allowed Visio to draw the relationship
lines. Some tweaking was needed in Visio, to properly identify the
primary indexes, but data item names and definitions came across
accurately.
Again, thank you for the support and advice. The results are exactly
what I needed, and I believe this will help others who may find
themselves in a similar position, of having to provide a diagram of
an Image DB.
Best regards,
Connie Sellitto
Programmer/Analyst
Cat Fanciers' Association, Inc.
732-528-9797 ext 18
Email: [log in to unmask]
İş°¨¨°şİİş°¨¨°şİİş°¨¨°şİİş°¨¨°şİİş°¨¨°şİİş°¨¨°şİ
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
