ODBC Repository link Function library

Source: Internet
Author: User
Tags html form odbc odbc connection
There are 25 functions Open data links (Open Database connectivity, ODBC) in this library that are common interfaces for linking repositories. ODBC is the Microsoft-led database connectivity Standard, and the implementation environment is the most mature in Microsoft's system.

In Unix systems, it is common to use ODBC interfaces provided by other vendors, and some UNIX vendors provide their own ODBC interfaces (such as SUN has ODBC for Solaris).
ODBC and database queries take the SQL language, which is the same as most database queries, making it easy to communicate with a variety of repositories. Of course, through the ODBC interface, the backend database does not necessarily have to be a DBMS for this large database system, it can be a table (such as Microsoft Access), or a spreadsheet (such as Microsoft Excel).
Odbc_autocommit: Switch automatic change function.
Odbc_binmode: Set binary data processing mode.
Odbc_close: Close ODBC connection.
Odbc_close_all: Closes all ODBC connections.
Odbc_commit: Changes ODBC database.
Odbc_connect: Link to ODBC repository.
Odbc_cursor: Gets the cursor name.
Odbc_do: Execute SQL directives.
Odbc_exec: Execute SQL directives.
Odbc_execute: Executes preset SQL directives.
Odbc_fetch_into: Gets the specified column returned.
Odbc_fetch_row: Get a column back.
Odbc_field_name: Gets the field name.
Odbc_field_type: Get field data form.
Odbc_field_len: Gets the field data length.
Odbc_free_result: Release the memory that returns the data.
Odbc_longreadlen: Sets the maximum value for the return column.
Odbc_num_fields: Gets the number of fields.
Odbc_pconnect: Link to ODBC database for a long time.
Odbc_prepare: Presets SQL directives.
Odbc_num_rows: Gets the number of returned columns.
Odbc_result: Get the information back.
Odbc_result_all: Returns HTML form data.
Odbc_rollback: Undo current transaction.
Odbc_setoption: Adjusting ODBC settings



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.