Error Messages (N)
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #
Non SELECT in r/o connection
The "Non SELECT in r/o connection" error message suggest that you have read-only permissions on the table against which you are trying to query.
Review this possibility.
Additionally, your
1.
Use a text editor to open the oplrqb.ini file which you find in the /bin sub-directory of your
2. Scroll down to [Domain Aliases].
3.
Locate the domain, which you pass in the Domain or
Informix 7 = inf7
4.
Scroll down to [Mapping Rules].
5.
Locate your domain alias abbreviation.
For example:
inf7:*:*:*:*:*:* = accept generic_inf7
6.
Find the [generic_xxxx] section which is associated with your alias.
For example:
[generic_inf72] Description = Default settings for Informix 7.2 agent Program = inf72_sv Environment = INFORMIX72 OpsysLogin = Yes ReUse = never ;CommandLine = ;ConnectOptions = ;Directory = /tmp ;Database = ;Userid = ;Password = ReadOnly = Yes
7.
Insure that
ReadOnly = No
9.
If you make changes, restart or reinitialize your
Finally, one build of
ENTER SQLSetConnectOption HDBC 091D14D8 UWORD 101 <SQL_ACCESS_MODE> SQLLEN 1
If your 3.2 software contains this bug, you will need to upgrade your software.
(The fix was introduced in
Evidence
Session Rules Book
Request Broker Log
Database Agent Version String
Referenced by...