Did you run HS.UPDATE.FILEINFO? Have you put the correct SQL type definitions in fields 8?
Did HS.UPDATE.FILEINFO actually work correctly! THAT'S A BIGGIE! I've shoved a little article on pickwiki you might want to look at - multivaluedatabases>universe>odbcaccess Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: 17 February 2004 01:11 To: U2 Users Discussion List Subject: Re: Enabling ODBC for non-SQL file Thanks, I went through the options on the HS.ADMIN menu, including HS.SCRUB and the HS_FILE_ACCESS file was created. For some reason it excluded the file I need from HS_FILE_ACCESS though, even though I added an @SELECT dictionary item. If I run CONVERT.SQL against the file (not using my live data file), I can then see it via ODBC in Excel, but the dict items don't work correctly. Is it safe to manually add a record for the non-SQL file to HS_FILE_ACCESS? Thanks, John Jeff Schasny wrote: > First create an @SELECT item in the dictionarys of the files you are aiming > at. > > Then logto HS.ADMIN and issue the HS.ADMIN command from TCL. Select Option > #3 to activate access to files in an account. Whenever you change an @SELECT > Item or want to add access to another file you can run HS.UPDATE.FILEINFO in > the account rather than going back to the HS.ADMIN account and running > option #4 (Update File Information Cache in an account). > > -----Original Message----- > From: John Hester [mailto:[EMAIL PROTECTED] > Sent: Monday, February 16, 2004 3:34 PM > To: U2 Users Discussion List > Subject: UV: Enabling ODBC for non-SQL file > > > I'm trying to enable ODBC access to a standard UV non-SQL file and have > found the following in the ODBC manual: > > "To make UniVerse files accessible to ODBC applications, you must run > the ODBC file access utility in the account." > > However, they don't bother to say what this ODBC file access utility is > called. I've tried listing the VOC LIKE ...HS... and ...MENU... but > can't find anything relevant. Are they referring to HS.UPDATE.FILEINFO? > > TIA, > John > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *********************************************************************************** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *********************************************************************************** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
