Thanks for your help It seems that one of our files in our \\IBM\UV\SQL directory got corrupt. We restored the whole directory and this sorted out the problem. ________________________________________________________________________ Regards Bjorn Behr Programmer
HYFLO Southern Africa (Pty) Ltd Tel : +27 11 386 5800 Fax : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za ________________________________________________________________________ "In the beginning, the universe was created. This made a lot of people very angry, and has been widely regarded as a bad idea." - Douglas Noel Adams (1952-2002), British author ________________________________________________________________________ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjvrn Behr Sent: 15 June 2004 12:12 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] ODBC Error I just did an UPDATE.ACCOUNT, But it still returns the same error. Thanks anyway Bjorn -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore Sent: 15 June 2004 11:34 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] ODBC Error DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Bjvrn, We had this problem recently on one of our customer's sites. The error message occured each time the first query was executed per connection. This meant that if we reran the query straight away after the error message the query would run fine. I then looked in to why this was happening, but the only change I could find was that the Universe server had been changed and that no one had bothered to do an UPDATE.ACCOUNT in the account that contained the SQL files. I did an UPDATE.ACCOUNT and then reconnected using the UVODBC and the error message no longer appears any more. Could this be the case with your site or have you tried an UPDATE.ACCOUNT? -----Original Message----- From: Bjvrn Behr [mailto:[EMAIL PROTECTED] Sent: 15 June 2004 09:22 To: [EMAIL PROTECTED] Subject: [U2] [UV] ODBC Error UV System: UniVerse 10.0.4 O/S : Windows 2000 Yesterday our ODBC connection to UniVerse worked, when we tried again This morning, it did not. It keeps coming up with this error: Error ID: 23 Severity: ERROR Facility: DBCAPERR - User does not have Permission to execute this SQL statement. (I was connecting on as Administrator at the time) When I looked into our system log, I got this: Event Typt: Information Event Source: SceCli Event Category: None Event ID: 1704 Date: 2004/06/14 Time: 21:51:33 User: N/A Computer: BART Description: Security policy in the Group policy objects are applied successfully. Nobody we know updated any poilcies. Any help would be great. ________________________________________________________________________ Regards Bjorn Behr Programmer HYFLO Southern Africa (Pty) Ltd Tel : +27 11 386 5800 Fax : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za ________________________________________________________________________ "In the beginning, the universe was created. This made a lot of people very angry, and has been widely regarded as a bad idea." - Douglas Noel Adams (1952-2002), British author ________________________________________________________________________ ------- 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/