Re: [U2] UVODBC Account Activation {unclassified}

2008-06-26 Thread Clifton Oliver
I agree with the advice given in a previous post by Kathleeni and  
this one by Andy.


NEVER try to use UV/ODBC against the standard production account!  
ALWAYS create another account with F pointers that point to the  
product account data sections but have local CLEAN dictionaries. I  
also advocate these local dictionaries use IDEAL flavor D and I type  
descriptors, especially if you want to have any chance of associated  
multivalued fields getting properly handled through dynamic  
normalization.


In defense of the product, Andy's comment is correct, but I wouldn't  
state it as ODBC is very picky. Rather, Pick programmers are  
notorious in loading up the dictionaries with multiple definitions  
(failure to use just ONE A definition and using S for all  
redefinitions) or multiple D definitions etc.


It is not UV/ODBC's fault it can't read everybody's mind and make  
sense out the twenty to thirty year's worth of crap people have  
lazily slopped into the dictionary.


Regards,

Clif

--
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com



On Jun 25, 2008, at 1:11 PM, MACK ANDREW, MR wrote:


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_ASSOC2

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

RE: [U2] UVODBC Account Activation

2008-06-26 Thread Mac Bhyat
This is a brand new uv account - the problem seems to be on a uv file
D_UV_ASSOC and I'm not sure if I can delete that 

Mac

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman
Sent: 25 Jun 2008 16:34
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_ASSOC2
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/


--
This message was scanned for spam and viruses by BitDefender.
For more information please visit http://linux.bitdefender.com/



__ NOD32 3219 (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/


RE: [U2] UVODBC Account Activation

2008-06-26 Thread Anthony Youngman
Just had a thought. Could it be access rights? If, as looks likely, this is 
used by UV to manage schemas, it might be locked down so only the SQL DBA can 
edit it. What's the betting that would cause your problem?

In that case, it's nasty, because it also means any attempt to run 
HS.UPDATE.FILEINFO is likely to fail.

Hmm... you might need to change the F to X to export your tables then change it 
back again so the account actually works...

I'm guessing we might not suffer this because I've never used SQL Schemas in 
UV, and other people may not have met it because they only use SQL Schemas. The 
fact you think you're running a very old version also means it may be (probably 
is) a fixed problem by now...

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman
Sent: 26 June 2008 09:42
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] UVODBC Account Activation

Yes I know it's a UV file. That was point of me mentioning PTERM.FILE - that's 
a UV file too and it was UV files that gave me the most grief.

Does anybody know what UV_ASSOC does? Is it safe to delete the VOC pointer? It 
looks to me like it's part of the SQL table mechanism so if you're not actually 
creating SQL schemas etc it's probably totally unnecessary in this account.

What you could try is changing the F to an X and seeing if anything in the 
account falls over.

Cheers,
Wol

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat
Sent: 26 June 2008 08:56
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UVODBC Account Activation

This is a brand new uv account - the problem seems to be on a uv file
D_UV_ASSOC and I'm not sure if I can delete that

Mac

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman
Sent: 25 Jun 2008 16:34
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_ASSOC2
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

RE: [U2] UVODBC Account Activation

2008-06-25 Thread Anthony Youngman
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_ASSOC2
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/


RE: [U2] UVODBC Account Activation

2008-06-25 Thread Mac Bhyat
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_ASSOC2
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/


RE: [U2] UVODBC Account Activation

2008-06-25 Thread Anthony Youngman
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_ASSOC2
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/


RE: [U2] UVODBC Account Activation {unclassified}

2008-06-25 Thread MACK ANDREW, MR
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_ASSOC2
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