GitLab

Imported from http://bugzilla.roxen.com/bugzilla/show_bug.cgi?id=1885

Reported by Stefan Berndtsson, GU stefan@nocrew.org

Used software:

iODBC v3.0.5 Pike v7.0.345 FreeTDS v0.52-cvssnap (2001-07-17) other end has Microsoft SQL-Server 6.5.

iODBC and FreeTDS seems to work fine. I can get data from the very same query using the sample program in iODBC.

When I try to use Pike in Solaris 7, with the same ODBC, I get:

bash-2.01# pike
Pike v7.0 release 345 running Hilfe v2.0 (Incremental Pike Frontend)
> object db=Sql.sql("odbc://foga/foga");
Result: object
> array result=db->query("select count(*) from regis");
query = select count(*) from regis
exit_res_struct(): Freeing of HSTMT failed:
SQLError failed (3:SQL_NO_DATA_FOUND)
Unknown program: unknown function()
-:1: ___Foo4711()
>

The very same versions of all parts in Linux on a PowerPC:

$ pike
Pike v7.0 release 345 running Hilfe v2.0 (Incremental Pike Frontend)
> object db=Sql.sql("odbc://foga/foga");
Result: object
> array result=db->query("select count(*) from regis");
query = select count(*) from regis
Result: ({ /* 1 element */
            ([ /* 2 elements */
              "":"11540",
              ".":"11540"
            ])
        })
>

The odbc.ini and odbcinst.ini are identical between the systems (copied over).