Hi, A clean account is almost necessary. ODBC is very picky and we found that our data was OK but that the dictionaries were full of 10 years worth of "difficulties" :)
It was easier to create a new account, populate the VOC with file pointers to the data files but create the dictionary locally. Then we could put only the data items we wanted to expose into the dictionary. This allowed us to format data differently from what the users needed to see and ensure that clean dictionaries were presented. Andy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Thursday, 26 June 2008 2:34 a.m. To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Okay. Firstly, do you need this file in your account? Oddly enough, most of my "hard to fix" problems with ODBC have been caused by the various preparation/export programs crashing on system files we've never touched. If you don't need it, delete the VOC entry. I had it crash on PTERM.FILE - a system-supplied multi-part file. Secondly, go to pickwiki, find the page on Universe, and then look at the page on ODBC. You might find it useful as it describes my tribulations with 9.6. Bear in mind that these export routines process EVERYTHING, so the entire account needs to be nice and clean, not just the files you're exporting :-( Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 14:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVODBC Account Activation Hi, I know it's a very old version of uv - maybye 9.5 or possibly even 9.4 Mac -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 25 Jun 2008 12:41 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Not that I know much about this error but ... What version of UV are you running? I've set up ODBC on both 9.6 and 10.2, and the later version seems to be a lot more robust ... Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 10:59 To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/D_UV_ASSOC 2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za <http://www.unibase.co.za/> Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to <http://www.unibase.co.za/> www.unibase.co.za -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ __________ NOD32 3216 (20080625) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com -- This message was scanned for spam and viruses by BitDefender. For more information please visit http://linux.bitdefender.com/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/