I've opted for number 4 many a time because of speed and degradation to the system utizing a script.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: Thursday, August 26, 2004 5:30 AM To: [EMAIL PROTECTED] Subject: Re: [U2] How import data from UniVerse into MS Access? LeRoi, 1. You need to enable ODBC for your account. To do this, go into the HS.ADMIN account and use the menus to enable ODBC. 2. You then need to enable individual files. The minimum you should do is to create an @SELECT phrase containing all of the columns you wish to return. This will minimise some of the overheads, and filter out the columns that you do not require. NOTE : ODBC seems to work best when used with D and I Descriptor dictionaries. You may get problems running with A and S types. 3. Once you have set up your file lists, use the HS.UPDATE.FILEINFO command. This builds a cache of the column information for all files in the account: the cache is used by the ODBC server to prevent having to scan every dictionay when you connect. In other words, if you change any dictionaries, you must run the HS.UPDATE.FILEINFO again. 4. ODBC is very slow. OleDB is slightly quicker. If you need data in Access, it may be quicker to export and import it, unless you need it real time. Brian On Thu, 26 Aug 2004 17:51:39 +1000 "LeRoi Keiller" <[EMAIL PROTECTED]> wrote: >Is it easy enough to import UniVerse files into MS Access via UVODBC? If so, >how? > >(Currently, I have a UVODBC configuration setup on my PC and it 'test's okay, >but when I access the nominated UniVerse account via an MS Access Import, >nothing shows up in the window (no tables, files, records... nothing). Am I >doing something wrong? Does ODBC need to be configured on the UniVerse >server, as well, for the particular account? UVODBC is certainly installed on >client and server.) > >Thanks, >LeRoi > >LeRoi Keiller >Technical Support > >Ultradata - Vision to Reality >+61 3 9291 1700 >www.ultradata.com.au >------- >u2-users mailing list >[EMAIL PROTECTED] >To unsubscribe please visit http://listserver.u2ug.org/ > >________________________________________________________________________ >This email was checked by MessageLabs SkyScan before entering Microgen. ________________________________________________________________________ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
