slide1
Download
Skip this Video
Download Presentation
ASE 138: What is new in Sybase Adaptive Server Enterprise Connectivity

Loading in 2 Seconds...

play fullscreen
1 / 34

Sybase ASE ADO Data Provider - PowerPoint PPT Presentation


  • 537 Views
  • Uploaded on

ASE 138: What is new in Sybase Adaptive Server Enterprise Connectivity. Mani Reddy Development Manager Sybase Inc. [email protected] Ashish Mahajan Development Manager Sybase Inc. [email protected] August 15-19, 2004. The Enterprise. Unwired. The Enterprise. Unwired.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Sybase ASE ADO Data Provider' - arleen


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

ASE 138: What is new in Sybase Adaptive Server Enterprise Connectivity

Mani Reddy

Development Manager

Sybase Inc.

[email protected]

Ashish Mahajan

Development Manager

Sybase Inc.

[email protected]

August 15-19, 2004

the enterprise unwired3
The Enterprise. Unwired.

Industry and Cross Platform Solutions

Manage

Information

Unwire

Information

Unwire

People

  • Adaptive Server Enterprise
  • Adaptive Server Anywhere
  • Sybase IQ
  • Dynamic Archive
  • Dynamic ODS
  • Replication Server
  • OpenSwitch
  • Mirror Activator
  • PowerDesigner
  • Connectivity Options
  • EAServer
  • Industry Warehouse Studio
  • Unwired Accelerator
  • Unwired Orchestrator
  • Unwired Toolkit
  • Enterprise Portal
  • Real Time Data Services
  • SQL Anywhere Studio
  • M-Business Anywhere
  • Pylon Family (Mobile Email)
  • Mobile Sales
  • XcelleNet Frontline Solutions
  • PocketBuilder
  • PowerBuilder Family
  • AvantGo

Sybase Workspace

connectivity products
Connectivity Products
  • SDK
  • Open Server
slide5
SDK
  • Open Client (CTLib, DBLib)
  • ESQL/C
  • ESQL/Cobol
  • XA
  • jConnect
  • ODBC
  • OLEDB
  • ADO.NET
platforms
Platforms
  • Solaris 32,64
  • HPUX 32,64
  • HPUX Itanium 32,64
  • AIX 32,64
  • Linux 32
  • Linux Itanium 64
  • Tru64
  • NT/Windows 32
  • IRIX 32,64
  • MacOSX
sdk open server releases
SDK, Open Server Releases
  • GA Release : SDK, Open Server
  • ESDs once every two monthsSDK ESDOpen Server ESDjConnect ESD
  • Current in-market releases: 12.0, 12.5.1
  • Next major release: 15.0
