Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Web.Config and ElevateDB
Thu, Oct 22 2015 9:17 AMPermanent Link

Alan Craker

Does anyone have a sample web config that I could have a look at to configure Elevate for use with a web server I am putting up? The shop I am in has been doing mostly desktop stuff with C++ Builder, and I am brand new to using Elevate, so any assistance would be appreciated. On kind of a tight deadline with this and don't have a lot of time to dig up the information. Thanks in advance...
Thu, Oct 22 2015 9:29 AMPermanent Link

Raul

Team Elevate Team Elevate

On 10/22/2015 9:17 AM, Alan Craker wrote:
> Does anyone have a sample web config that I could have a look at to configure Elevate for use with a web server I am putting up? The shop I am in has been doing mostly desktop stuff with C++ Builder, and I am brand new to using Elevate, so any assistance would be appreciated. On kind of a tight deadline with this and don't have a lot of time to dig up the information. Thanks in advance...

Can you be more specific what you're looking for and what web server are
you using ?

EWB in the simplest sense is just a a html and javascript file served to
client browser so you would publish it as any other html file.

If you need to do data access etc then it gets tiny bit more involved
depending on what exactly you're truing to do.

Raul
Thu, Oct 22 2015 9:41 AMPermanent Link

Alan Craker

Basically, I am putting up a simple ASP web site to allow an external vendor to do postbacks to us with invoicing data attached. So... I just need to parse the params off the url, stuff that info into a database, and then I have a backend service that will pick that data up and do things with it. I need to configure an ODBC connection to my database using the Elevate ODBC drivers as my datasource.

Raul wrote:

On 10/22/2015 9:17 AM, Alan Craker wrote:
> Does anyone have a sample web config that I could have a look at to configure Elevate for use with a web server I am putting up? The shop I am in has been doing mostly desktop stuff with C++ Builder, and I am brand new to using Elevate, so any assistance would be appreciated. On kind of a tight deadline with this and don't have a lot of time to dig up the information. Thanks in advance...

Can you be more specific what you're looking for and what web server are
you using ?

EWB in the simplest sense is just a a html and javascript file served to
client browser so you would publish it as any other html file.

If you need to do data access etc then it gets tiny bit more involved
depending on what exactly you're truing to do.

Raul
Thu, Oct 22 2015 9:53 AMPermanent Link

Raul

Team Elevate Team Elevate

On 10/22/2015 9:41 AM, Alan Craker wrote:
> Basically, I am putting up a simple ASP web site to allow an external vendor to do postbacks to us with invoicing data attached. So... I just need to parse the params off the url, stuff that info into a database, and then I have a backend service that will pick that data up and do things with it. I need to configure an ODBC connection to my database using the Elevate ODBC drivers as my datasource.

Never mind - on my first coffee still and was trying to answer for
elevate web builder (not EDB).

Since you're ASP the EDB is a standard .net data provides (ADO.Net).

The general install docs and info is here :

http://www.elevatesoft.com/manual?action=topics&id=edb2dac&section=using_the_net_data_provider

The asblinst.exe utility that is included should be able to make the
proper entries in the .config files

The deploying article talks about .net and visual studio :

http://www.elevatesoft.com/articles?action=view&category=edb&article=deploying_elevatedb_applications

There is also general tips and trick article :

http://www.elevatesoft.com/articles?action=view&category=edb&article=elevatedb_20_net_data_provider_tips_tricks

There is a discussion around web.config entries here :
http://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&page=1&msg=5257#5257

but again asblinst.exe should be able to update the config files for
without needing any manual editing.



Raul
Thu, Oct 22 2015 1:27 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Alan,

<< Does anyone have a sample web config that I could have a look at to configure Elevate for use with a web server I am putting up? The shop I am in has been doing mostly desktop stuff with C++ Builder, and I am brand new to using Elevate, so any assistance would be appreciated. On kind of a tight deadline with this and don't have a lot of time to dig up the information. Thanks in advance... >>

Raul is correct - the asblinst.exe utility provided with the EDB Data Provider can be used for updating the *machine.config* file.  However, if you don't want to make the EDB Data Provider available for the entire machine, or don't have the rights to do so, then you can edit the web.config files and add the same lines from the machine.config file to the web.config file.

The lines that you want are:

<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
  <dependentAssembly>
Here >>>>   <assemblyIdentity name="Elevate.ElevateDB.Data" publicKeyToken="cf9bc1202c75e9e2"/>
          <codeBase version="2.19.3.0" href="file:///C:\Program Files (x86)\ElevateDB 2 DAC-CS\assemblies\edbprovider\Elevate.ElevateDB.Data.dll"/>
  </dependentAssembly>
</assemblyBinding>
</runtime>

and:

<system.data>
<DbProviderFactories>
Here >>>>   <add name="ElevateDB Data Provider" invariant="Elevate.ElevateDB.Data" description="ElevateDB 2 .Net Data Provider" type="Elevate.ElevateDB.Data.EDBProviderFactory, Elevate.ElevateDB.Data, Version=2.19.3.0, Culture=neutral, PublicKeyToken=cf9bc1202c75e9e2"/>
</DbProviderFactories>
</system.data>

The public key tokens, are all the same across all versions of EDB, but you *definitely* need to make sure that the version/build numbers match those of the EDB .NET Data Provider.

Tim Young
Elevate Software
www.elevatesoft.com
Image