Wow, you're good. I did a CNAME to change the file name to HS_FILE_ACCESS.OLD and then ran option 3 from the HS.ADMIN menu - this time it created the file and added the new entry, without issue. So thanks. :o)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of u2ug Sent: Monday, 30 August 2004 16:07 To: [EMAIL PROTECTED] Subject: Re: [U2] How import data from UniVerse into MS Access? Importance: Low sounds like the file already exists at the os level in that account - try deleting it 1st. ----- Original Message ----- From: "LeRoi Keiller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 29, 2004 11:31 pm Subject: RE: [U2] How import data from UniVerse into MS Access? > 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/ ------- 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/
