I've been trying HS.ADMIN to enable ODBC access, but I get the following error:
Creating file "HS_FILE_ACCESS" as Type 30. mkdbfile: cannot create file HS_FILE_ACCESS I've checked permissions and (unless I'm blind) they seem okay. Any thoughts? (I'm wondering if the file type has something to do with it.) Thanks, LeRoi PS The complete task is shown below: UniVerse Server Administration 1. List activated accounts 2. Show UniVerse ODBC Config configuration for an account 3. Activate access to files in an account 4. Deactivate access to files in an account 5. Run HS.SCRUB on a File/Table 6. Update File Information Cache in an account Which would you like? ( 1 - 6 ) ?3 Enter the account name or path, or press Return for a list of accounts in which file access has already been activated: /home/clisupp/lsk/uv Activating access to files in account /home/clisupp/lsk/uv Creating data portion of HS_FILE_ACCESS file. Creating file "HS_FILE_ACCESS" as Type 30. mkdbfile: cannot create file HS_FILE_ACCESS Unable to create operating system file "HS_FILE_ACCESS". *** Processing cannot continue. *** ********* WARNING ********** Could not create data portion of HS_FILE_ACCESS file. Activation failed. Press any key to return to the menu... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: Thursday, 26 August 2004 19:30 To: [EMAIL PROTECTED] Subject: Re: [U2] How import data from UniVerse into MS Access? Importance: Low 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/
