Download User`s Guide
Transcript
Error Messages from PCC The operating system may be expecting the user to change his/ her password on the first logon. The Create Database Wizard does not allow this, so the connection fails. On Windows NT, this situation occurs if, in the User Manager, you have selected the User Must Change Password at Next Logon checkbox. If the user is a member of another group with lesser permissions, the lesser permissions will override the greater permissions. A user always has the most restrictive permissions of any group to which the user belongs. Solution: Double-check the spelling of the user name and the password. Make sure the user and password have been set up on the remote server operating system. Inspect the user’s account information on the server. Make sure the operating system is not expecting the user’s password to be changed at the next logon. Make sure the user is not also a member of a group that has restricted permissions. For Windows NT/2000, be sure that the user is set up as a local user on the system, not a network user. Network users have a domain name and a backslash preceding the user name, such as BOSTON\GILBERT. Be sure that the user who is a member of the Administrators group or Pervasive_Admin group is a local user. When trying to create a stored procedure in PCC, I get this error: ODBC Error: SQLSTATE = S1000, Native error code = -4994. The record has a key field containing a duplicate value (Btrieve Error 5) A stored procedure already exists with the same name as the one you are trying to create. Solution: Change the name of the stored procedure. Sometimes when you create a procedure with a SQL statement, you may not get a message from PCC confirming that the statement was successful. Then, when you run the statement again, thinking that it was not created, you receive this error code. To find out whether or not the procedure was actually created, you can get a list of the defined stored procedures by running this statement: select * from X$proc# 9-11