Installing ODataDB

Installing ODataDB

ODataDB is a regular ASP.NET application and may be installed under IIS or IIS Express.

After installing ODataDB edit connection strings in the web.config file for databases available through OData.

Installing under IIS Express

  1. Download and install IIS Express.
    IIS Express 8.0: https://www.microsoft.com/en-us/download/details.aspx?id=34679
    IIS Express 7.5: https://www.microsoft.com/en-us/download/details.aspx?id=1038
  2. Unzip the downloaded ODataDB package to any folder on a local drive.
    For example, you may unzip the package to the C:\ODataDB folder.
  3. Go to the odatadb subfolder and run the start-under-iis-express.cmd batch file.

Then open the test URL: http://localhost:40440/odatadb.svc/NorthwindCE/default/$metadata

You may add start-under-iis-express.cmd to the Startup folder to run IIS Express and ODataDB automatically when Windows starts.

Installing under IIS

  1. Open the Internet Information Services (IIS) Manager.
  2. Right-click Sites and click Add Web Site...
  3. Provide a name and path for the new site.
    Ensure that "HTTP" is selected as the type.

Then open the test URL like http://localhost/odatadb/odatadb.svc/NorthwindCE/default/$metadata

Configuring Connections

ODataDB allows connecting to multiple databases using named connection strings in the web.config file.

For example, if the web.config file contains the following connection strings:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="AzureDemo50" connectionString="Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial Catalog=AzureDemo50;Integrated Security=SSPI"
      providerName="System.Data.OleDb" />
    <add name="NorthwindCE" connectionString="Data Source=C:\ODataDB\DB\Northwind.sdf"
      providerName="System.Data.SqlServerCe.4.0" />
  </connectionStrings>
</configuration>

ODataDB will create two OData services with the following URLs:

  • http://localhost:40440/odatadb.svc/AzureDemo50/default/
  • http://localhost:40440/odatadb.svc/NorthwindCE/default/

See details in the Web.config Files topic.

System Requirements

Supported Architectures:

  • x86
  • x64

Supported Operating Systems:

  • Windows XP SP3, Vista SP1, 7, 8, 8.1, 10
  • Windows Server 2003 SP3, 2008, 2008 R2, 2012, 2012 R2, 2016

Supported Versions of Internet Information Server (IIS):

  • IIS 7.5, 8.0
  • IIS Express 7.5, 8.0

Supported Versions of Microsoft SQL Server:

  • Microsoft SQL Server 2005, 2008, 2008 R2
  • Microsoft SQL Server 2012, 2014 including Express LocalDB
  • Microsoft Azure SQL Database

Supported Versions of Microsoft SQL Server Compact:

  • Microsoft SQL Server Compact 3.5, 4.0

Supported Versions of Oracle Database:

  • Oracle Database 10g Release 1, Release 2
  • Oracle Database 11g Release 1, Release 2
  • Oracle Database 12c Release 1

Supported Versions of IBM DB2:

  • IBM DB2 9.5, 9.7, 9.8, 10.1, 10.5, 11.1

IBM DB2 .NET Provider, IBM DB2 OLE DB Provider or IBM DB2 ODBC driver installed is required.

Supported Versions of MySQL:

  • MySQL 5.0, 5.1, 5.2, 5.5, 5.6, 5.7

Supported Versions of SkySQL MariaDB:

  • MariaDB 5.1, 5.2, 5.3, 5.5, 10.0, 10.1, 10.2

All application features for MySQL are completely compatible with MariaDB.
ADO.Net Driver for MySQL and MySQL ODBC drivers can be used to connect to MariaDB.
MariaDB ODBC Driver 1.0 is not supported.

Supported Versions of NuoDB:

  • NuoDB 2.0.4, 2.2

Supported Versions of PostgreSQL:

  • PostgreSQL 9.0, 9.1, 9.2, 9.3, 9.4
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.