ODBC fails in Solaris 7
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).