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: Thu, 9 Dec 2010 13:53:00 -0500

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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page