![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
![]() |
Thu, Mar 4 2021 1:10 AM | Permanent Link |
Ian Branch | 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 |
Thu, Mar 4 2021 8:52 AM | Permanent Link |
Raul ![]() | 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 |
Thu, Mar 4 2021 1:03 PM | Permanent Link |
Ian Branch | 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 |
Thu, Mar 4 2021 2:01 PM | Permanent Link |
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 |
Thu, Mar 4 2021 7:10 PM | Permanent Link |
Ian Branch | 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. ![]() >>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 |
Thu, Mar 4 2021 8:10 PM | Permanent Link |
Ian Branch | 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. Attachments: Screenshot_1.jpg |
Thu, Mar 4 2021 8:12 PM | Permanent Link |
Ian Branch | 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. Attachments: Screenshot_3.jpg |
Thu, Mar 4 2021 9:34 PM | Permanent Link |
Ian Branch | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |