Hi All.

I am trying to make a web app that utilize remote dbisam database.
Could anyone show me minimum steps how to connect remote dbisam database from my app using EWB v3?
Before with V2 I connected successfully but it is hard with V3. Do I need to install ewbsrvr.exe on the same machine that resides dbisam database as in V2? It so how?
So far, somehow, I was successful to connect remote dbisam database from inside EWB IDE with internal server only.
After searching this forum and reading documentations I still did not get it and I finally gave up.

Simple step by step with working example would be very helpful.

Thanks

Hi,

there is nothing special accessing DBISAM with EWB3. The steps (which you probably already know):

- In Server Manager / Servers / <your server> / Databases, create a new database
- Find a name, Engine Type is DBISAM
- Properties: Just like in dbsys: remote host + port, database name, remote user + password
- Click on "Test"
- If everything works as expected, click "OK"

Can you connect to the database server via dbsys.exe? If yes, then you just have to use the same connection parameters in EWB. Otherwise, you have to look at the firewall: is the port (probably 12005) open? Is the DBISAM server restricted to specific ip addresses?

Ralf


Kane Jun wrote:

Hi All.

I am trying to make a web app that utilize remote dbisam database.
Could anyone show me minimum steps how to connect remote dbisam database from my app using EWB v3?
Before with V2 I connected successfully but it is hard with V3. Do I need to install ewbsrvr.exe on the same machine that resides dbisam database as in V2? It so how?
So far, somehow, I was successful to connect remote dbisam database from inside EWB IDE with internal server only.
After searching this forum and reading documentations I still did not get it and I finally gave up.

Simple step by step with working example would be very helpful.

Thanks

Hi,

there is nothing special accessing DBISAM with EWB3. The steps (which you probably already know):

- In Server Manager / Servers / <your server> / Databases, create a new database
- Find a name, Engine Type is DBISAM
- Properties: Just like in dbsys: remote host + port, database name, remote user + password
- Click on "Test"
- If everything works as expected, click "OK"

Can you connect to the database server via dbsys.exe? If yes, then you just have to use the same connection parameters in EWB. Otherwise, you have to look at the firewall: is the port (probably 12005) open? Is the DBISAM server restricted to specific ip addresses?

Ralf


Kane Jun wrote:

Hi All.

I am trying to make a web app that utilize remote dbisam database.
Could anyone show me minimum steps how to connect remote dbisam database from my app using EWB v3?
Before with V2 I connected successfully but it is hard with V3. Do I need to install ewbsrvr.exe on the same machine that resides dbisam database as in V2? It so how?
So far, somehow, I was successful to connect remote dbisam database from inside EWB IDE with internal server only.
After searching this forum and reading documentations I still did not get it and I finally gave up.

Simple step by step with working example would be very helpful.

Thanks

Hi Raif

Thanks for your input.

I can connect remote DBISAM inside EWB3 IDE as you suggested.
Let me rephrase my question.
Can I connect the remote DBISAM outside IDE from my web app or my website ( example : index.html,index.js ) ?
Please forgive me if the question is too basic.

Kane.








Ralf Mimoun wrote:

Hi,

there is nothing special accessing DBISAM with EWB3. The steps (which you probably already know):

- In Server Manager / Servers / <your server> / Databases, create a new database
- Find a name, Engine Type is DBISAM
- Properties: Just like in dbsys: remote host + port, database name, remote user + password
- Click on "Test"
- If everything works as expected, click "OK"

Can you connect to the database server via dbsys.exe? If yes, then you just have to use the same connection parameters in EWB. Otherwise, you have to look at the firewall: is the port (probably 12005) open? Is the DBISAM server restricted to specific ip addresses?

Ralf


Kane Jun wrote:

Hi All.

I am trying to make a web app that utilize remote dbisam database.
Could anyone show me minimum steps how to connect remote dbisam database from my app using EWB v3?
Before with V2 I connected successfully but it is hard with V3. Do I need to install ewbsrvr.exe on the same machine that resides dbisam database as in V2? It so how?
So far, somehow, I was successful to connect remote dbisam database from inside EWB IDE with internal server only.
After searching this forum and reading documentations I still did not get it and I finally gave up.

