Sybase support for ado.net, ole db, and odbc – Sybase 15.0.2 User Manual

Page 24

Advertising
background image

Product descriptions and directory layout

10

Adaptive Server Enterprise

Sybase support for ADO.NET, OLE DB, and ODBC

Adaptive Server version 15.0.2 contained new ODBC and OLE DB drivers
developed by Sybase. The third-party rebranded ODBC and OLE DB Driver
Kits included with previous versions are no longer shipped.

The retired ODBC Driver Kit was installed in %SYBASE%\ODBC, and
registered with the ODBC Driver Manager as “Sybase ASE ODBC Driver”.
The new ASE ODBC Driver by Sybase is installed in
%SYBASE%\DataAccess\ODBC, and registered as “Adaptive Server
Enterprise”. The version shipping with Adaptive Server and SDK 15.0 is
version 15.0.0.50.

The retired OLE DB Driver Kit was installed in %SYBASE%\OLEDB, and
used the provider short name of “Sybase.ASEOLEDBProvider” and the long
name of “Sybase ASE OLE DB Provider”. The new ASE OLE DB Provider by
Sybase is installed in %SYBASE%\DataAccess\OLEDB, and uses provider
short name “ASEOLEDB”. The version shipping with SDK 15.0 is version
15.0.0.51.

Sybase recommends that you start your migration process the new ODBC and
OLE DB drivers as soon as possible. New features introduced in Adaptive
Server 15.0 are supported only by the new drivers.

See “New Features for OpenServer 15.0 and SDK 15.0 for Windows, Linux
and UNIX”, for instructions on migrating to the new drivers.

Interactive SQL

Interactive SQL is a GUI tool that allows you to execute SQL statements, build
scripts, and display data from Adaptive Server. It is installed into the DBISQL
directory.

Unified Agent

Unified Agent is a management framework that provides runtime services to
manage, monitor, and control distributed Sybase resources. Agents plug into the
framework and provide the ability to manage specific components. It is installed into
the new UA directory $SYBASE/UAF-2_0.

jutils-2_0

A collection of Adaptive Server utility programs including:

jisql

– a JDBC-based GUI

isql

tool.

ribo

– a tool to trace TDS traffic between client program and Adaptive Server.

jConnect

Installed into the jConnect-6_0 directory. Provides a Java Database Connectivity
(JDBC) driver for Adaptive Server.

Product

Description

Advertising