Sybase ASE ADO.NET Data Provider

1
ASE 138 What is new in Sybase Adaptive Server
Enterprise Connectivity
Mani Reddy Development Manager Sybase
Inc. Mani.Reddy_at_sybase.com Ashish
Mahajan Development Manager Sybase
Inc. Ashish.Mahajan_at_sybase.com August 15-19, 2004
2
The Enterprise. Unwired.
3
The Enterprise. Unwired.
Industry and Cross Platform Solutions
Unwire People
Unwire Information
Manage Information

• 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
4
Connectivity Products

• SDK
• Open Server

5
SDK

• Open Client (CTLib, DBLib)
• ESQL/C
• ESQL/Cobol
• XA
• jConnect
• ODBC
• OLEDB
• ADO.NET

6
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

7
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

8
Release 12.5.1

• All features from previous releases (SSL, LDAP
  etc)
• 12.5.1 GA released in Jan04 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
  (ESD1)IPV6 on Solaris32,64 and NT/Windows
  (ESD2)SSLSBGSE support on Solaris 32,64 and
  NT/Windows (ESD2)

9
SDK/Open Server Feature Roadmap

• 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

• OCS 12.5.1 ESD 4 7/2004
• DblibConfig variable for version
• Added diagnostic ( tds tracing)

• ASE 15.0/OCS 15.0 GA Q2/2005.All previous
  features
• XML datatype
• XA64 on HP64, HPIA64,IBM64

• OCS 12.5.1 ESD6 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
10
jConnect Feature Roadmap

• 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 Beta 1, with jConnect 6x Q3, 2004
• Scrollable Cursors
• Unitext datatype

• 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
11
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!!!

12
CTLibrary

• All new feature development and is well
  supported.
• Has threaded and non-threaded versions

13
ESQL/C

• All new feature development and is well supported
• Available on all 32bit platforms

14
ESQL/Cobol

• All new feature development and is well
  supported.
• ESQL/Cobol available on following platforms
  Solaris 32HPUX 32AIX 32NT/Windows 32Tru64

15
XA

• All new features and is well supported.
• Available on Solaris 32, 64HPUX 32AIX
  32NT/Windows 32

16
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 (Eoled )

17
Open Server

• All new features and is well supported.
• Available on all platforms in threaded,
  non-threaded and smp/pre-empt modes.

18
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

19
Open Server Example
ASE
isql
execute MY_OPENSERVERrp_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
20
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_OPENSERVERrp_readfile

21
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.

22
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.

23
Open Server 12.5.1 Performance Chart
24
Open Server 12.5.1 Performance Chart
25
ASE 138 What is new in Sybase Adaptive Server
Enterprise Connectivity Part II ADO.NET / ODBC
/ OLEDB
Ashish Mahajan Development Manager Sybase
Inc. Ashish.Mahajan_at_sybase.com
26
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
27
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

28
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

29
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
30
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

31
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 ESD5
• 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
32
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

33
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 ESD5
• 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
34
ASE 138 What is new in Sybase Adaptive Server
Enterprise Connectivity Feed Back / QA
Mani Reddy Development Manager Sybase
Inc. Mani.Reddy_at_sybase.com Ashish
Mahajan Development Manager Sybase
Inc. Ashish.Mahajan_at_sybase.com August 15-19, 2004