238 lines
4.7 KiB
HTML
238 lines
4.7 KiB
HTML
<HTML
|
|
><HEAD
|
|
><TITLE
|
|
>Languages for connecting to ASE</TITLE
|
|
><META
|
|
NAME="GENERATOR"
|
|
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
|
|
REL="HOME"
|
|
TITLE="Sybase Adaptive Server Enterprise / SQL Server HOWTO"
|
|
HREF="index.html"><LINK
|
|
REL="PREVIOUS"
|
|
TITLE="ASE Architecture: Observing the Server"
|
|
HREF="architecture.html"><LINK
|
|
REL="NEXT"
|
|
TITLE="Technical Resources"
|
|
HREF="resources.html"></HEAD
|
|
><BODY
|
|
CLASS="appendix"
|
|
BGCOLOR="#FFFFFF"
|
|
TEXT="#000000"
|
|
LINK="#0000FF"
|
|
VLINK="#840084"
|
|
ALINK="#0000FF"
|
|
><DIV
|
|
CLASS="NAVHEADER"
|
|
><TABLE
|
|
SUMMARY="Header navigation table"
|
|
WIDTH="100%"
|
|
BORDER="0"
|
|
CELLPADDING="0"
|
|
CELLSPACING="0"
|
|
><TR
|
|
><TH
|
|
COLSPAN="3"
|
|
ALIGN="center"
|
|
>Sybase Adaptive Server Enterprise / SQL Server HOWTO</TH
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="10%"
|
|
ALIGN="left"
|
|
VALIGN="bottom"
|
|
><A
|
|
HREF="architecture.html"
|
|
ACCESSKEY="P"
|
|
>Prev</A
|
|
></TD
|
|
><TD
|
|
WIDTH="80%"
|
|
ALIGN="center"
|
|
VALIGN="bottom"
|
|
></TD
|
|
><TD
|
|
WIDTH="10%"
|
|
ALIGN="right"
|
|
VALIGN="bottom"
|
|
><A
|
|
HREF="resources.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
></TABLE
|
|
><HR
|
|
ALIGN="LEFT"
|
|
WIDTH="100%"></DIV
|
|
><DIV
|
|
CLASS="appendix"
|
|
><H1
|
|
CLASS="appendix"
|
|
><A
|
|
NAME="lang"
|
|
></A
|
|
>A. Languages for connecting to ASE</H1
|
|
><P
|
|
> You can connect to ASE and perform SQL commands in all common computer languages.
|
|
<P
|
|
></P
|
|
><UL
|
|
><LI
|
|
><P
|
|
> C / C++
|
|
</P
|
|
><P
|
|
> Sybase provides client development libraries under the name of Open Client Developer's Kit which is included in their SDK. There is also an Embedded SQL/C precompiler which enables you to add SQL code to your C programs
|
|
</P
|
|
><P
|
|
> If you prefer to use free / open source products, there is the FreeTDS project at <A
|
|
HREF="http://www.freetds.org/"
|
|
TARGET="_top"
|
|
>http://www.freetds.org/</A
|
|
>. This is a re-implementation of Sybase's Tabular Data Stream (TDS), used for the client-server communication.
|
|
</P
|
|
><P
|
|
> Note that Microsoft has modified their SQL Server TDS dialect from their Sybase legacy and you are no longer guaranteed that Microsoft SQL Server clients can communicate with a Sybase server or vice versa. MS SQL Server 6.5 came with a patch to enable Sybase TDS compatibility, later versions (7.0, 2000) do not support the Sybase communication protocol.
|
|
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
> Java / JDBC
|
|
</P
|
|
><P
|
|
> Sybase ships the jConnect JDBC driver with ASE for Linux in ASE 12.5.0.x and up. There are both JDBC 1.0 and 2.0 implementations, labeled as jConnect 4.x and 5.x respectively. These are Type 4 JDBC drivers, which means they are 100% Java implementations of the TDS protocol.
|
|
</P
|
|
><P
|
|
> The FreeTDS project mentioned above also ships a JDBC driver.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
> ODBC
|
|
</P
|
|
><P
|
|
>For Windows clients, the ODBC drivers are shipped on the "PC Client CD". This used to be a ODBC layer on top of the Open Client runtime libaries, but are being modified to speak TDS directly instead.
|
|
</P
|
|
><P
|
|
> There is also an ODBC driver available from FreeTDS. Unfortunately, it appears there is no unixODBC (<A
|
|
HREF="http://www.unixodbc.org/"
|
|
TARGET="_top"
|
|
>http://www.unixodbc.org/</A
|
|
>) driver available yet.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Perl
|
|
</P
|
|
><P
|
|
> You can use any of DBD::Sybase, DBD::ODBC, DBD::FreeTDS or Sybperl with the FreeTDS libraries. These modules are available from CPAN. You can find lots of details from Michael Peppler's site, <A
|
|
HREF="http://www.mbay.net/~mpeppler/"
|
|
TARGET="_top"
|
|
>http://www.mbay.net/~mpeppler/</A
|
|
>.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
>Python
|
|
</P
|
|
><P
|
|
> A Python module for connecting to ASE (and documentation for it) can be downloaded from
|
|
<A
|
|
HREF="http://www.object-craft.com.au/projects/sybase/"
|
|
TARGET="_top"
|
|
>http://www.object-craft.com.au/projects/sybase/</A
|
|
>
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
> PHP
|
|
</P
|
|
><P
|
|
> PHP includes Sybase connectivity, based on the Open Client libraries. The PHP manual shows examples on connecting to an ASE server, sending queries and handling the result sets. See <A
|
|
HREF="http://www.php.net/"
|
|
TARGET="_top"
|
|
>http://www.php.net/</A
|
|
>.
|
|
</P
|
|
></LI
|
|
><LI
|
|
><P
|
|
> Tcl
|
|
</P
|
|
><P
|
|
> An extension for connecting to ASE from tcl is available from <A
|
|
HREF="http://www.nyx.net/~tpoindex/tcl.html"
|
|
TARGET="_top"
|
|
>http://www.nyx.net/~tpoindex/tcl.html</A
|
|
>
|
|
</P
|
|
></LI
|
|
></UL
|
|
>
|
|
</P
|
|
></DIV
|
|
><DIV
|
|
CLASS="NAVFOOTER"
|
|
><HR
|
|
ALIGN="LEFT"
|
|
WIDTH="100%"><TABLE
|
|
SUMMARY="Footer navigation table"
|
|
WIDTH="100%"
|
|
BORDER="0"
|
|
CELLPADDING="0"
|
|
CELLSPACING="0"
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
><A
|
|
HREF="architecture.html"
|
|
ACCESSKEY="P"
|
|
>Prev</A
|
|
></TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
><A
|
|
HREF="index.html"
|
|
ACCESSKEY="H"
|
|
>Home</A
|
|
></TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
><A
|
|
HREF="resources.html"
|
|
ACCESSKEY="N"
|
|
>Next</A
|
|
></TD
|
|
></TR
|
|
><TR
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="left"
|
|
VALIGN="top"
|
|
>ASE Architecture: Observing the Server</TD
|
|
><TD
|
|
WIDTH="34%"
|
|
ALIGN="center"
|
|
VALIGN="top"
|
|
> </TD
|
|
><TD
|
|
WIDTH="33%"
|
|
ALIGN="right"
|
|
VALIGN="top"
|
|
>Technical Resources</TD
|
|
></TR
|
|
></TABLE
|
|
></DIV
|
|
></BODY
|
|
></HTML
|
|
> |