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.
|
|