Skip to Content.
Sympa Menu

freetds - Re: [freetds] Connecting to Sybase with perl+DBI::ODBC results in an error?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Peter C. Norton" <spacey-freetds.org AT ssr.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Connecting to Sybase with perl+DBI::ODBC results in an error?
  • Date: Wed, 1 Dec 2010 17:08:22 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page