Home > Archive > SQL Anywhere database > June 2005 > Limitation instances connected to DB with same username/groupname









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Limitation instances connected to DB with same username/groupname
Frank Vestjens

2005-06-23, 7:23 am

In a ASA 9.0 db we have created a group USR who is the owner of the tables
created in the DB.
Every user is member of this group to have access to these tables.

One of our customer has different usernames in our application, but uses USR
as the login name for the DB.
When printing reports with crystal reports another connection is created in
the DB to retreive the data for the report. So another connection with this
group USR is created.

Is there a limitation of the amount of connections on the same user/group
name in the DB?
The reason I ask this, is that the crystal report is generating an error
when the repor is opened and tries to connect to the DB.

The dblic returns the following result:

License read successfully
Licensed processors: 2

Any help would be great. Thanks in advance.

Regards,

Frank Vestjens
InforIT bv


Dmitri

2005-06-23, 7:23 am

Frank Vestjens wrote:

> Is there a limitation of the amount of connections on the same user/group
> name in the DB?


Unless a special login procedure has been implemented, no. You're either
allowed to connect or not.

> The reason I ask this, is that the crystal report is generating an error
> when the repor is opened and tries to connect to the DB.


And the error was? ;)

Dmitri.
Frank Vestjens

2005-06-23, 7:23 am

The crystal error is error 544 Cannot access report. I've looked in the
knowledge base of crystal and it seems that it could have something to do
with rights in the DB.

The report is available, I can open the file in code, but crystal can't.
Four or five users are able to open the report and then the next one is
getting this error.

Frank

"Dmitri" <NOdimSPAM@mail15.com> wrote in message
news:42ba9e8d@forums
-2-dub...
> Frank Vestjens wrote:
>
user/ group[color=darkred]

>
> Unless a special login procedure has been implemented, no. You're either
> allowed to connect or not.
>
>
> And the error was? ;)
>
> Dmitri.



Greg Fenton

2005-06-24, 9:23 am

Frank Vestjens wrote:
>
> The report is available, I can open the file in code, but crystal can't.
> Four or five users are able to open the report and then the next one is
> getting this error.
>


Are they all logging in with the same user IDs or do they have separate IDs?

Is there anything different with the way that other user is logging?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com