Part I What's New 1 Part II General Information 3 Part III .

2y ago
32 Views
2 Downloads
4.32 MB
123 Pages
Last View : 17d ago
Last Download : 2m ago
Upload by : Gia Hauser
Transcription

ContentsITable of ContentsPart I What's New1Part II General Information31 Overview. 32 Features. 53 Compatibility. 84 Requirements. 115 Licensing. 116 Getting.Support14Part III Using ODBC Driver161 Installation. 16. 17Window s. 20Window s Silent. 20m acOS. 28Linux DEB Package. 32Linux RPM Package2 Connecting.to Oracle353 Connection.String Options394 Secure.Connections43. 43SSL Connection. 48SSH Connection. 51HTTP Tunneling5 Product.Activation56.56Obtaining ActivationKey57Activation on.Window s61Activation on.m acOS62Activation on.Linux62Where to See.the License Inform ation?6 Sandboxed.Apps on macOS657 Using.with iODBC678 Supported.Data Types689 Supported.ODBC API Functions69Part IV Using in Third-Party Tools781 Using.in Microsoft Access782 Using.in DBeaver803 Using.in Microsoft Excel844 Using.in SQL Server Management Studio90. 90Using in SSMS.95Troubleshootingin SSMS 2020 Devart

IIODBC Driver for Oracle5 Using.in OpenOffice and LibreOffice996 Using.in PHP1097 Using.in Power BI1118 Using.in Python1129 Using.in QlikView11410 Using.in SSIS11911 Using.in Tableau120. 120Using in Tableau.121Troubleshootingin Tableau on m acOS 2020 Devart

What's New11What's New07-Dec-20 New features in ODBC Driver for Oracle 3.3Oracle 20c is supportedConnection via SSL protocol is supportedConnection via SSH protocol is supportedConnection via HTTP tunnel is supported08-Apr-20 New features in ODBC Driver for Oracle 3.2Long database object names are supportedPossibility of mapping DATE time to SQL TYPE DATE rather thanSQL TYPE TIMESTAMP is addedCompatibility with Power Pivot is improvedCompatibility with Visual Basic is improvedCompatibility with RStudio is improved04-Oct-19 New features in ODBC Driver for Oracle 3.1Oracle 19c is supportedNow ODBC driver is thread-safeNow ODBC driver activation does not require administrator privilegesImproved compatibility with sandboxed applications for macOSSupport for connection pooling is improved08-Jan-19 New features in ODBC Driver for Oracle 3.0Oracle 18c is supportedNow ODBC driver for macOS is distributed as a PKG packageNow ODBC driver for Linux is distributed as DEB and RPM packagesPossibility to force the ODBC 2.x behavior is added14-Jun-18 New features in ODBC Driver for Oracle 2.4Possibility to return String Types as Ansi or Unicode is addedCompatibility with MS Access is improvedCompatibility with Tableau is improvedCompatibility with Omnis Studio is improved 2020 Devart

2ODBC Driver for OracleCompatibility with Power Pivot is improvedCompatibility with DBeaver is improved26-Feb-18 New features in ODBC Driver for Oracle 2.3Performance of batch operations is significantly improved23-Oct-17 New features in ODBC Driver for Oracle 2.2Compatibility with SAS JMP is improvedCompatibility with MS Power Query is improvedOUTER JOIN macros in SQL queries are supportedDateTime macros in SQL queries are supportedScalar function macros in SQL queries are supportedNChar literal replacement is supportedRetrieving Metadata for Oracle 8 is improved26-Oct-16 New features in ODBC Driver for Oracle 2.1Oracle Cloud in the Direct mode is supportedOption for showing meta data only for the current scheme is addedCompatibility with MS Visual StudioCompatibility with MS FoxPro is improvedCompatibility with MapInfo is improvedCompatibility with Libre Office is improvedCompatibility with Qlik is improvedCompatibility with Delphi & C Builder is improvedMS Access linked tables support is improved05-Apr-16 New features in ODBC Driver for Oracle 2.0Linux is supportedmacOS is supportedSupport for stored procedures and functions is improvedBackward compatibility of SQLExecDirect with ODBC 2.x is improvedCompatibility with MS Excel is improvedCompatibility with ODBC 2.x is improvedBug with Trial expiration in Microsoft SQL Server Management Studio is fixedBug with fetching big data amount is fixed 2020 Devart

