Re: Issue installing Octave-forge database-1.0.4

[Stuart Edwards]

On Dec 8, 2011, at 11:39 AM, James Gallogly wrote:

> Hello,
> I am trying to install the database package on Octave 3.2.4 and I get a lot 
> of errors.
> 
> A google search indicates this issue has exisisted for several years. Is this 
> package no longer maintained and thus no longer installable or is there 
> something I cam doing wrong?
> 
> 
> Below is the output.
> 
> Thanks for any help.
> 
> octave-3.2.4.exe:5> pkg install database-1.0.4.tar.gz
> warning: creating installation directory 
> C:\Octave\3.2.4_gcc-4.4.0\share\octave\
> packages
> odbc_wrap.cpp: In member function 'void octave_swig_type::install_global()':
> odbc_wrap.cpp:1197: error: 'curr_sym_tab' was not declared in this scope
> odbc_wrap.cpp:1197: error: 'link_to_global_variable' was not declared in this 
> sc
> ope
> odbc_wrap.cpp:1204: error: 'symbol_record' was not declared in this scope
> odbc_wrap.cpp:1204: error: 'sr' was not declared in this scope
> odbc_wrap.cpp:1204: error: 'global_sym_tab' was not declared in this scope
> odbc_wrap.cpp: In function 'void SWIG_Octave_SetModule(void*, 
> swig_module_info*)
> ':
> odbc_wrap.cpp:2110: error: 'curr_sym_tab' was not declared in this scope
> odbc_wrap.cpp:2110: error: 'link_to_global_variable' was not declared in this 
> sc
> ope
> odbc_wrap.cpp: In function 'SQLRETURN SQLGetData(void*, SQLUSMALLINT, 
> std::strin
> g*, SQLINTEGER*)':
> odbc_wrap.cpp:2429: warning: comparison between signed and unsigned integer 
> expr
> essions
> odbc_wrap.cpp:2431: warning: comparison between signed and unsigned integer 
> expr
> essions
> odbc_wrap.cpp: In function 'octave_value_list _wrap_SQLExtendedFetch(const 
> octav
> e_value_list&, int)':
> odbc_wrap.cpp:5287: error: 'SQLROWSETSIZE' was not declared in this scope
> odbc_wrap.cpp:5287: error: 'arg4' was not declared in this scope
> odbc_wrap.cpp:5287: error: expected primary-expression before ')' token
> odbc_wrap.cpp:5287: error: expected ';' before numeric constant
> odbc_wrap.cpp:5324: error: expected primary-expression before ')' token
> odbc_wrap.cpp: In function 'octave_value_list Fodbc(const octave_value_list&, 
> in
> t)':
> odbc_wrap.cpp:9826: error: 'curr_sym_tab' was not declared in this scope
> odbc_wrap.cpp:9826: error: 'link_to_global_variable' was not declared in this 
> sc
> ope
> odbc_wrap.cpp: At global scope:
> odbc_wrap.cpp:853: warning: 'void 
> Swig::swig_register_director(octave_swig_type*
> , void*, Swig::Director*)' declared 'static' but never defined
> mingw32-g++-4.4.0-dw2: odbc_wrap.o: No such file or directory
> make: *** [odbc.oct] Error 1
> 'make' returned the following error: make: Entering directory 
> `/tmp/oct-2/databa
> se-1.0.4/src'
> CXXFLAGS="-D_GLIBCXX_DLL -march=i686 -mtune=generic -O3 -Wall" mkoctfile 
> -DHAVE_
> OCTAVE_32 -v -o odbc.oct -lodbc32 odbc_wrap.cpp
> mingw32-g++-4.4.0-dw2 -c -I/usr/local/octmgw32_gcc-4.4.0-dw2/include  
> -Ic:\Octav
> e\3.2.4_gcc-4.4.0\include\octave-3.2.4 
> -Ic:\Octave\3.2.4_gcc-4.4.0\include\octav
> e-3.2.4\octave -Ic:\Octave\3.2.4_gcc-4.4.0\include -mieee-fp  -D_GLIBCXX_DLL 
> -ma
> rch=i686 -mtune=generic -O3 -Wall    -DHAVE_OCTAVE_32 odbc_wrap.cpp -o 
> odbc_wrap
> .o
> mingw32-g++-4.4.0-dw2 -shared -Wl,--export-all-symbols 
> -Wl,--enable-auto-import
> -Wl,--enable-runtime-pseudo-reloc -shared-libgcc 
> -Wl,--allow-multiple-definition
>  -o odbc.oct  odbc_wrap.o   -lodbc32 
> -Lc:\Octave\3.2.4_gcc-4.4.0\lib\octave-3.2
> .4 -Lc:\Octave\3.2.4_gcc-4.4.0\lib -loctinterp -loctave  -lcruft 
> -shared-libgcc
> -Wl,--allow-multiple-definition -llapack -lblas -lfftw3 -lfftw3f -lreadline  
> -ln
> curses -liberty -lhdf5 -lz -lm  -lgdi32 -lws2_32 -luser32 -lkernel32 
> -lgfortran
> -lstdc++_s
> make: Leaving directory `/tmp/oct-2/database-1.0.4/src'
> error: called from `pkg>configure_make' in file 
> C:\Octave\3.2.4_gcc-4.4.0\share\
> octave\3.2.4\m\pkg\pkg.m near line 1253, column 2
> error: called from:
> error:   C:\Octave\3.2.4_gcc-4.4.0\share\octave\3.2.4\m\pkg\pkg.m at line 
> 714, c
> olumn 5
> error:   C:\Octave\3.2.4_gcc-4.4.0\share\octave\3.2.4\m\pkg\pkg.m at line 
> 287, c
> olumn 7
> octave-3.2.4.exe:5> list
> warning: list objects are deprecated; use cell arrays instead
> ans = ()
> 
> _______________________________________________
> Help-octave mailing list
> address@hidden
> https://mailman.cae.wisc.edu/listinfo/help-octave

I ran into this some months ago and could not resolve the problem.  I tried to 
contact the maintainer but received no reply.
There's another package called osdbi that is released under the BSD license 
that I was able to make work, but only for sqlite3.
You can find it here:
http://jriedy.users.sonic.net/cgi/jriedy/cgit/cgit.cgi/osdbi/tree/doc/osdbi.texi
JRiedy the author will answer emails.  I use it on OS X 10.6 and octave 3.4.0.  
Also on 10.5.8 but no luck on 10.7 
Let me know if you run into problems - 

Stu