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)
Kevin Ridley
Kevin Ridley Accepted Answer Pending Moderation
  1. Monday, 22 April 2019 19:16 PM UTC
  2. PowerBuilder
  3. # 1

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.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 22 April 2019 19:35 PM UTC
  2. PowerBuilder
  3. # 2

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.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 23 April 2019 03:09 AM UTC
  2. PowerBuilder
  3. # 3

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.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 24 April 2019 10:50 AM UTC
  2. PowerBuilder
  3. # 4

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.
  • Page :
  • 1


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