Centura 7.5.1 MS ACCESS problems

comp.databases.gupta (1995-2015)
Christian Schabert

Centura 7.5.1 MS ACCESS problems

Post by Christian Schabert » 11 Feb 2004, 11:57

 Posted by:  Christian Schabert <Schab...@t-online.de> 

Hello,
i'm working with W2K centura sqlbase server 7.5.1 and access the database
with MS ACCESS 2000, it works. I only combine the tables.

1st problem:

I'm wondering that I cannot change any data record. I always get the
message:
Microsoft Access
ODBC: Aktualisierung in einer verknüpften Tabelle "tablename..."
fehlgeschlagen
MERANT] [ODBC SQLBase driver][SQLBase]01102 SEC SVI Security violation
attempting to access (#1102)

2nd problem:

I cannot create any calculation such e.g. qty * price

Microsoft Access
ODBC-Aufruf fehlgeschlagen.
MERANT] [ODBC SQLBase driver][SQLBase]00907 PRS ICN Invalid column name
(#907)

I would be very grateful for any help.

Regards

Christian Schabert

Niels Allerheiligen

Centura 7.5.1 MS ACCESS problems

Post by Niels Allerheiligen » 11 Feb 2004, 14:03

 Posted by:  Niels Allerheiligen <NAllerh...@genese.de> 

Hi Christian.


From Centura's Error.sql:
01102 SEC SVI Security violation attempting to access
Reason: Attempting to access an object when authority has not been
granted to use the specified object.
Remedy: Obtain proper authority before attempting to access the
specified object.

I would try it again with username = sysadm, which is the default for
SQLBase.


Error.sql:
00907 PRS ICN Invalid column name
Reason: The column name is invalid.
Remedy: Verify that the specified column names are valid.

It seems that your sql statement has a syntax error. What does it look
like?

-Niels-

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot] and 1 guest