What's New306-Nov-15 New features in ODBC Driver for Oracle 1.2Compatibility with Microsoft Visual Studio is improvedCompatibility with Microsoft Office is improvedCompatibility with Microsoft SQL Server Management Studio is improvedCompatibility with Crystal Reports is improvedCompatibility with ClikView is improvedStored procedures metadata support is improvedInterval data types support is improved16-Jul-15 New features in ODBC Driver for Oracle 1.1Performance is improved20-May-15 New features in ODBC Driver for Oracle 1.0First release of ODBC Driver for OracleWindows 32-bit is supportedWindows 64-bit is supported 2015-2020Devart. All RightsReserved.2Request SupportODBC ForumProvide FeedbackODBC ForumProvide FeedbackGeneral Information1. Overview2. Features3. Compatibility4. Requirements5. Licensing6. Getting Support 2015-2020Devart. All RightsReserved.2.1Request SupportOverviewODBC Driver for Oracle provides high-performance and feature-rich connectivity solution forODBC-compliant applications to access Oracle databases from Windows, macOS, andLinux, both 32-bit and 64-bit. 2020 Devart

4ODBC Driver for OracleFull support for standard ODBC API functions and data types implemented in our drivermakes interaction of your application with Oracle fast, easy and extremely handy.Direct connectionOur connectivity solution enables various ODBC-aware applications to establish a directconnection to Oracle via TCP/IP to eliminate the need for Oracle Client. Direct connectionincreases the speed of data transmission between an external application and Oracle, whichis crucial for data analysis in real time. It also streamlines the deployment process, sincethere is no need to distribute any additional client software with the driver. You can alsoconnect to Oracle using the native Oracle client library.CompatibilityODBC Driver for Oracle supports the following versions of Oracle:Oracle Server: 19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition of 18c, 2020 Devart

General Information511g, and 10gOracle Client (x86 and x64 versions): 19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0; Oracle InstantClientOracle CloudNote: Support for x64 versions of Oracle Client is only available for 64-bit Windows. 2015-2020Devart. All RightsReserved.2.2Request SupportODBC ForumProvide FeedbackFeaturesDirect ConnectionDatabase applications based on our solution get an opportunity to establish connection toOracle by means of native Oracle client software and in Direct Mode. Direct Mode givesyour applications an unrivaled advantage - connection to Oracle databases directly via TCP/IPavoiding Oracle Client. That improves performance of your applications, their quality, reliabilityand especially the deployment process, since there is no need to supply additional clientsoftware together with your application. 2020 Devart

6ODBC Driver for OracleODBC ConformanceOur ODBC driver provides full support for common ODBC interface:ODBC Data Types supportODBC API Functions supportIn addition, we provide support for Advanced Connection String parameters. Thus allowingany desktop and web applications to connect to Oracle from various environments andplatforms, that support ODBC.Development Platforms VarietyODBC Driver for Oracle doesn't limit your choice of the development platform andenvironment. The driver installations are available for various operational systems andplatforms. The current version supports Windows, macOS, Linux, both 32-bit and 64-bit. Soyou can develop both 32-bit and 64-bit cross-platform applications. 2020 Devart

General Information7DB CompatibilityODBC Driver for Oracle supports Oracle servers: 19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0,including Oracle Express Edition 11g and 10g; as well as Oracle Cloud.ODBC Driver for Oracle supports both x86 and x64 versions of the following Oracle Clients:19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0, Oracle Instant Client.Note that support for x64 versions of Oracle Clients is available for 64-bit Windows.High PerformanceAll our products are designed to help you write high-performance, lightweight data accesslayers, therefore they use advanced data access algorithms and techniques of optimization. 2020 Devart

8ODBC Driver for OracleSupportVisit our Support page to get instant support from experienced professionals, fast and detailedresponses, user engagement and interaction, frequent builds with bug fixes, and much more. 2015-2020Devart. All RightsReserved.2.3Request SupportODBC ForumProvide FeedbackCompatibilityOracle CompatibilityODBC Driver for Oracle supports the following database servers:Oracle CloudsSupportOracle CloudOracle ServersSupport19c18c (including Express Edition)12c11g (including Express Edition)10g (including Express Edition)9i8i8.0Oracle ClientsSupport19c18c12c 2020 Devart

