IDS .NET Data Provider IDS Server

Home

Products
   IDS Server
   IDS JDBC Driver
  .NET Data Provider
  .NET SQL Driver
   What's New
Download
   IDS Server Trial
   ODBC Drivers
   Other Tools
Pricing

Ordering

Support
   FAQ
   Articles
   JDBC Quick Start
Company
   About Us
   Our Customers
   Contact


 

IDS .NET Data Provider allows ADO.NET applications to connect and query a wide range of databases supported by IDS Server, including Oracle, Sybase, Informix, DB2, Microsoft SQL Server 2000, 7 and 6.x, Ingres, PostgreSQL, MySQL, Yard-SQL, mSQL, and all ODBC compatible databases including Microsoft Access, dBase, FoxPro, etc.

Refer to the solution diagram for a conceptual view of the relationship between IDS .NET Data Provider, IDS Server and the supported databases.

 Why Not Just Use Microsoft .NET Data Providers?

The .NET Framework offers four data providers for SQL Server, OLE-DB, Oracle and ODBC compatible data sources. If the .NET application and the database are on two separate computers, these providers and similar products have significant limitations when connecting a .NET application to a remote database:

Providers

Data Source Types

Limitations

ODBC
OLE-DB

Desktop databases: MS Access, dBase, FoxPro, etc., or any data sources that do not have built-in networking access capabilities.

· Connection is possible if the two computers are linked by a Microsoft Windows network.

· Connection is not possible if the two computers are linked only by the Internet.

ODBC
OLE-DB

Network capable databases like Sybase, Informix, DB2, Ingres, MySQL, PostgreSQL, etc.

· Connection is possible if the ODBC driver or the OLE-DB Provider can connect to the remote database.

· If the two computers are linked only by the Internet, the remote database must be exposed to the Internet.

SQL Server
Oracle

SQL Server 2000, SQL Server 7.
Oracle 9i, Oracle 8i, Oracle 7.

· Connection is provided.

· If the two computers are linked only by the Internet, the database Server must be exposed to the Internet.

 What Does IDS .NET Data Provider Offer?

IDS .NET Data Provider harnesses the power of IDS Server to offers superior connectivity and security to a large collection of databases.  It eliminates the two major problems with the four Microsoft .NET Data Providers and similar products:

  • You can now deploy .NET client applications that can access remote desktop databases (MS Access, dBase, FoxPro, etc.) through IDS Server.  These client can be running in an Intranet or from machines out on the Internet.  
  • Full feature databases like Oracle and SQL Server no longer have to be exposed to the Internet to service Internet client applications.

Using advanced security features like Custom Data Source, dbShield and Secure dbAccess, IDS Server and IDS .NET Data Provider offers many ways to access and to protect databases:

  • Custom Data Source prevents unauthorized access to internal data sources.
  • dbShield prevents the execution of unauthorized database commands.
  • Secure dbAccess ensures privacy by encrypting the connections between the data provider and IDS Server.
  • Connections to multiple homogeneous or heterogeneous databases simultaneous using the same provider.
  • Built-in connection pooling and prepared statement pooling.
  • ResultSet Caching enables seamless, fast and concurrent process of large query results.
  • The data provider can connect to IDS Server across client-side firewalls using a number of protocols such as SOCKS, SSL Tunneling and HTTP Tunneling.
Copyright c 1997-2006 IDS Software. All rights reserved.