Skip to Content
Author's profile photo Former Member

ASE Software Developer Kit 15.7: Brief Introduction

I support the ASE Software Developer Kit (SDK) 15.7.  I’ve worked with the products for over 17 years, mostly the Windows drivers, and lots of time spent with the Open Client products. This introduction is just a very high level, simplistic listing of the products and platforms supported. I’ve written quite a lot of articles in the ISUG Technical Journal about the drivers and open client. Most of this stuff is related to programming and mostly at the beginner level.

You will see me here from time to time. I am not sure yet what the content will be about, but if you have suggestions on what you’d like to see I would like to hear from you, via the comments section.

This suite is composed of:

Open Client:

——————

Client Library – C API to access ASE.

DB Library – Older C API to access ASE.

ESQL (cpre and cobpre – embedded SQL in cobol and c)

bcp – bulk copy utility

isql – interactive SQL to test connections, perform admin work on ASE, test SQL

perl module to access ASE (uses Client Library in between perl and ASE)

php module (client lib in between php and ASE)

python module (client lib in between python and ASE)

Drivers:

—————

ODBC Driver – to Access ASE via ODBC API

OLE DB Provider – access ASE via OLE DB API (C/C++, Microsoft canned interfaces such as Linked server, SSIS)

ADO.NET Data Provider – Access ASE from .NET Framework using ADO.NET API, 2,0 .NET  and 4.0 .NET

The SDK is available on the following platforms – please note, only ODBC Drivers are available (from the Drivers) on Linux and UNIX and only on (I will verify this – the certification page will indicate the versions of OS):

 

hpia64

HP Itanium HP-UX 11.31 and 11.23

ibmaix64

AIX 5.3 and 6.1

•ibmplinux64

Redhat EL 4, 5, SuSE SLES 10, 11

linuxamd64

Redhat EL 4, 5, SuSE SLES 10, 11

sunsparc64

2.9, 2.10

sunx64

Solaris 10

For the ASE Drivers on Windows – support is for both 32-bit (x86) and 64-bit (x64).

SDK 15.7 in general is avialable on:

HP-UX Itanium (32 and 64-bit)

IBM AIX (32 and 64-bit)

Linux on POWER (32 and 64-bit)

Linux x86

Linux x86-64

Sun Solaris SPARC (32 and 64-bit)

Sun Solaris x64

Sun Solaris x86

Windows x64

Windows x86

The SDK is geared mostly for the developer but also third party products can use the products based on supportability.

I will write in this blog from time to time to provide information relevant to all sorts of topics related to SDK 15.7.

Assigned Tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Remi ASTIER
      Remi ASTIER

      Hello, could you provide the documentation for jTDS3.jar ?

      An internal link would suffice.

      Thank you.

      Regards,

      Remi.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Remi,

      There is no documented API available for jTDS3.jar.  It is primarily used by SAP Sybase products where it can act as a server to TDS clients. It was easier to package the jar with the jConnect product so server products can access it. If you're working with JDBC the focus is on the jconn4.jar JDBC driver (jConnect 7.0) found under the %SYBASE%\jConnect-7_0. Documentation for the driver is found

      http://infocenter.sybase.com/help/topic/com.sybase.infocenter.help.jconnjdbc.7.0.7/title.htm

      Eventually the link might change to an SAP specific url but for now this is the current documentation.

      Let me know if this helps or not.

      Cheers,

      -Paul

      Author's profile photo Former Member
      Former Member

      Thanks, Looking forward to more on this topic.

      warm regards,

      sudhir

      Author's profile photo Jose Torres
      Jose Torres

      Hi Paul,

      Is there any URL for SDK certifications(like former Sybase certifications page)?.

      I'm looking for SDK 12.5.1 (32/64bit, obsolete I guess)   and SDK 15.7(32/64bit) certifications on Sun Sparc Solaris 11.x - 64bit

      Thank you

      Regards

      Jose

      Author's profile photo Remi ASTIER
      Remi ASTIER

      Ola Jose

      https://apps.support.sap.com/sap/support/pam

      It's called the Product Availability Matrix (PAM).

      Author's profile photo Jose Torres
      Jose Torres

      Gracias Remi, Found it!

      But it says nothing regarding eventual OS patches required , etc. Do you have further info on this?

      Regards

      Jose

      Author's profile photo Remi ASTIER
      Remi ASTIER
      Author's profile photo Jose Torres
      Jose Torres

      Thanks, this is what's in there:

      Software Developer's Kit 15.7 > Software Developer's Kit Release Bulletin Sun Solaris >

      Product summary

      Release Bulletin Software Developer’s Kit 15.7 for Solaris

      Patches

      The required patch for Solaris SPARC 32-bit and 64-bit is:

      141414-10 or later

      It isn't clear ( for me )if they apply to Solaris 10 or 11

      Regards

      Jose

      Author's profile photo Former Member
      Former Member

      Thanks

      Do you have a roadmap on what features are being implemented in forthcoming versions that might be of interest to the developers

      Mike

      Author's profile photo Jose Torres
      Jose Torres

      HI Mike,

      No, but it'd be great to have one. We're in the process of migrating to 15.7 from 12.5.x

      ( both ASE and Open Client apps )

      Thank you

      Regards

      Jose

      Author's profile photo Dawn Kim
      Dawn Kim

      Hi,

      The features are always listed.
      So when there is a new book on the site like so it will list all the new features of that version.
      ref: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc20155.1570127/doc/html/title.html

      Forthcoming stuff can always be discussed. If there are features or things you would like to see please post it. Start a new discussion in the SCN and I will see about doing feature requests for the product.

      Thanks,
      Dawn Kim

      Author's profile photo Former Member
      Former Member

      Here's a quick list of what would we need here (Won't start a new thread as I've already posted them in the past)

      - ability to reset a connection when using connection pools. (ie drop all temp connections, reset dbsettings, etc)  How are you meant to use conection pools when you can't guarantee the state of the connection ?

      - no buffering on print statements from the server - so long running batch processes are logged during the the run (we use MONO drivers for batch processing)

      - ability to pass C# arrarys or lists into a stored procedure or some method of bulk data to a db (like MS-SQL)

      - improved error processing when using multiple results set - exception are disabled when using  IgnoreErrorsIfRS Pending

      Author's profile photo Jose Torres
      Jose Torres

      Mike, Thank you very much for the tips !

      Regards

      Jose

      Author's profile photo Jose Torres
      Jose Torres

      Hi Dawn,

      I've looked at user manuals for SDK and OS, PAM,etc and only found generic references like : Solaris 11,Solaris SPARC 64-bit, Solaris x86 32-bit but no references to specific  product ESD# levels, OS patches like the former Sybase certification page.

      Thank you for the help

      Regards

      Jose

      Author's profile photo Dawn Kim
      Dawn Kim

      Try this page it is fairly good but it is not update on the certified OS: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36841.1570/html/ocsinst/CHDBHEEC.htm
      We miss the old page too.
      We are trying to pull some of the information from the database the from that old stuff.
      So all the Sybase products are trying to do something like that on the WIKI pages:
      ASE has this page: http://wiki.scn.sap.com/x/MIRG.

      I don't have one for the Connectivity page. Someone was working on this project but are leaving so it won't get done. When I get time I will see what I can do.

      Thanks,
      Dawn Kim

      Author's profile photo Jose Torres
      Jose Torres

      Dawn,

      Very appreciated for the help. Thanks!

      Regards

      Jose