General Information11g10g9i8i8.0Oracle Instant ClientSupported Target PlatformsWindows, 32-bit and 64-bit (including Windows Terminal Server)macOS, 32-bit and 64-bitLinux, 32-bit and 64-bitVerified Compatibility With 3rd-Party Data ToolsApplication Development ToolsAdobe ColdFusionEmbarcadero Delphi & C BuilderUniDAC, FireDAC, dbGo (ADO), BDE and dbExpressFileMakerLazarusMicrosoft Visual FoxProMicrosoft Visual StudioServer Explorer and ADO.NET ODBC ProviderOmnis StudioPHPPowerBASICPython 2020 Devart9

10ODBC Driver for OracleDatabase ManagementAqua Data StudiodbForge StudiodBeaverEMS SQL Management StudioInformatica CloudRazorSQLSQL Server Data ToolsSQL Server Management StudioSQL Server Reporting ServicesBI & Analytics SoftwareAlteryxDBxtraDundas BIIBM SPSS StatisticsMicroStrategyPower BIQlik SenseQlikViewRStudioSAP Crystal ReportsSAS JMP 2020 Devart

General Information11TableauTARGITTIBCO SpotfireOffice Software SuitesLibreOfficeMicrosoft AccessMicrosoft ExcelOpenOfficeStarOffice 2015-2020Devart. All RightsReserved.2.4Request SupportODBC ForumProvide FeedbackRequirementsNo additional client software is required in the Direct mode. If you use the driver in the OCImode, Oracle Client must be installed on the client machine.You can only have one version of ODBC Driver for Oracle installed at a time. 2015-2020Devart. All RightsReserved.2.5Request SupportODBC ForumProvide FeedbackLicensingODBC Driver License --------PLEASE READ THIS LICENSE AGREEMENT CAREFULLY. BY INSTALLING OR USINGTHIS SOFTWARE,YOU INDICATE ACCEPTANCE OF AND AGREE TO BECOME BOUNDBY THE TERMS AND CONDITIONS OF THIS LICENSE. IF YOU DO NOT AGREE TO THETERMS OF THIS LICENSE, DO NOT INSTALL OR USE THIS SOFTWARE AND 2020 Devart

12ODBC Driver for OraclePROMPTLY RETURN IT TO DEVART.INTRODUCTIONThis Devart end-user license agreement ("Agreement") is a legal agreement between you(either an individual person or a single legal entity) and Devart, for the use of the ODBC Driversoftware application, demos, intermediate files, printed materials, and online or electronicdocumentation contained in this installation file. For the purpose of this Agreement, thesoftware program(s) and supporting documentation will be referred to as the "Software".LICENSE1. GRANT OF LICENSEThe enclosed Software is licensed, not sold. You have the following rights and privileges,subject to all limitations, restrictions, and policies specified in this Agreement.1.1. If you are a legally licensed user, depending on the license type specified in theregistration letter you have received from Devart upon purchase of the Software:- the "Desktop License" allows you to install and use the Software on a single desktopcomputer, provided it is accessed by no more than one person at a time, either directly orremotely, for sole purposes only in accordance with this Agreement. If more than one personcan simultaneously use the computer where you plan to install the product,you mustpurchase a Server License. A Desktop License is valid for one single desktop installation;- the "Server License" allows you to install and use the Software on a single server,provided itis accessed by more than one person at a time, either directly or remotely.This definitionincludes, but is not limited to, Web servers, application servers,batch servers, and desktopworkstations, where more than one concurrent users can access the Software. A ServerLicense is valid for one single server installation,provided it is used by 1 (one) legal entity inaccordance with this Agreement.1.2. If you are a legally licensed user of the Software, you are also entitled to:- make one copy of the Software for archival purposes only, or copy the Software onto thehard disk of your computer and retain the original for archival purposes;- develop and test Applications with the Software, subject to the Limitations below.1.3. You are allowed to use evaluation versions of the Software as specified in the Evaluationsection.No other rights or privileges are granted in this Agreement.2. LIMITATIONS 2020 Devart

General Information13Only legally registered users are licensed to use the Software, subject to all of the conditionsof this Agreement. Usage of the Software is subject to the following restrictions.2.1. You may not reverse engineer, decompile, or disassemble the Software.2.2. You may not reproduce or distribute any Software documentation without express writtenpermission from Devart.2.3. You may not distribute and sell any portion of the Software integrating it into yourApplications.2.4. You may not transfer, assign, or modify the Software in whole or in part. In particular, theSoftware license is non-transferable, and you may not transfer the Software installationpackage.2.5. You may not remove or alter any Devart's copyright, trademark, or other proprietary rightsnotice contained in any portion of Devart files.3. REDISTRIBUTIONThe license grants you a non-exclusive right to reproduce any new softwareprograms(Applications) created using the Software. You cannot distribute the Softwareintegrated into your Applications. Any Devart's files remain Devart's exclusive property.4. TRANSFERYou may not transfer the Software to any individual or entity without expr

