Method for supporting multiple databases connection

Abstract

The invention discloses a method for accessing a DBMS (Data base Management System) based on a standard API (application program interface), which realizes the support for multi-database drive. When a program is developed, the scheduling of a standard API port is required to be realized, no any databases are required to pay attention to, and the types of multiple databases can be supported. Currently, the supported databases comprise Sybase, SQL (Structural Query Language) Server, Oracle, ODBC and DB2.

Description

technical field [0001] The invention relates to database access operations, supports commonly used databases such as sybase, oracle, sql server db2 mysql and the like, and can be applied to different industries. Background technique [0002] With the development of information technology and the market, databases are becoming more and more important to all walks of life, and most of the information needs to be stored in the database. Therefore, database storage and reading are often encountered in software development. Since there are many database vendors, the access interfaces of the databases are different. Although Microsoft has implemented a unified interface through odbc, it can only run on the windows platform, and the access efficiency is relatively low, and it cannot be cross-platform. Therefore, it is necessary to develop an efficient, cross-platform, database access interface that supports multiple database drivers. Contents of the invention [0003] The purpos...

AI Technical Summary

Problems solved by technology

Since there are multiple database manufacturers, the access interfaces of the databases are different. Although Microsoft has implemented a unified interface through odbc, it can only run on the windows platform, and the access efficiency is relatively low, and it cannot be cross-platform.

Images