Re: Connecting to Sybase with perl+DBI::ODBC results in an error?

On Wed, Dec 01, 2010 at 02:56:26PM -0500, Peter C. Norton wrote:
> Stranger and stranger.  It looks like if I take out the autocommit
> attribute from the DBI module, and from the post-connection function
> in DBD::ODBC, the prepare() function in DBD::ODBC will come back with
> an error:
> 
> odbc.c:5834:SQLGetInfo(0x150a62c0, 6, 0x14f3d340, 80, 0x7fff0176ae0e)
> odbc.c:5088:_SQLGetInfo(0x150a62c0, 6, 0x14f3d340, 80, 0x7fff0176ae0e)
> odbc.c:5834:SQLGetInfo(0x150a62c0, 7, 0x14f3d390, 20, 0x7fff0176ae0e)
> odbc.c:5088:_SQLGetInfo(0x150a62c0, 7, 0x14f3d390, 20, 0x7fff0176ae0e)
> error.c:517:SQLGetDiagRec(2, 0x150a62c0, 1, 0x7fff0176ab80, 0x7fff0176ab9c, 0x7fff0176a980, 512, 0x7fff0176ab98)
> error.c:517:SQLGetDiagRec(2, 0x150a62c0, 1, 0x7fff0176abf0, 0x7fff0176ac0c, 0x7fff0176a9f0, 512, 0x7fff0176ac08)
> odbc.c:5834:SQLGetInfo(0x150a62c0, 17, 0x14f3d3a4, 80, 0x7fff0176ae0e)
> odbc.c:5088:_SQLGetInfo(0x150a62c0, 17, 0x14f3d3a4, 80, 0x7fff0176ae0e)

Assuming this is the error here, it seems clear that the fInfoType of
7 is a problem.  The only definition that's set to the value of 7 in
unixODBC's sql.h is:

(sql.h line 131 in unixODBC-2.3.0):
#define SQL_DIAG_CALL					7

but that doesn't look correct, as it's defined in the dynamic function
codes.  There don't seem to be any relevant values defined in the area
below this comment:

/* Information requested by SQLGetInfo() */

in sql.h.  Before I go too much deeper into this, is anyone else
trying to use this stack:

perl DBD::ODBC->perl DBI->unixODBC or iODBC->FreeTDS->Sybase ASE 15.

???

This only seems to fail on ASE 15.  I've tested this and it is working
with both MSSQL 2005 and Sybase ASE 12.5

Thanks,

-Peter