I am developing the project and I want to try nearly every step of development. After I run the project and want to inspect the SQL statement of some dataset I always get 'connection error: ElevateDB error  #501 login failed'.

I raised ConnectionPproperties of a database RemoteConnectionTimeout to 150, RemotePingInterval to 30 and RemoteTimeout to 180 but the error after running the project is always displayed. I have to exit and restart EWB again and again.

Iztok Lajovic

Iztok,

<< I am developing the project and I want to try nearly every step of development. After I run the project and want to inspect the SQL statement of some dataset I always get 'connection error: ElevateDB error  #501 login failed'. >>

Do you have the LoginUser and LoginPassword properties set in the database's connection properties ?  Without those, you can't access the underlying database.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

>Do you have the LoginUser and LoginPassword properties set in the database's connection properties ?  Without >those, you can't access the underlying database.

Yes, I have defined both.

Iztok Lajovic

Iztok,

<< Yes, I have defined both.  >>

Then they're not correct, or you're accessing a different configuration than you think you are.

You're getting this error when trying to preview the dataset in the Database Manager in the IDE, correct ?

Tim Young
Elevate Software
www.elevatesoft.com

> Then they're not correct, or you're accessing a different configuration than you think you are.
>
>You're getting this error when trying to preview the dataset in the Database Manager in the IDE, correct ?

Yes, that is correct. But I don't change any configuration parameters. In FormaShow procedure I must have:
 database.databaseName := 'pan-razvoj';
 database.username := 'Administrator';
 database.password := 'EDBDefault';

If I omit these statements then I get error.

Obviously these parameters are changed in time when I run the application from IDE or after return from running application. I just have to stop WEB and start it again and then I can preview the datasets.

Iztok

Iztok,

<< Yes, that is correct. But I don't change any configuration parameters.  In FormaShow procedure I must have:
 database.databaseName := 'pan-razvoj';
 database.username := 'Administrator';
 database.password := 'EDBDefault';

If I omit these statements then I get error. >>

Yes, but that is different from the preview capability in the Database Manager.  The preview capability is the last tab in the dataset dialog when adding/editing a dataset.  It allows you to confirm that you can, indeed, open the dataset using the database connection properties and parameters/SQL that you've defined.

<< Obviously these parameters are changed in time when I run the application from IDE or after return from running application. I just have to stop WEB and start it again and then I can preview the datasets. >>

You have to stop and start the *IDE*, or your application ?

In general, it sounds like you've got an authentication issue due to the way that you've defined your connection properties for the database.  If you want to send me your ewbide.ini file from here:

C:\Users\<UserAccount>\AppData\Local\Elevate Software\Elevate Web Builder 2

along with your application, I can take a look and tell you what's going on.

Tim Young
Elevate Software
www.elevatesoft.com