> Problem #11 when using ODBC to connect to a remote database running on MS > SQL Server 2000. > > > > I can connect to the database and run queries using tsql from a terminal > and isql from a root terminal and I can connect using odbc in Gambas2 if > the ide is started from a root terminal but not if started from the > programme shortcut. > > > > I have a small utility to run queries on a SQL server, display the results > and optionally export them as a csv file. As soon as the programme gets to > the line where the query is assigned to a Result the programme crashes with > a #11. This behaviour is identical if running the Database Sample. The > connection is opened. connection.opened is True when tested in debug mode. > The line where the error occurs in the sample is:- > > > > rData = $hConn.Exec(txtRequest.Text) > > > > which is the same as the one in my application where the programme crashes > > > > PUBLIC SUB FillGrid(ctl AS Control, cnn AS Connection, sqlstr AS String) > > DIM datout AS Result, i AS Integer, j AS Integer > > > > datout = cnn.Exec(sqlstr) The line the crash occurs > > > > The version of gambas2 is 2.18.0 > > The kernel is Linux 2.6.31.5-127/fc12.x86_64 > > System is > > Memory 3.8 GiB > > Proc 0 AMD Athlon(tm) X2 Dual Core processor 5200+ > > Proc 1 AMD Athlon(tm) X2 Dual Core processor 5200+ > > > > The query is executed as can be seen from the output from Wireshark > included after the debug output. > > > > Thanks > > > > Tony > > > > Debug data and Wireshark output from running the Database Sample Programme. > > > > [r...@fslserver Database]# cd /usr/share/gambas2/examples/Database/Database > > [r...@fslserver Database]# gbc2 -agt > > OK > > [r...@fslserver Database]# gdb gbx2 > > GNU gdb (GDB) Fedora (7.0-8.fc12) > > Copyright (C) 2009 Free Software Foundation, Inc. > > License GPLv3+: GNU GPL version 3 or later > <http://gnu.org/licenses/gpl.html> > > This is free software: you are free to change and redistribute it. > > There is NO WARRANTY, to the extent permitted by law. Type "show copying" > > and "show warranty" for details. > > This GDB was configured as "x86_64-redhat-linux-gnu". > > For bug reporting instructions, please see: > > <http://www.gnu.org/software/gdb/bugs/>... > > Reading symbols from /usr/bin/gbx2...(no debugging symbols found)...done. > > Missing separate debuginfos, use: debuginfo-install > gambas2-runtime-2.18.0-1.fc12.x86_64 > > (gdb) set args -p > > (gdb) run > > Starting program: /usr/bin/gbx2 -p > > [Thread debugging using libthread_db enabled] > > > > Program received signal SIGSEGV, Segmentation fault. > > 0x0000003b3a27978c in free () from /lib64/libc.so.6 > > (gdb) bt > > #0 0x0000003b3a27978c in free () from /lib64/libc.so.6 > > #1 0x00000000004050f1 in sinh () > > #2 0x00007fffefe013aa in SQLDisconnect () > > from /usr/lib64/gambas2/gb.db.odbc.so > > #3 0x00007fffefe03a28 in ?? () from /usr/lib64/gambas2/gb.db.odbc.so > > #4 0x00007ffff7408da2 in ?? () from /usr/lib64/gambas2/gb.db.so > > #5 0x00007ffff740975f in ?? () from /usr/lib64/gambas2/gb.db.so > > #6 0x00007ffff74063c7 in ?? () from /usr/lib64/gambas2/gb.db.so > > #7 0x0000000000408b32 in sinh () > > #8 0x000000000040952f in sinh () > > #9 0x000000000042eea5 in sinh () > > #10 0x0000000000409cf5 in sinh () > > #11 0x0000000000409fac in sinh () > > #12 0x000000000041c4c9 in sinh () > > #13 0x000000000041ce79 in sinh () > > #14 0x00007ffff797edca in g_io_channel_unref () > > from /usr/lib64/gambas2/gb.gtk.so > > #15 0x000000324020ba8e in g_closure_invoke () from > /lib64/libgobject-2.0.so.0 > > #16 0x0000003240220ec3 in ?? () from /lib64/libgobject-2.0.so.0 > > #17 0x0000003240222259 in g_signal_emit_valist () > > from /lib64/libgobject-2.0.so.0 > > #18 0x00000032402227a3 in g_signal_emit () from /lib64/libgobject-2.0.so.0 > > #19 0x000000324468d615 in ?? () from /usr/lib64/libgtk-x11-2.0.so.0 > > ---Type <return> to continue, or q <return> to quit--- > > #20 0x000000324020ba8e in g_closure_invoke () from > /lib64/libgobject-2.0.so.0 > > #21 0x00000032402207dc in ?? () from /lib64/libgobject-2.0.so.0 > > #22 0x0000003240222259 in g_signal_emit_valist () > > from /lib64/libgobject-2.0.so.0 > > #23 0x00000032402227a3 in g_signal_emit () from /lib64/libgobject-2.0.so.0 > > #24 0x000000324468be77 in ?? () from /usr/lib64/libgtk-x11-2.0.so.0 > > #25 0x0000003244753903 in ?? () from /usr/lib64/libgtk-x11-2.0.so.0 > > #26 0x000000324020ba8e in g_closure_invoke () from > /lib64/libgobject-2.0.so.0 > > #27 0x0000003240220b8d in ?? () from /lib64/libgobject-2.0.so.0 > > #28 0x00000032402220ec in g_signal_emit_valist () > > from /lib64/libgobject-2.0.so.0 > > #29 0x00000032402227a3 in g_signal_emit () from /lib64/libgobject-2.0.so.0 > > #30 0x0000003244875a9f in ?? () from /usr/lib64/libgtk-x11-2.0.so.0 > > #31 0x000000324474a664 in gtk_propagate_event () > > from /usr/lib64/libgtk-x11-2.0.so.0 > > #32 0x000000324474b7a3 in gtk_main_do_event () > > from /usr/lib64/libgtk-x11-2.0.so.0 > > #33 0x00007ffff798c627 in ?? () from /usr/lib64/gambas2/gb.gtk.so > > #34 0x000000324625f7fc in ?? () from /usr/lib64/libgdk-x11-2.0.so.0 > > #35 0x000000323fe3922e in g_main_context_dispatch () > > from /lib64/libglib-2.0.so.0 > > #36 0x000000323fe3cc18 in ?? () from /lib64/libglib-2.0.so.0 > > #37 0x000000323fe3cd3a in g_main_context_iteration () > > ---Type <return> to continue, or q <return> to quit--- > > from /lib64/libglib-2.0.so.0 > > #38 0x000000324474bb1d in gtk_main_iteration_do () > > from /usr/lib64/libgtk-x11-2.0.so.0 > > #39 0x00007ffff798a85a in g_io_channel_unref () > > from /usr/lib64/gambas2/gb.gtk.so > > #40 0x00007ffff798aec9 in ?? () from /usr/lib64/gambas2/gb.gtk.so > > #41 0x0000000000422274 in sinh () > > #42 0x0000003b3a21eb1d in __libc_start_main () from /lib64/libc.so.6 > > #43 0x0000000000403a99 in sinh () > > #44 0x00007fffffffe598 in ?? () > > #45 0x000000000000001c in ?? () > > #46 0x0000000000000002 in ?? () > > #47 0x00000000008548d8 in ?? () > > #48 0x00007fffffffe80f in ?? () > > #49 0x0000000000000000 in ?? () > > >
Can you compile gambas 2 from sources with debugging information enabled? This way you will get a useful backtrace that will tell where exactly the program fails. Thanks in advance. Regards, -- Benoît Minisini ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user