Re: [U2] [UV] ODBC Error
Also check the database privilege of the user ID that you used. UniVerse SQL privileges do differentiate user, machine\user and domain\user unless these are matched in the UV.LOGINS file (which you can maintain from the Administrator client).\ - Original Message - From: Bjvrn Behr <[EMAIL PROTECTED]> Date: Tue, 15 Jun 2004 10:21:43 +0200 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/
Re: [U2] [UV] ODBC Error
Check the table privileges on the table(s) referred to in the SQL statement. LIST.SICA tablename or generate a query on the CATALOG tables (UV_TABLES, UV_USERS particularly). - Original Message - From: Bjvrn Behr <[EMAIL PROTECTED]> Date: Tue, 15 Jun 2004 10:21:43 +0200 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/
RE: [U2] [UV] ODBC Error
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/
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/
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/