Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved EAServer Database Connection

  1. How-to
0
Votes
Undo
  1. Roland Smith
    Roland Smith
  2. PowerBuilder
  3. Monday, 22 April 2019 16:08 PM UTC

EAServer 6.3.1

I need to setup a database connection (connection cache in 5.x) for a SQL Anywhere 11 database located on the same PC as EAServer. I plan on creating some components using PowerBuilder 12.6 that connect to the database.

I'm also getting an error connecting to EAServer from another PC:

SystemException: CORBA::NO_PERMISSION

I am using the admin userid/password.

 

Getting db error when inserting row, but I can do ...
Download a file from dropbox
Responses (4)
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 24 April 2019 10:50 AM UTC
  2. PowerBuilder
  3. # 1

Hi Roland

Have you resolved your connection problem?

I know it's a daft question but are you using the 32-bit ODBC? EAS was a 32-bit process.

Otherwise I think it's pretty straightforward.

If you are still stuck I can open up EAS here and take a look for you :)

Cheers

David

Comment
Load more comments
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Thursday, 25 April 2019 09:59 AM UTC
I have sent you screen grabs of our configuration. Hopefully that will help :)
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Thursday, 25 April 2019 10:53 AM UTC
Yes thanks. Now that I created one, it is simple. Other than the Userid/Password there are only two field to fill in:

Database Type: SQL_Anywhere

Database URL: jdbc:odbc:driver=SQL Anywhere 11;uid=dba;pwd=sql;eng=WizSource11



Now I just need to get a component to connect to it.
  1. Helpful
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Thursday, 25 April 2019 13:26 PM UTC
Glad I could help :)
  1. Helpful
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 23 April 2019 03:09 AM UTC
  2. PowerBuilder
  3. # 2

I figured out why the Profile window in the PB IDE couldn't connect, the 'Login Name' is actually admin@system.

I still need to figure out how to add an ODBC database connection to SQL Anywhere 11. I already have a system level ODBC profile.

 

Comment
Load more comments
Roland Smith
  1. Roland Smith
  2. Tuesday, 23 April 2019 15:44 PM UTC
No. I've created a replacement for EAServer and wanted to be able to compare the two.
  1. Helpful
Kevin Ridley
  1. Kevin Ridley
  2. Tuesday, 23 April 2019 16:12 PM UTC
Nice! Hit me up on LinkedIN to get my contact info if you want to discuss anything else EAS related, I've done quite a bit of EAS over the years.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 23 April 2019 16:26 PM UTC
Hi Roland;

If you want a test case as well as EAS coding examples, my EAS framework is still available on SourceForge as well as a Demo App, as follows:

Framework: https://sourceforge.net/projects/stdfndclass/files/FrameWork/EAServer/Archive

DemoApp: https://sourceforge.net/projects/stdfndclass/files/Applications/EAServer/eStore

HTH

Regards ... Chris



  1. Helpful
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 22 April 2019 19:35 PM UTC
  2. PowerBuilder
  3. # 3

This is for my own research purposes. I would have used 5.5 but I couldn't get the manager app to work. If I could get 5.5 working I will switch to that.

Comment
There are no comments made yet.
Kevin Ridley
Kevin Ridley Accepted Answer Pending Moderation
  1. Monday, 22 April 2019 19:16 PM UTC
  2. PowerBuilder
  3. # 4

6.x was mostly a trainwreck.  The last good version was 5.5.  If you can talk them out of upgrading, I would.  That being said, I think db connection caches were still valid in 6.x, no?

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 23 April 2019 16:20 PM UTC
Hi Kevin;

EAS 6.3.1 was not too bad compared to the early 6.x releases. However, no v6.x that I tested (way back when) could hold a candle to the v5.5 performance. That is because EAS was re-engineered in the v6.x to use a JavaBean wrapper around the PB NVUO's vs EAS 5.5 that used a directed JVM to C++ InterOp.

Yes, EAS 6.x releases still used the same DB cache mechanism as in v5.x.

Regards ... Chris

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.