Sybase IQ includes support for a variety of programming languages and interfaces that you can use to build and deploy database applications. Documentation for these drivers is available in the SQL Anywhere Server - Programming Guide.
Sybase IQ .NET support is provided by the SQL Anywhere.NET Data Provider. The SQL Anywhere .NET Data Provider provides native access to Sybase IQ databases in the Microsoft .NET Framework. Code samples are located in the %ALLUSERSPROFILE%\SybaseIQ\samples\SQLAnywhere\ADO.NET directory on Windows.
Additional information about the SQL Anywhere .NET Data Provider is available on the Web. See SQL Anywhere .NET Data Provider on Sybase Infocenter for more information.
Sybase IQ OLE DB and ADO development is provided by the SQL Anywhere OLE DB provider. The SQL Anywhere OLE DB provider gives you full access to Sybase IQ features in an ADO programming environment. Code samples are located in the %ALLUSERSPROFILE%\SybaseIQ\samples\SQLAnywhere\VBSampler directory.
Additional information about the SQL Anywhere OLE DB Provider is available on the Web. See SQL Anywhere OLE DB and ADO development on Sybase Infocenter for more information.
Sybase IQ Perl scripting support is provided by the SQL Anywhere Perl DBD::SQLAnywhere DBI module. The DBD::SQLAnywhere interface provides access to Sybase IQ databases from scripts written in Perl.
Additional information about the SQL Anywhere Perl DBD::SQLAnywhere DBI module is available on the Web. See SQL Anywhere Perl DBD::SQLAnywhere DBI module on Sybase Infocenter for more information.
Sybase IQ Python Database support is provided by the sqlanydb interface. The sqlanydb interface provides access to Sybase IQ databases from Python scripts that conform to the Python Database API specification, v 2.0.
Sybase does not currently certify the Sybase IQ Python driver on HP-UXi64, AIX64 and SunOS64. Certification of these platforms for the Sybase IQ Python driver is planned for a later release.
Additional information about SQL Anywhere Python Database Support is available on the Web. See SQL Anywhere Python Database support on Sybase Infocenter for more information.
Sybase IQ PHP API support is provided by the SQL Anywhere PHP module, operating-system-specific binaries, and PHP source code that provide access to Sybase IQ databases.
Additional information about SQL Anywhere PHP module is available on the Web. See SQL Anywhere PHP APIon Sybase Infocenter for more information.
Platform |
ADO.NET |
OLEDB |
Perl |
Php |
Python |
|---|---|---|---|---|---|
Win32 |
Installed |
Installed |
Source shipped |
Binaries and source |
Driver shipped |
Win64 |
Installed |
Installed |
Source shipped |
32 bit binaries and source |
Driver shipped |
AIX-64 |
N/A |
N/A |
Source shipped |
Source shipped |
Driver shipped |
HPi-64 |
N/A |
N/A |
Source shipped |
Source shipped |
Driver shipped |
Linux64 (x64) |
N/A |
N/A |
Source shipped |
Binaries and source |
Driver shipped |
Linux64 (IBM) |
N/A |
N/A |
Source shipped |
Source shipped |
Driver shipped |
Sun64 Sparc |
N/A |
N/A |
Source shipped |
Binaries and source |
Driver shipped |
Sun64 (x64) |
N/A |
N/A |
Source shipped |
Binaries and source |
Driver shipped |
Source code, sample projects, and OS-specific binaries for Perl, Python, and PHP are installed in the %IQDIR15%\SDK directory on Windows or $IQDIR15/sdk directory on UNIX. ADO.NET and OLEDB code samples are in the appropriate %ALLUSERSPROFILE%\SybaseIQ\samples\SQLAnywhere folder.
Sample projects that ship with these drivers use the Sybase IQ sample database (iqdemo.db), not the SQL Anywhere sample database (demo.db). The ODBC data source name for iqdemo.db is Sybase IQ Demo. See the Sybase IQ Quick Start Guide.
To compile the drivers to run in a 64-bit Windows environment, see How to: Enable a 64-Bit Visual C++ Toolset at the Command Line.
