Re: Need ideas for 'No connect permission' error

Bryce,

What are the two user IDs that cannot connect?   Are they
by chance too long, have spaces or special characters or
are keywords?

Joe

At 09:25 PM 1/17/2006, you wrote:
>Hi,
>
>We have a database (syspg4gl) that keeps all our modules and libraries
>and program relationships - based on old '4gl rapid development'.
>
>We have 4 developers - 2 can access this database using 4js, the other 2
>always get:
>
>Program stopped at 'helloworld.4gl', line number 2
>No connect permission
>ISAM error: no record found.
>
>Helloworld.4gl looks like:
>         database syspg4gl
>         main
>         display "HELLO WORLD"
>         end main
>
>We all have DBA permissions on this database, all our user permissions
>appear to be identical.
>
>I have just created this database fresh on a new database server and
>reloaded the data.  I imagined our problems would go away but was
>surprised to see the same two users still get the 'no connect
>permission' from fourjs programs.  If these users open Server Studio and
>logon as themselves they appear to have all the necessary permissions to
>manipulate the database in any fashion.
>
>So, has anyone seen anything like this?  I've run out of ideas as to
>what could be causing this error and am open to suggestions please.
>
>
>Regards,
>   Bryce Stenberg
>   IT Department,
>   Harness Racing New Zealand Inc.
>

P L E A S E  **  Join us at the 2006 Newzware User Group in Tucson,
May 3rd, 4th & 5th.   Ask any ICANON representative for details, or visit
http://www.newzware.com/ICANON/home/i_c/2006UserGroup/index.html for more 
information.

Joe Lewinski
ICANON Associates, Inc.
Phone: 215.822.5519 Fax: 215.822.5523