Hi,

With the ElevateDB .NET provider, does it mean that I can place an
ElevateDB database with tables on a web site and an ASP.NET (ADO.NET?)
application can access the data directly?

Or, does the web hosting provider need to install ElevateDB on their
site?

Thanks.

Hi Frederick,

The .NET dat providers need to be installed on the computer as they make
entries into the registry.



Frederick Chin wrote:
> Hi,
>
> With the ElevateDB .NET provider, does it mean that I can place an
> ElevateDB database with tables on a web site and an ASP.NET (ADO.NET?)
> application can access the data directly?
>
> Or, does the web hosting provider need to install ElevateDB on their
> site?
>
> Thanks.

Hi Chris,

>The .NET dat providers need to be installed on the computer as they make
>entries into the registry.

Does this mean that if I am writing a .NET application and the web
host provider does not support ElevateDB, my application will not run
on that web site?

- Frederick

Yes, I am afraid so.

When I write my web applications if I need database access I host an
ElevateDB Server on my own server with a static IP address and link to
that from the WEB server.

Chris Holland [Team Elevate]

Frederick Chin wrote:
> Hi Chris,
>
>> The .NET dat providers need to be installed on the computer as they make
>> entries into the registry.
>
> Does this mean that if I am writing a .NET application and the web
> host provider does not support ElevateDB, my application will not run
> on that web site?
>
> - Frederick

I should have metioned that I do this via web services hosted on my own
server

Chris Holland

Chris Holland [Team Elevate] wrote:
> Yes, I am afraid so.
>
> When I write my web applications if I need database access I host an
> ElevateDB Server on my own server with a static IP address and link to
> that from the WEB server.
>
> Chris Holland [Team Elevate]
>
> Frederick Chin wrote:
>> Hi Chris,
>>
>>> The .NET dat providers need to be installed on the computer as they
>>> make entries into the registry.
>>
>> Does this mean that if I am writing a .NET application and the web
>> host provider does not support ElevateDB, my application will not run
>> on that web site?
>>
>> - Frederick

"Chris Holland [Team Elevate]" <mail@chrisholland.me.uk> wrote:

>I should have metioned that I do this via web services hosted on my own
>server

Thank you for the information!

Frederick

Chris,

<< The .NET dat providers need to be installed on the computer as they make
entries into the registry. >>

Really ?  I thought that they only updated the .config files for web
applications, just like with the machine.config file for desktop
applications.

Our ElevateDB .NET data provider only updates the registry for Visual Studio
integration, for example.  The rest is handled via the machine.config file
(<runtime> and <system.data> tags).

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

I am out of the office now until Friday, but I will double check when I
get back in.

Chris Holland

Tim Young [Elevate Software] wrote:
> Chris,
>
> << The .NET dat providers need to be installed on the computer as they make
> entries into the registry. >>
>
> Really ?  I thought that they only updated the .config files for web
> applications, just like with the machine.config file for desktop
> applications.
>
> Our ElevateDB .NET data provider only updates the registry for Visual Studio
> integration, for example.  The rest is handled via the machine.config file
> (<runtime> and <system.data> tags).
>

Okay, I have looked into this some more and found the following:

The good news is that you can use the ElevateDB ADO driver in your web
pages. (The ODBC driver does need to be registered on the web server)

To access data from an ElevateDB database in a web page you need to do
the following:

Edit the web.config file to include the code below:

<system.data>
  <DbProviderFactories>
    <add name="ElevateDB Data Provider"
invariant="My.Elevate.ElevateDB.Data" description="ElevateDB 1 .Net 2.0
Data Provider" type="Elevate.ElevateDB.Data.EDBProviderFactory,
Elevate.ElevateDB.Data, Version=1.9.1.0, Culture=neutral,
PublicKeyToken=cf9bc1202c75e9e2"/>
  </DbProviderFactories>
</system.data>

<runtime>
  <assemblyBinding>
    <dependentAssembly>
      <assemblyIdentity name="My.Elevate.ElevateDB.Data"
publicKeyToken="cf9bc1202c75e9e2"/>
 <codeBase version="1.9.1.0"
href="file:///.\Bin\Elevate.ElevateDB.Data.dll"/>
    </dependentAssembly>
  </assemblyBinding>
</runtime>


Note that I have called the driver "My.Elevate.ElevateDB.Data" to
prevent it clashing with the "Elevate.ElevateDB.Data" in the
machine.config file.

Also I have copied the "Elevate.ElevateDB.Data.dll" into the \bin
subdirectory of my web site.

After changing the web.config file to the above I am able to use the
ElevateDB ADO driver in my web pages.

Hope this helps.

Chris Holland

Chris,

<< To access data from an ElevateDB database in a web page you need to do
the following: >>

Cool, thanks very much.  I will look into changing the asblinst.exe so that
it can handle the .config file name also, which will allow it to be used for
this purpose.

--
Tim Young
Elevate Software
www.elevatesoft.com