release 12 5 1
Release 12.5.1
  • All features from previous releases (SSL, LDAP etc)
  • 12.5.1 GA released in Jan’04 with the following features:
    • Netlib optimization
    • Re-entrant Open Server shows significant performance gains
      • Lang server showing 116-196% performance improvement.
      • Smaller footprint and fewer threads created.
    • Date and Time data-types
    • MIT-Kerberos on Solaris 32,64 and Linux 32
    • HA-Failover support in ESQL
  • New features in 12.5.1 ESDsXA64 on Solaris64 (ESD#1)IPV6 on Solaris32,64 and NT/Windows (ESD#2)SSL+SBGSE support on Solaris 32,64 and NT/Windows (ESD#2)
sdk open server feature roadmap
SDK/Open Server Feature Roadmap
  • OCS 12.5.1 ESD #4 – 7/2004
  • Dblib:Config variable for version
  • Added diagnostic ( tds tracing)
  • ASE 15.0 Beta 2, OCS 15.0 Beta - Q1,2005. All previous features plus
  • SDK and Open Server beta w/ install
  • Scrollable Cursors
  • BCP-Partitions (Phase 2)
  • BCP-Computed columns
  • Large identifiers
  • SSL upgrade to 4.x w/ FIPS 140-2
  • Latest Kerberos MIT libraries
  • ASE default packet size
  • Unilib character set conversion
  • Update COBOL compiler to latest
  • ASE 15.0/OCS 15.0 GA – Q2/2005.All previous features
  • XML datatype
  • XA64 on HP64, HPIA64,IBM64
  • OCS 12.5.1 ESD#6 for ASE 12.5.3 – Q4,/2004
  • BCP-Encrypted Columns
  • SSL Plus 3.1.10H
  • Korean char set enhancements
  • ASE 15x/OCS 15x , Q4,2005
  • Clusters: Login redirection
  • Clusters: Extended HA failover
  • Clusters: Context migration
  • Clusters: Connection migration
  • Clusters : XA
  • ASE 15.0 Beta 1, with OCS 15.0 – Q3, 2004
  • New datatypes
    • 64-bit integer /Big Int
    • Unsigned Int
    • Unitext datatype
  • BCP Partitions-phase1
  • Library renaming/streamlining

Q2/Q4,2005

Q2,2004

Q1,2005

jconnect feature roadmap
jConnect Feature Roadmap
  • ASE 15.0 Beta 1, with jConnect 6x – Q3, 2004
  • Scrollable Cursors
  • Unitext datatype
  • ASE 15.0 Beta 2, SDK 15.0
  • (jConnect 6x) Beta Q1,2005. All previous features plus
  • SDK w/ install
  • Large identifiers
  • Latest Kerberos MIT libraries
  • LDAP 5.x
  • ASE default packet size
  • Big Int/64bit Integer
  • Unsigned int
  • Enhance Ribo for new features
  • JDBC 3.0 (partial: on-demand methods)
  • ASE 15.0/SDK 15.0 GA – Q2/2005.All previous features
  • XML datatype
  • ASE 15x/SDK 15x , Q4,2005
  • Clusters: Login redirection
  • Clusters: Extended HA failover
  • Clusters: Context migration
  • Clusters: Connection migration

Q2/Q4,2005

Q2,2004

Q1,2005

dblibrary
DBLibrary
  • No new feature(s)/Enhancements after version 10.0 like CTLibrary.
  • Well supported.
  • Changes
    • Appropriate error messages for new features
    • API Call to get the hostname and port number.
    • DBLib on NT/Windows supports directory services-LDAP.
    • TDS 4.x or 5.0
  • Hint: Hint : Move to CTLibrary!!!
ctlibrary
CTLibrary
  • All new feature development and is well supported.
  • Has threaded and non-threaded versions
esql c
ESQL/C
  • All new feature development and is well supported
  • Available on all 32bit platforms
esql cobol
ESQL/Cobol
  • All new feature development and is well supported.
  • ESQL/Cobol available on following platforms Solaris 32HPUX 32AIX 32NT/Windows 32Tru64
slide15
XA
  • All new features and is well supported.
  • Available on Solaris 32, 64HPUX 32AIX 32NT/Windows 32
jconnect
jConnect
  • It consists of jConnect librariesjisqljTDSRibo
  • JDK Versions
    • jConnect 6.0 : JDK 1.4
    • jConnect 5.2/5.5 : JDK 1.2
    • jConnect 4.2/4.5 : JDK 1.1 (Eol’ed )
open server
Open Server
  • All new features and is well supported.
  • Available on all platforms in threaded, non-threaded and smp/pre-empt modes.
open server example
Open Server Example
  • This is an example of how Open Server can be used to read external data (e.g. a datafile, errorlog etc.) with a registered procedure and make the contents/info available in ASE.
  • In the meantime, Open Client application ‘ctwait’ is monitoring the execution of this registered procedure.
  • Example is based on the provided examples: regproc.c, ctwait.c and version.c
slide19

Open Server Example

ASE

isql

execute

MY_OPENSERVER…rp_readfile

rpc call

MY_OPENSERVER

ctwait

Monitors the execution of rp_readfile

and raises a message when this

procedure is being executed

read from ‘datafile’

open server example contd
Open Server Example: (Contd)
  • Open Server program ‘regproc’ is started (‘MY_OPENSERVER’)
  • This Open Server application contains 2 registered procedures:
      • rp_version (returns the Open Server version string)
      • rp_readfile (reads data from a datafile)
  • Open Client program ‘ctwait’ connects to MY_OPENSERVER and monitors the execution of rp_readfile.
  • Open Client application isql connects to an ASE and executes a remote procedure call to the Open Server:
  • execute MY_OPENSERVER…rp_readfile
open server example contd21
Open Server Example: (Contd)
  • Open Server executes this registered procedure, reads data from an external datafile and returns the requested content via ASE to the client.
  • Open Client program ‘ctwait’ is notified by Open Server that the procedure has been executed and raises a message.
open server 12 5 1 performance test
Open Server 12.5.1 Performance Test
  • 4-CPU SPARC running Solaris 8
  • Server is lang sample server
  • Client is firstapp sample client
  • 100000 queries were executed divided equally between clients
  • All queries were short and simple.
slide25

ASE 138 What is new in Sybase Adaptive Server Enterprise Connectivity

Part II – ADO.NET / ODBC / OLEDB

Ashish Mahajan

Development Manager

Sybase Inc.

[email protected]

progress from last year
Progress from last year
  • Windows ODBC / OLEDB 12.5.1 beta
  • Mac ODBC beta
  • Linux ODBC beta
  • Linux ODBC 12.5.1 release
  • ADO.NET v 1.1 release
  • ADO.NET v 1.0 release
  • ADO.NET beta

TechWave,2004

TechWave,2003

ado net data provider
ADO.NET Data Provider
  • Managed provider for .NET applications
  • Supports Microsoft ADO.NET version 1.1
  • Supported on Windows 2003, 2000, NT and XP
  • Ships with OCS SDK 12.5.1 and ASE PC Client 12.5.2
  • Version 1.0 released in Q4 2003
  • Version 1.1 released in Q2 2004
ado net data provider ase features
ADO.NET Data Provider – ASE Features
  • Supports the new data types in ASE 12.5.1
    • DATE
    • TIME
  • Support for “SELECT FOR XML” by using AseCommand.ExecuteXmlReader()
  • LDAP support
  • Encrypted Passwords
  • SSL support
  • HA Failover
ado net feature roadmap
ADO.NET Feature Roadmap
  • ASE 15.0/OCS SDK 15.0 GA – Q2/2005
  • ADO.NET 2.0 compliant
  • Kerberos
  • DTC
  • ASE default packet size
  • Big Int/64bit Integer
  • Unsigned int
  • XML datatype
  • ASE 15.0 Beta , SDK 15.0
  • All previous features plus
  • Unitext datatype
  • Large Identifiers
  • IPv6
  • ADO.NET 1.1
  • SSL
  • LDAP
  • HA Failover
  • Encrypted Passwords
  • All datatypes supported in ASE 12.5.2
  • ASE 15x/OCS SDK 15x , Q4,2005
  • Clusters: Login redirection
  • Clusters: Extended HA failover
  • Clusters: Context migration
  • Clusters: Connection migration

Q2/Q4,2005

Current

Q4,2004

odbc driver
ODBC driver
  • Currently shipping ODBC driver on Windows is an OEM Driver
  • Sybase is introducing an ODBC driver built in house
  • Version 12.5.1 is already shipping on Linux platform
  • Currently in Beta for Mac OS X 10.3 and Windows platforms
  • Applications will need to be migrated to use the Sybase driver
  • Migration:
    • DSN – will need to be reconfigured
    • Possibly Connect Strings will need to be modified
    • Migration as seamless as possible
odbc feature roadmap
ODBC Feature Roadmap
  • ASE 15.0/OCS SDK 15.0 GA – Q2/2005
  • Bundle only in house driver
  • Kerberos
  • DTC
  • ASE default packet size
  • Big Int/64bit Integer
  • Unsigned int
  • XML datatype
  • Async
  • ASE 15.0 Beta , SDK 15.0
  • All previous features plus
  • Scrollable cursors
  • Unitext datatype
  • Large Identifiers
  • IPv6
  • OCS SDK 12.5.1 – ESD#5
  • SDK will include both OEM and in house driver
  • SSL
  • LDAP
  • HA Failover
  • Encrypted Passwords
  • All datatypes supported in ASE 12.5.2
  • ASE 15x/OCS SDK 15x , Q4,2005
  • Clusters: Login redirection
  • Clusters: Extended HA failover
  • Clusters: Context migration
  • Clusters: Connection migration

Q2/Q4,2005

Q3,2004

Q4,2004

oledb data provider
OLEDB Data Provider
  • Currently shipping OLEDB Provider is an OEM Provider
  • Sybase is introducing an OLEDB Provider built in house
  • Currently in Beta
  • Applications will need to be migrated to use the Sybase Provider
  • Migration:
    • Possibly Connect Strings will need to be modified
    • Migration as seamless as possible
oledb feature roadmap
OLEDB Feature Roadmap
  • ASE 15.0/OCS SDK 15.0 GA – Q2/2005
  • Bundle only in house provider
  • Kerberos
  • DTC
  • ASE default packet size
  • Big Int/64bit Integer
  • Unsigned int
  • XML datatype
  • Async
  • ASE 15.0 Beta , SDK 15.0
  • All previous features plus
  • Scrollable cursors
  • Unitext datatype
  • Large Identifiers
  • IPv6
  • OCS SDK 12.5.1 – ESD#5
  • SDK will include both OEM and in house provider
  • SSL
  • LDAP
  • HA Failover
  • Encrypted Passwords
  • All datatypes supported in ASE 12.5.2
  • ASE 15x/OCS SDK 15x , Q4,2005
  • Clusters: Login redirection
  • Clusters: Extended HA failover
  • Clusters: Context migration
  • Clusters: Connection migration

Q2/Q4,2005

Q3,2004

Q4,2004

slide34

ASE 138 What is new in Sybase Adaptive Server Enterprise Connectivity

Feed Back / Q&A

Mani Reddy

Development Manager

Sybase Inc.

[email protected]

Ashish Mahajan

Development Manager

Sybase Inc.

[email protected]

August 15-19, 2004

ad