Kbase P103827: Using JDBC drivers getting 7677 and 7574 errors.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/3/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Error 7677 during execution of a grant statement from SqlExplorer.
[JDBC Progress Driver]:permission denied (7677)
Error 7574 when executing a create table statement from SqlExplorer.
[JDBC Progress Driver]:No RESOURCE privileges (7574)
CAUSE:
Wrong syntax is being used with the connect statement.
Syntax used: sqlexp -url jdbc:jdbcprogress:T:<host-name>:<port>:<db-name>:<user>:<password>
FIX:
Connect using the proper syntax.
sqlexp -url jdbc:jdbcprogress:T:<host-name>:<port>:<db-name> -user <user> -p password<password>
Check for proper syntax to be used with SQLExplorer by typing:
sqlexp -help