Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Accessing MSSQL-Server
Tue, Jan 10 2017 11:12 AMPermanent Link

scwa

Hi there,
i am an absolutly newbie in EWB and want to develop a web-interface for an application based on the Microsoft SQL Server.
Now my question: Do i have to use ADO or is there another interface that i can use?
How can i set the user and password at runtime?
Is it possible to read the ConnectionString from a textfile at runtime?
Thx
Scwa
Tue, Jan 10 2017 12:21 PMPermanent Link

Matthew Jones

scwa wrote:

> Do i have to use ADO or is there another interface that i can use?
> How can i set the user and password at runtime?
> Is it possible to read the ConnectionString from a textfile at runtime?

This comes down to the server that you are using to supply the data. EWB has a supplied server, and that can be made to talk to other databases, but is best with EDB. If you have an existing web service that provides REST or other interfaces, then that can be used. Other options are any other server technology, from Delphi with a library (MorMOT, RemObjects, Delphi standard stuff), through to something in C# or any web language.

As for the passwords, never have them in your EWB application. They should be on the server, and the server should be verifying the permissions of the user and talking to the database. The user can see any data in the EWB application just by pressing F12. If you include the name/password then they have full control...

I think others have posted info on doing other databases in the EWB server, but not done that before myself (I have used C#/REST and Delphi RemObjects).

--

Matthew Jones
Wed, Jan 11 2017 1:43 AMPermanent Link

Eivind

Just to add to Matthew's answer. I'm using Delphi to compile ISAPI dll's and plug them in to IIS. This works like a charm. You can use any TDataSet object to query your data and use the delphi objects from Elevate to handle all the JSON and Database operations (TEWBDatabaseAdapter & TEWBDataSetAdapter)

Eivind
Image