including Oracle Express Edition 11g and 10g; as well as Oracle Cloud. ODBC Driver for Oracle supports both x86 and x64 versions of the following Oracle Clients: 19c, 18c, 12c, 11g, 10g, 9i, 8i, 8.0, Oracle Instant Client. Note that support for x64 versions of Oracle Clients is available for 64-bit Windows. High Performance

Related Documents:

Texts of Wow Rosh Hashana II 5780 - Congregation Shearith Israel, Atlanta Georgia Wow ׳ג ׳א:׳א תישארב (א) ׃ץרֶָֽאָּהָּ תאֵֵ֥וְּ םִימִַׁ֖שַָּה תאֵֵ֥ םיקִִ֑לֹאֱ ארָָּ֣ Îָּ תישִִׁ֖ארֵ Îְּ(ב) חַורְָּ֣ו ם

Independent Personal Pronouns Personal Pronouns in Hebrew Person, Gender, Number Singular Person, Gender, Number Plural 3ms (he, it) א ִוה 3mp (they) Sֵה ,הַָּ֫ ֵה 3fs (she, it) א O ה 3fp (they) Uֵה , הַָּ֫ ֵה 2ms (you) הָּ תַא2mp (you all) Sֶּ תַא 2fs (you) ְ תַא 2fp (you

Part No : MS-HTB-4 Part No : MS-HTB-6M Part No : MS-HTB-6T Part No : MS-HTB-8 Part No : MS-TBE-2-7-E-FKIT Part No : MS-TC-308 Part No : PGI-63B-PG5000-LAO2 Part No : RTM4-F4-1 Part No : SS 316 Part No : SS 316L Part No : SS- 43 ZF2 Part No : SS-10M0-1-8 Part No : SS-10M0-6 Part No : SS-12?0-2-8 Part No : SS-12?0-7-8 Part No : SS-1210-3 Part No .

FISHER Stock List Part No : 0305RC33B11 Part No : 1098 Part No : 1098-EGR Part No : 10A3261X12 Part No : 10B8735X012 Part No : 11A1347X012 Part No : 12B7100X082 Part No : 14B3620X012 Part No : 15P1066X062 F Part No : 16A5483X012 Part No : 16A5484X012 Part No : 16A5485X012 Part No : 17492319 Part No : 17A2325X022 Part No : 18A8275X012 Part No .

Part No : FR-PA07 Part No : FR-PU04 Part No : FR-PU07 Part No : FR-U120 Part No : FR-Z220-3.7K Part No : FR-Z240-3.7K-UL Part No : FR-Z-240-75K Part No : FR-Z720-1.5K Part No : FX0N-3A Part No : FX1N-232-BD Part No : FX1N-24MR Part No : FX1N-24MR-ES/UL Part No : FX1N-24MT-ESS/UL Part No :

Interactions 1 READING Listening &SPEAKING WEEK 4 Date Unit Part 2 Part 2 Part2 Part 3 Part 3 Part 4 Part 4 Part 4 Interactions 1 READING Listening &SPEAKING WEEK 5 Date Unit Quiz 1 Quiz 1 Chapter 3-Intro-Part 1:P.42-45 Chapter 4- Intro. Part 1 Before You Listen Part 1 :P.46-48 Part 2 Part 1 : After You Listen Part 2

Part No : SVI-II-4X-IP-66 Part No : J023995455177 Part No : CAGE (INNER) 15 Part No : CAGE (OUTER 26 Part No : CAGE GASKET 26 Part No : 010272032-779-0000 Part No : 010275042-24250000 Part No : 008387003-686-0000 Part No : 035107-040-716 Part No : SVI II AP 2112312130 Part No : 35-35212 Part No : 204500389-900-0000 Part No : 021000412-153G0000

Practical Scientific Procedures and techniques Internal 3 1 . TBC. . Part 4. Unit 14. Part 1 Part 2 Part 3 Part 4 . Unit 17. Part 1 Part 2 Part 3 Part 4 . Unit 21. Par. t1 . Part 2 Part 3 Part 4 . 5 P a g e . How to Hand In Work . Format of your work Font: Calibri (body) .