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

I am still unable to connect via DBI::ODBC->unixODBC->freetds->ASE 15.
Has anyone else had any success with this?  Does anyone have
suggestions as to how to address this?

Thanks,

-Peter

On Wed, Dec 01, 2010 at 05:08:22PM -0500, Peter C. Norton wrote:
> 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
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds