Hi Guys,
On my Customer's Win 2012 R2 server I have two instances of EDBSrvr running.
They each have their own Port, 12010 & 12020.
They each have their own Config file.
I have an App which runs this Query..
{sql}
SELECT runsum(1), * FROM Configuration.ServerSessions
Group by ID
order by ID
{sql}
The Engine/Session/Database are initialised from a local .ini file.  Initialisation parameters have been verified at run time.
The App runs perfectly in one directory/database area via 12010, producing the expected listing.
It doesn't produce anything in the other, 12020 area.
I have checked each of the edbsrvr settings and aside from the Port and drive/directory they are the same.
It has been like this for some time and I keep coming back to it however it doesn't impact what I generally need to do so it always gets put aside.
Now I want to resolve it.
I am open to suggestions as to why it works in one but not the other..

I note the above sql works in either Session in edbmgr.

Regards & TIA,
Ian

On 3/4/2021 1:10 AM, Ian Branch wrote:

> On my Customer's Win 2012 R2 server I have two instances of EDBSrvr running.
> They each have their own Port, 12010 & 12020.
> They each have their own Config file.

Are you referring to each having a unique "Configuration Folder" INI
value setting or are you just referring server named INI section.

If they are supposed to provide access to same databases then they need
to reference same config folder but if independent then separate ones.

Not really important for this query you're running but just checking.

> The App runs perfectly in one directory/database area via 12010, producing the expected listing.
> It doesn't produce anything in the other, 12020 area.

Can you clarify this one also - it should either generate an error or
run successfully and return 0 or more records.

> I am open to suggestions as to why it works in one but not the other..

Normally i would suggest to double-check that named instance INI
sections are correct, check firewall permissions and  server logs.
However if you can access both from edbmgr then looks like your app.

> I note the above sql works in either Session in edbmgr.

In that case servers appear to be OK and something with your code -
edbmgr is just another app using same components and does not do
anything special.

Raul

Raul wrote:

On 3/4/2021 1:10 AM, Ian Branch wrote:

> On my Customer's Win 2012 R2 server I have two instances of EDBSrvr running.
> They each have their own Port, 12010 & 12020.
> They each have their own Config file.

>>Are you referring to each having a unique "Configuration Folder" INI
value setting or are you just referring server named INI section.

Yes.

>>Can you clarify this one also - it should either generate an error or
run successfully and return 0 or more records.

As best I can tell it is running but returning 0 rows but there are definitely rows that should be returned

>>In that case servers appear to be OK and something with your code -
edbmgr is just another app using same components and does not do
anything special.

I have to agree but I can't find/see what it is/might be.  There is no code difference between the two environments so at a guess that leaves a component property, but I don't know which component/properety.  Nothing seems incorrect.

Raul

On 3/4/2021 1:03 PM, Ian Branch wrote:
> As best I can tell it is running but returning 0 rows but there are definitely rows that should be returned

Silly question but are you sure you are on a remote session with the
right server ?

Local session for example will allow you to query this and might return
0 if there are no actual remote sessions (since it itself is not a
remote session).

> I have to agree but I can't find/see what it is/might be.  There is no code difference between the two environments so at a guess that leaves a component property, but I don't know which component/properety.  Nothing seems incorrect.

Using local session would be my guess or maybe permissions for the edb
login running as app (if different than in edb manager).

Since all works in edbmanager use it to view the server sessions while
app is running - assuming app connects the session and leaves it active
edb manager would show the app session (as well as its own)

Raul

Raul wrote:

>>Silly question but are you sure you are on a remote session with the
right server ?

Old adage - There are no Silly/Stupid questions, only stupid answers.  Yes other data in the same App are returning information from the correct database/tables.

>>Using local session would be my guess or maybe permissions for the edb
login running as app (if different than in edb manager).

OK.  But I don't understand how given it is all in a separate directory and the Configs appear to be correct.

>>Since all works in edbmanager use it to view the server sessions while
app is running - assuming app connects the session and leaves it active
edb manager would show the app session (as well as its own)

edbmgr says both sessions are remote when it accesses them.  Where do I pull the session type from in my app to confirm if it is running Local or Remote?

Ian

This is from the Test area where it isn't working.
The attached screenshot_1 shows the Engine & Session conditions after initialisation in FormCreate..
DBE1 is TEDBEngine & DBWhoIsOn is TEDBSession.
The indicated parameters are all correct.

This is from the Live area where it is working.
The attached screenshot_3 shows the Engine & Session conditions after initialisation in FormCreate..
DBE1 is TEDBEngine & DBWhoIsOn is TEDBSession.
The indicated parameters are all correct.

Found it!!!!
The Application's log in User did not have Administrator rights in the database.
All fixed, now working as desired.
Tks Raul or your interest.

Regards,
Ian