RE: Need ideas for 'No connect permission' error

Hi Joe,

Thanks for your suggestions - while double checking them I found a
solution (and there was nothing special or different about user names,
they already used same names successfully against other databases)

Turns out I had to 'grant connect to public;' for them to be able to
work.

Now I don't understand why that should be, I'd already granted connect
to each individually by name as well as DBA permissions.
It worked for two but not the other two.

Very puzzling - anyone have an explanation of why it would behave this
way?

Regards,
  Bryce Stenberg
  IT Department,
  Harness Racing New Zealand Inc.
  

> -----Original Message-----
> From: [email protected] 
> [mailto:[email protected]] On Behalf Of Joe Lewinski
> Sent: Wednesday, 18 January 2006 3:49 p.m.
> To: [email protected]
> Subject: Re: [fourjs-users] 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.ht
> ml for more information.
> 
> Joe Lewinski
> ICANON Associates, Inc.
> Phone: 215.822.5519 Fax: 215.822.5523
> 
> 
>