{"id":10,"date":"2003-01-01T12:00:00","date_gmt":"2003-01-01T09:00:00","guid":{"rendered":"http:\/\/www.ibprovider.com\/eng\/documentation.html"},"modified":"2023-01-25T12:27:45","modified_gmt":"2023-01-25T09:27:45","slug":"documentation","status":"publish","type":"page","link":"https:\/\/www.ibprovider.com\/eng\/documentation.html","title":{"rendered":"Documentation and examples"},"content":{"rendered":"<div class=\"ibp__doc_cat\">\r\n\r\n\t<div class=\"ibp__doc_cat_block\">\r\n\t\t<div class=\"ibp__doc_cat_header\">\r\n\t\t\tInterBase manuals\r\n\t\t<\/div>\r\n\t\t<div class=\"ibp__doc_cat_content\">\r\n\t\t<ul>\r\n\t\t\t<li><a  href=\"documentation\/interbase.html\">InterBase<\/a> for beginners<\/li>\r\n\t\t\t<li><a  href=\"download_interbase.html\">InterBase download<\/a><\/li>\r\n\t\t\t<!--\r\n\t\t\t<li>InterBase 7<\/li>\r\n\t\t\t<li>InterBase 2007<\/li>\r\n\t\t\t<li>InterBase 2009<\/li>\r\n\t\t\t-->\r\n\t\t\t<li><a  href=\"documentation\/interbase-xe-2010-features.html\">5 key innovations in InterBase XE (InterBase 2010)<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_interbase_64_bit.html\">InterBase 64 bit<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_interbase_delphi.html\">InterBase Delphi<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_interbase_odbc_drivers.html\">InterBase ODBC vs OLE DB<\/a><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"ibp__doc_cat_block\">\r\n\t\t<div class=\"ibp__doc_cat_header\">\r\n\t\t\tFirebird manuals\r\n\t\t<\/div>\r\n\t\t<div class=\"ibp__doc_cat_content\">\r\n\t\t<ul>\r\n\t\t\t<li><a  href=\"documentation\/firebird.html\">Firebird<\/a> for beginners<\/li>\r\n\t\t\t<li><a  href=\"download_firebird.html\">Firebird download<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_20_adonet.html\">Firebird 2.0<\/a> with ADO .Net samples<\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_21_adonet.html\">Firebird 2.1<\/a> with ADO .Net samples<\/li>\r\n\t\t\t<!-- <li>Firebird 2.5<\/li> -->\r\n\t\t\t<li><a  href=\"documentation\/firebird_interbase_64_bit.html\">Firebird 64 bit<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_interbase_delphi.html\">Firebird Delphi<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_interbase_odbc_drivers.html\">Firebird ODBC vs OLE DB<\/a><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"ibp__doc_cat_block\">\r\n\t\t<div class=\"ibp__doc_cat_header\">\r\n\t\t\t\u00abLCPI ADO.NET Data Provider for OLE DB\u00bb manuals\r\n\t\t<\/div>\r\n\t\t<div class=\"ibp__doc_cat_content\">\r\n\t\t<ul>\r\n\t\t\t<li><a  title=\"Installer for \u00abLCPI ADO.NET Provider for OLE DB\u00bb [MSI].\" href=\"documentation\/lcpi_oledb_net__installer_msi.html\">Installer [MSI]<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/lcpi_oledb_net__using_adonet_with_firebird.html\">Usage of .NET provider with Firebird SQL Server<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/connection_to_firebird_in_visual_studio_2017_via_ddex_provider.html\">Connection to the Firebird database in Visual Studio 2017 via the DDEX provider<\/a><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"ibp__doc_cat_block\">\r\n\t\t<div class=\"ibp__doc_cat_header\">\r\n\t\t\tExamples of work with Firebird and InterBase\r\n\t\t<\/div>\r\n\t\t<div class=\"ibp__doc_cat_content\">\r\n\t\t<ul>\r\n\t\t\t<li><a href=\"documentation\/examples.html\">Go to the catalog of examples for C#, VB.NET, VBA, Visual Basic, VBScript, C++ and Delphi<\/a><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"ibp__doc_cat_block\">\r\n\t\t<div class=\"ibp__doc_cat_header\">\r\n\t\t\tGeneral Information\r\n\t\t<\/div>\r\n\t\t<div class=\"ibp__doc_cat_content\">\r\n\t\t<ul>\r\n\t\t\t<li><a  href=\"documentation\/differences_between_versions.html\">Differences between IBProvider versions<\/a><\/li>\r\n\r\n\t\t\t<li><a  href=\"documentation\/firebird_interbase_guid_boolean.html\">Usage of BOOLEAN and GUID types in Firebird and InterBase<\/a><\/li>\r\n\r\n\t\t\t<li><a  href=\"documentation\/firebird_interbase_create_database_code.html\">How to create a Firebird or InterBase database by using ADOX and Visual C# .NET (or VBScript)<\/a>\r\n\r\n\t\t\t<li><a  href=\"documentation\/odbc_escape_sequences.html\">ODBC Escape Sequences<\/a><\/li>\r\n\r\n\t\t\t<li><a  href=\"documentation\/ibprovider-and-lcpi_com_api.html\">IBProvider and \u00abLCPI COM API\u00bb<\/a><\/li>\r\n\r\n\t\t\t<li><a  href=\"documentation\/ibprovider-and-registration_free_com.html\">IBProvider and \u00abRegistration Free COM\u00bb<\/a><\/li>\r\n\r\n\t\t\t<li><a  href=\"documentation\/ibprovider_without_regsvr.html\">Using IBProvider without registering in Windows (deprecated)<\/a><\/li>\r\n\r\n\t\t\t<li><a  href=\"news\/n_090813.html\">Setting up query pool of IBProvider<\/a>.<\/li>\r\n\r\n\t\t\t<li><a  href=\"documentation\/charsets_collations.html\">Charsets of InterBase and Firebird<\/a><\/li>\r\n\r\n\t\t\t<li><a  href=\"documentation\/interfaces.html\">IBProvider interfaces<\/a><\/li>\r\n\r\n\t\t\t<li><a  href=\"documentation\/faq.html\">General FAQs<\/a><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"ibp__doc_cat_block\">\r\n\t\t<div class=\"ibp__doc_cat_header\">\r\n\t\t\tVisual Studio .Net 2005-2008, ADO.Net\r\n\t\t<\/div>\r\n\t\t<div class=\"ibp__doc_cat_content\">\r\n\t\t<ul>\r\n\t\t\t<li><a  href=\"documentation\/firebird_adonet.html\">InterBase, Firebird ADO.Net. p1<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_adonet_p2_visual_studio_2008.html\">InterBase, Firebird ADO.Net. p2<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_adonet_p3_ddl_odbc_metadata.html\">InterBase, Firebird ADO.Net. p3<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_20_adonet.html\">Firebird 2.0<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/firebird_21_adonet.html\">Firebird 2.1<\/a><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"ibp__doc_cat_block\" id=\"mssql\">\r\n\t\t<div class=\"ibp__doc_cat_header\">\r\n\t\t\tMS SQL Linked Server and Business Intelligence\r\n\t\t<\/div>\r\n\t\t<div class=\"ibp__doc_cat_content\">\r\n\t\t<ul>\r\n\t\t\t<li><a  href=\"documentation\/ssis_firebird_interbase.html\">Integration Services. Import and data processing in Firebird and InterBase.<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/ssis_and_lcpi_data_oledb_as_destination.html\">Integration Services. Using \u00abLCPI ADO.NET Data Provider for OLE DB\u00bb as a data recipient<\/a><\/li>\r\n\t\t<\/ul>\r\n\t\t<ul>\r\n\t\t\t<li><a  title=\"Registration and work with Linked Server of MSSQL 2012.\" href=\"documentation\/mssql_2012.html\">Registration and work with Linked Server of MSSQL 2012.<\/a><\/li>\r\n\t\t\t<li><a  title=\"Registration and work with Linked Server of MSSQL 2000.\" href=\"documentation\/con_to_ms.html\">Registration and work with Linked Server of MSSQL 2000.<\/a><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"ibp__doc_cat_block\" id=\"ibp_props\">\r\n\t\t<div class=\"ibp__doc_cat_header\">\r\n\t\t\tIBProvider objects properties\r\n\t\t<\/div>\r\n\t\t<div class=\"ibp__doc_cat_content\">\r\n\t\t<ul>\r\n\t\t\t<li><a  href=\"documentation\/property_001.html\">Connection String Properties (ADODB.Connection.Properties)<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/property_002.html\">Data Source Properties (ADODB.Connection.Properties)<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/property_003.html\">Information Properties (ADODB.Connection.Properties)<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/property_004.html\">Session properties (ADODB.Connection.Properties)<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/property_005.html\">Rowset And Command Properties (ADODB.Recordset.Properties, ADODB.Command.Properties)<\/a><\/li>\r\n\t\t\t<li><a  href=\"documentation\/property_006.html\">Data Source Properties For Database Creation<\/a><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t<div class=\"ibp__doc_cat_block\">\r\n\t\t<div class=\"ibp__doc_cat_header\">\r\n\t\t\tSchema Rowsets descriptions\r\n\t\t<\/div>\r\n\t\t<div class=\"ibp__doc_cat_content\">\r\n\t\t<table>\r\n\t\t<tr>\r\n\r\n\t\t<td valign=\"top\" style=\"padding-right:10px;\">\r\n\t\t<ul>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms709785.aspx\" onmouseover=\"this.href=this.title\">PROVIDER_TYPES Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms716980.aspx\" onmouseover=\"this.href=this.title\">TABLES Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms718258.aspx\" onmouseover=\"this.href=this.title\">TABLES_INFO Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms723052.aspx\" onmouseover=\"this.href=this.title\">COLUMNS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms711240.aspx\" onmouseover=\"this.href=this.title\">COLUMN_DOMAIN_USAGE Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms724021.aspx\" onmouseover=\"this.href=this.title\">PROCEDURES Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms723092(VS.85).aspx\" onmouseover=\"this.href=this.title\">PROCEDURE_COLUMNS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms713623.aspx\" onmouseover=\"this.href=this.title\">PROCEDURE_PARAMETERS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms722638.aspx\" onmouseover=\"this.href=this.title\">CHARACTER_SETS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms715783.aspx\" onmouseover=\"this.href=this.title\">COLLATIONS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms714362.aspx\" onmouseover=\"this.href=this.title\">PRIMARY_KEYS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms711276.aspx\" onmouseover=\"this.href=this.title\">FOREIGN_KEYS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms723122.aspx\" onmouseover=\"this.href=this.title\">VIEWS Rowset<\/a><\/noindex><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/td>\r\n\r\n\t\t<td\t valign=\"top\">\r\n\t\t<ul>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms719727.aspx\" onmouseover=\"this.href=this.title\">VIEW_TABLE_USAGE Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms714896.aspx\" onmouseover=\"this.href=this.title\">VIEW_COLUMN_USAGE Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms715921.aspx\" onmouseover=\"this.href=this.title\">TABLE_CONSTRAINTS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms713710.aspx\" onmouseover=\"this.href=this.title\">CONSTRAINT_TABLE_USAGE Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms724522.aspx\" onmouseover=\"this.href=this.title\">CONSTRAINT_COLUMN_USAGE Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms712845.aspx\" onmouseover=\"this.href=this.title\">CHECK_CONSTRAINTS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms719643.aspx\" onmouseover=\"this.href=this.title\">CHECK_CONSTRAINTS_BY_TABLE Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms712990.aspx\" onmouseover=\"this.href=this.title\">KEY_COLUMN_USAGE Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms719737.aspx\" onmouseover=\"this.href=this.title\">REFERENTIAL_CONSTRAINTS Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms725428.aspx\" onmouseover=\"this.href=this.title\">TABLE_PRIVILEGES Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms715800.aspx\" onmouseover=\"this.href=this.title\">COLUMN_PRIVILEGES Rowset<\/a><\/noindex><\/li>\r\n\t\t\t<li><noindex><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"#\" title=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms709712.aspx\" onmouseover=\"this.href=this.title\">INDEXES Rowset<\/a><\/noindex><\/li>\r\n\t\t<\/ul>\r\n\t\t<\/td>\r\n\t\t<\/tr>\r\n\t\t<\/table>\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div>\r\n","protected":false},"excerpt":{"rendered":"InterBase manuals InterBase for beginners InterBase download 5 key innovations in InterBase XE (InterBase 2010) InterBase 64 bit InterBase Delphi InterBase ODBC vs OLE DB Firebird manuals Firebird for beginners Firebird download Firebird 2.0 with ADO .Net samples Firebird 2.1 with ADO .Net samples Firebird 64 bit Firebird Delphi Firebird ODBC vs OLE DB \u00abLCPI [&hellip;]","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-10","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ibprovider.com\/eng\/wp-json\/wp\/v2\/pages\/10","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ibprovider.com\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ibprovider.com\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ibprovider.com\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ibprovider.com\/eng\/wp-json\/wp\/v2\/comments?post=10"}],"version-history":[{"count":9,"href":"https:\/\/www.ibprovider.com\/eng\/wp-json\/wp\/v2\/pages\/10\/revisions"}],"predecessor-version":[{"id":3260,"href":"https:\/\/www.ibprovider.com\/eng\/wp-json\/wp\/v2\/pages\/10\/revisions\/3260"}],"wp:attachment":[{"href":"https:\/\/www.ibprovider.com\/eng\/wp-json\/wp\/v2\/media?parent=10"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}