🚀 go-pugleaf

"L.M. Bemmelmans" <info@diractivity.nl> wrote in message
news:4186306a$1@newsgroups.borland.com...
> Hi,
>
> During development my connectionstring has the following databasename:
>
> "c:\inetpub\wwwroot\myApplication\bin\mydatabase.mdb"
>
> On my website the database should be in the "www\bin" directory
>
> What should the name of de database then be ? "www\bin\mydatabase.mdb", or
> "bin\mydatabase.mdb" ?
> How can I place/retrieve this connection-information in the config file ?
>
> Leon
>
>

Hi Leon,
here is a sample which was provided to me by John Moshakis in these
newsgroups.
I hope it can hope you as well.

regards
Stuart

In the Web.Config file add something like the following.

 <!--  APPSETTINGS
    This section sets the database connection properties.
 -->
  <appSettings>
 <add key="BLA.ConnectionString"
value="database=DB;uid=username;server=Delphi-DotNet;pwd=password" />
  </appSettings>

in your code perhaps add something like this.

function DA.CreateDBConnection():SQLConnection;
var
  Connection: SQLConnection;

begin
  Connection := SQLConnection.Create;
  Connection.ConnectionString :=
ConfigurationSettings.AppSettings['BLA.ConnectionString'];

  result := Connection;
end;