I was deploying my EWB on my test server, but for some reason it can't see the database tables.
In the Database tab I added all my EDB databases and they all test good.

Do I need to add every dataset from each database in the box below?

I get the error: Dataset load response error(Dataset "mytbl" not found)

Thanks.

I found that I have to add every dataset to the webserver.

I tough I could import all the Datasets by clicking the Import button but that erased everything.

All the databases are identical, is there a way to import it to all the dataset to the other databases?

Thanks.

On 1/27/2017 8:47 PM, KimHJ wrote:
> I found that I have to add every dataset to the webserver.
> I tough I could import all the Datasets by clicking the Import button but that erased everything.

It imports from EWB IDE so unless you also are developing on that test
server there would be nothing to import.

> All the databases are identical, is there a way to import it to all the dataset to the other databases?

All the database and dataset settings are in the EWB Web Server ini
(usually in C:\ProgramData\Elevate Software\Elevate Web Builder 2 Web
Server\ewbsrvr.ini).

Shut down and exit from web server and you can manually edit the
ewbsrvr.ini to add what's needed manually.

The EWB IDE INi file stores the EWB IDE setting including datasets (it's
usually in C:\Users\<username>\AppData\Local\Elevate Software\Elevate
Web Builder 2\ewbide.ini) so one option would be to copy the
database/dataset settings from this file to ewbsrvr.ini

Of if you just create the needed folders structure on test server and
copy the ewbide.ini into correct folder from your dev machine then
import should work.

As always make sure all the file system paths are valid on test server

Raul

Raul wrote:

>It imports from EWB IDE so unless you also are developing on that test
server there would be nothing to import.

Thanks Raul.

When you say test server are you refering to my own Test server, like the EWB internal server?

On 1/28/2017 11:32 PM, KimHJ wrote:
> When you say test server are you refering to my own Test server, like the EWB internal server?

No i had assumed from your original post ("I was deploying my EWB on my
test server") that you had a separate windows test server (possibly
hosted one) and were trying to deploy to that.


Raul

Raul wrote:

>No i had assumed from your original post ("I was deploying my EWB on my
test server") that you had a separate windows test server (possibly
hosted one) and were trying to deploy to that.

That is exactly what i'm doing so I can copy ewbsrvr.ini from my dev computer?

Kim

On 1/29/2017 11:37 PM, KimHJ wrote:
> That is exactly what i'm doing so I can copy ewbsrvr.ini from my dev computer?

That should work.

Even simpler way now that i think about it again would be to run the ewb
web server on your development computer (where ewb is).

Import db/ds there and copy the resulting ewbsrvr.ini to your server.

Raul

Raul wrote:

>Even simpler way now that i think about it again would be to run the ewb
web server on your development computer (where ewb is).

>Import db/ds there and copy the resulting ewbsrvr.ini to your server.

That is what I did after you told me about the import.
Then when I open the same file on my Windows 2012R2 server the file is empty and I did a search on the whole hard drive and didn't find another ewbide.ini

Where does it hide.
I see the edbmgr.ini in the Elevate DB Manager folder and that is not empty.


Kim

On 1/30/2017 10:39 AM, KimHJ wrote:
> That is what I did after you told me about the import.
> Then when I open the same file on my Windows 2012R2 server the file is empty and I did a search on the whole hard drive and didn't find another ewbide.ini

ewbide.ini would be on that server ONLY if you copied it there or ran
actual EWB IDE.

However if you copy the ewbsrvr.ini (ewb web server ini) then you do not
even need the ewbide.ini file.

So steps would be as follows

On dev system:
1. start EWB Web Server on your dev system
2. import databases and datasets (or configure manually as needed)
3. shut down ewb web server on dev system (so ini is written)
4. take copy of the ewbsrvr.ini file from dev system
(C:\ProgramData\Elevate Software\Elevate Web Builder 2 Web Server usually)

on deploy server
1. run ewb web server (so it creates the folders and ini initially)
2. fully close and exit from ewb web server
3. Place the ewbsrvr.ini from dev system on your server in same folder
4. start ewb web server and check settings (databases/datasets)

> Where does it hide.
> I see the edbmgr.ini in the Elevate DB Manager folder and that is not empty.

The ewbsrvr.ini should be under "c:\ProgramData\..." since it's common
to the system.

edbmgr if EDB manager file and is per user files so it should live in
"C:\Users\<username>\AppData\Local\..." - each user has their own copy
of these

Raul

Raul wrote:

>However if you copy the ewbsrvr.ini (ewb web server ini) then you do not
even need the ewbide.ini file.


Thanks Raul,
That did work, so now I just copy the [Database_MyData] and all [Database_MyData_Dataset_MyTable]
Rename them to the new database and paste it.

Worked great.

Kim