ODBC API

ODBC (Open Database Connectivity) is a pervasive standard for client/server database access that was developed by Microsoft that allows a programmer to abstract a program from a database. Using ODBC, an application can access data from any ODBC data source (relational, object oriented or flat file) with a standard set of SQL requests without having to code directly to the data source.

For instance, if you wanted an application to get data from three data sources, Sybase, Oracle and Access, without an ODBC API you would have to code the program with thee different database languages. When programming using ODBC, you can access any ODBC compliant data source using the ODBC API, which resolves the function calls for each of the target data sources.

Even using the ODBC interface, you still would need to code to each of the data sources independently. With dbSpaces you can make one ODBC call that will allow you to access multiple ODBC compliant data sources simultaneously.

dbSpaces's ODBC interface provides a flexible and comprehensive solution. Using the ODBC API, you can access any ODBC data source, local or remote, from any application.

Extending the Power

In the same way that developers writing applications using ODBC are freed up from having to communicate with each data source in its native language, developers using dbSpaces with its ODBC and other APIs can simplify development and reduce application lead times. And you get access to all of your data sources with a fraction of the effort required traditionally.