Simple step by step with working example would be very helpful.

Thanks

No, at least not useful. If you want to connect directly via JavaScript, you would need a JavaScript DBISAM client. Which does not exist (same for MySQL etc).

What you need is a EWB3 standalone server which a) is open to the internet on port 443 (or 80, but most of the time not using ssl a bad idea) and b) can connect to your DBISAM server on port 12005 (or whatever port you use). After installing that server, you can configure it just like the embedded server in the EWB IDE. You can even clone the IDE server config with users, roles and database stuff to that standalone server. Your EWB app talks to that server, the server talks to DBISAM.

Ralf


Kane Jun wrote:

Hi Raif

Thanks for your input.

I can connect remote DBISAM inside EWB3 IDE as you suggested.
Let me rephrase my question.
Can I connect the remote DBISAM outside IDE from my web app or my website ( example : index.html,index.js ) ?
Please forgive me if the question is too basic.

Kane.








Ralf Mimoun wrote:

Hi,

there is nothing special accessing DBISAM with EWB3. The steps (which you probably already know):

- In Server Manager / Servers / <your server> / Databases, create a new database
- Find a name, Engine Type is DBISAM
- Properties: Just like in dbsys: remote host + port, database name, remote user + password
- Click on "Test"
- If everything works as expected, click "OK"

Can you connect to the database server via dbsys.exe? If yes, then you just have to use the same connection parameters in EWB. Otherwise, you have to look at the firewall: is the port (probably 12005) open? Is the DBISAM server restricted to specific ip addresses?

Ralf


Kane Jun wrote:

Hi All.

I am trying to make a web app that utilize remote dbisam database.
Could anyone show me minimum steps how to connect remote dbisam database from my app using EWB v3?
Before with V2 I connected successfully but it is hard with V3. Do I need to install ewbsrvr.exe on the same machine that resides dbisam database as in V2? It so how?
So far, somehow, I was successful to connect remote dbisam database from inside EWB IDE with internal server only.
After searching this forum and reading documentations I still did not get it and I finally gave up.

Simple step by step with working example would be very helpful.

Thanks

Raif,

Thanks a lot.

I will try your suggestion.



Ralf Mimoun wrote:

No, at least not useful. If you want to connect directly via JavaScript, you would need a JavaScript DBISAM client. Which does not exist (same for MySQL etc).

What you need is a EWB3 standalone server which a) is open to the internet on port 443 (or 80, but most of the time not using ssl a bad idea) and b) can connect to your DBISAM server on port 12005 (or whatever port you use). After installing that server, you can configure it just like the embedded server in the EWB IDE. You can even clone the IDE server config with users, roles and database stuff to that standalone server. Your EWB app talks to that server, the server talks to DBISAM.

Ralf


Kane Jun wrote:

Hi Raif

Thanks for your input.

I can connect remote DBISAM inside EWB3 IDE as you suggested.
Let me rephrase my question.
Can I connect the remote DBISAM outside IDE from my web app or my website ( example : index.html,index.js ) ?
Please forgive me if the question is too basic.

Kane.








Ralf Mimoun wrote:

Hi,

there is nothing special accessing DBISAM with EWB3. The steps (which you probably already know):

- In Server Manager / Servers / <your server> / Databases, create a new database
- Find a name, Engine Type is DBISAM
- Properties: Just like in dbsys: remote host + port, database name, remote user + password
- Click on "Test"
- If everything works as expected, click "OK"

Can you connect to the database server via dbsys.exe? If yes, then you just have to use the same connection parameters in EWB. Otherwise, you have to look at the firewall: is the port (probably 12005) open? Is the DBISAM server restricted to specific ip addresses?

Ralf


Kane Jun wrote:

Hi All.

I am trying to make a web app that utilize remote dbisam database.
Could anyone show me minimum steps how to connect remote dbisam database from my app using EWB v3?
Before with V2 I connected successfully but it is hard with V3. Do I need to install ewbsrvr.exe on the same machine that resides dbisam database as in V2? It so how?
So far, somehow, I was successful to connect remote dbisam database from inside EWB IDE with internal server only.
After searching this forum and reading documentations I still did not get it and I finally gave up.

Simple step by step with working example would be very helpful.

Thanks