#HOW TO USE JDBC ODBC DRIVER IN NETBEANS MOD#

At these two levels of compliance, the BASIS ODBC/JDBC Driver can supply over 30 scalar functions, including ASCII, POWER (double, integer), RAND (double), REPLACE (char, char, char), CURTIME and DATABASE.Īggregate functions such as SUM, MEAN and MOD are available while functions like EXISTS, NOT EXISTS, IN and NOT IN have been added.Ī BBjRecordSet is a logical view of a set of records defined in terms of an SQL SELECT or a BBj® multi-keyed file. This translates into an ODBC driver that handles SQL in a more standardized way and a shorter learning curve for employees who already understand SQL functionality. The BASIS ODBC Driver supports Minimum + SQL Grammar and Level 1 ODBC API. Utilizing a wide variety of ODBC/JDBC-aware tools such as spreadsheets, graphics programs and Web browsers, end users can make the best use of this valuable data. What these businesses needed was a solution that would give their employees the ability to make their own reports and queries using the Windows productivity programs they already know, such as Microsoft Access and Microsoft Excel, and Crystal Reports.īy providing an industry-standard application program interface (API) between Windows applications and BASIS databases, the BASIS ODBC/JDBC Driver gives users transparent access to corporate data. Businesses could either accept a limited number of queries and reports provided by their system developers or spend significant amounts of time and money creating custom reports and queries. Access to corporate data used to be difficult.

How to use jdbc odbc driver in netbeans