[Gambas-user] Gambas3: error with ODBC
Leonardo Miliani
leonardo at ...1237...
Wed May 26 10:49:32 CEST 2010
Il giorno lun, 24/05/2010 alle 15.20 +0200, Benoît Minisini ha scritto:
> > Il giorno ven, 21/05/2010 alle 13.23 +0200, Benoît Minisini ha scritto:
> > > > Il giorno sab, 15/05/2010 alle 23.13 +0200, Benoît Minisini ha scritto:
> > > > > > Gambas 3, 64 bit version.
> > > > > > During the connection setup with an ODBC database everything goes
> > > > > > right, but when I try to exec a query with Connectin.Exec, Gambas
> > > > > > crashes with #11 error.
> > > > >
> > > > > Can you get a backtrace with gdb? And better get an output of running
> > > > > your project inside valgrind?
> > > >
> > > > Program received signal SIGSEGV, Segmentation fault.
> > > > 0x00007ffff722cdfd in free () from /lib/libc.so.6
> > >
> > > That is not very useful!
> > >
> > > Read the "Reporting a problem" page on the web site to see how to get a
> > > backtrage.
> > >
> > > Regards,
> >
> > Sorry but I'm an intermediate.... I am not the person who has the error.
> > I'm making the report so I write what I receive ;-)
> >
> > Here is the complete (I hope...) report:
> > GNU gdb (GDB) 7.1-ubuntu
> > Copyright (C) 2010 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-linux-gnu".
> > For bug reporting instructions, please see:
> > <http://www.gnu.org/software/gdb/bugs/>...
> > Reading symbols from /usr/local/bin/gbx3...done.
> > (gdb) set args -p
> > (gdb) run
> > Starting program: /usr/local/bin/gbx3 -p
> > [Thread debugging using libthread_db enabled]
> > QInotifyFileSystemWatcherEngine::addPaths: inotify_add_watch failed:
> > Nessun file o directory
> > [New Thread 0x7fffe9c98710 (LWP 1859)]
> > QFileSystemWatcher: failed to add paths: /home/paolo/.config/ibus/bus
> > Bus::open: Can not get ibus-daemon's address.
> > IBusInputContext::createInputContext: no connection to ibus-daemon
> >
> > Program received signal SIGSEGV, Segmentation fault.
> > 0x00007ffff722cdfd in free () from /lib/libc.so.6
> > (gdb) bt
> > #0 0x00007ffff722cdfd in free () from /lib/libc.so.6
> > #1 0x0000000000419187 in GB_Free (addr=0x7fffffffc4ec) at
> > gbx_api.c:1444
> > #2 0x00007ffff12cefba in my_free (desc=0x9a4510, db=0x9a44c8) at
> > main.c:117
> > #3 open_database (desc=0x9a4510, db=0x9a44c8) at main.c:532
> > #4 0x00007ffff14d75bc in DB_Open (desc=0x9a4510, driver=0x9a44c0,
> > db=0x9a44c8)
> > at main.c:209
> > #5 0x00007ffff14d7b45 in open_connection (_object=0x9a44b0)
> > at CConnection.c:81
> > #6 check_opened (_object=0x9a44b0) at CConnection.c:89
> > #7 0x00007ffff14d826d in CCONNECTION_exec (_object=0x9a44b0,
> > _param=0x651db0)
> > at CConnection.c:432
> > #8 0x0000000000407d7d in EXEC_call_native (exec=0xa56370,
> > object=0x9a451000a08230, type=140737239627200, param=0x422f0)
> > at gbx_exec.c:979
> > #9 0x00000000004089cd in EXEC_native () at gbx_exec.c:1185
> > #10 0x0000000000429fc1 in EXEC_loop () at gbx_exec_loop.c:982
> > #11 0x0000000000409521 in EXEC_function_loop () at gbx_exec.c:795
> > #12 0x00000000004098db in EXEC_function_real () at gbx_exec.c:782
> > #13 0x0000000000419839 in raise_event (observer=<value optimized out>,
> > object=<value optimized out>, func_id=<value optimized out>,
> > nparam=271088)
> > at gbx_api.c:483
> > #14 0x0000000000419fc2 in GB_Raise (object=0x96c9b0,
> > event_id=<value optimized out>, nparam=0) at gbx_api.c:585
> > #15 0x00007ffff6d4400d in CButton::clicked (this=<value optimized out>)
> > at CButton.cpp:692
> > #16 0x00007ffff6d43cf2 in CButton::qt_metacall (this=0x7ffff6fa5910,
> > _c=QMetaObject::InvokeMetaMethod, _id=0, _a=<value optimized out>)
> > at CButton_moc.cpp:173
> > #17 0x00007ffff5082e3f in QMetaObject::activate(QObject*, QMetaObject
> > const*, int, void**) () from /usr/lib/libQtCore.so.4
> > #18 0x00007ffff5bde5f2 in QAbstractButton::clicked(bool) ()
> > from /usr/lib/libQtGui.so.4
> > ---Type <return> to continue, or q <return> to quit---
> > #19 0x00007ffff58f886b in ?? () from /usr/lib/libQtGui.so.4
> > #20 0x00007ffff58f970b in ?? () from /usr/lib/libQtGui.so.4
> > #21 0x00007ffff58f997c in
> > QAbstractButton::mouseReleaseEvent(QMouseEvent*) ()
> > from /usr/lib/libQtGui.so.4
> > #22 0x00007ffff5599582 in QWidget::event(QEvent*) ()
> > from /usr/lib/libQtGui.so.4
> > #23 0x00007ffff554322c in QApplicationPrivate::notify_helper(QObject*,
> > QEvent*)
> > () from /usr/lib/libQtGui.so.4
> > #24 0x00007ffff5549ecb in QApplication::notify(QObject*, QEvent*) ()
> > from /usr/lib/libQtGui.so.4
> > #25 0x00007ffff507006c in QCoreApplication::notifyInternal(QObject*,
> > QEvent*)
> > () from /usr/lib/libQtCore.so.4
> > #26 0x00007ffff55490ae in QApplicationPrivate::sendMouseEvent(QWidget*,
> > QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool)
> > ()
> > from /usr/lib/libQtGui.so.4
> > #27 0x00007ffff55c8f65 in ?? () from /usr/lib/libQtGui.so.4
> > #28 0x00007ffff55c78ac in QApplication::x11ProcessEvent(_XEvent*) ()
> > from /usr/lib/libQtGui.so.4
> > #29 0x00007ffff55f4199 in ?? () from /usr/lib/libQtGui.so.4
> > #30 0x00007ffff506e992 in
> > QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) ()
> > from /usr/lib/libQtCore.so.4
> > #31 0x00007ffff506ed6c in
> > QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) ()
> > from /usr/lib/libQtCore.so.4
> > #32 0x00007ffff5072aab in QCoreApplication::exec() ()
> > from /usr/lib/libQtCore.so.4
> > #33 0x00007ffff6d3a1cc in hook_loop () at main.cpp:673
> > #34 0x000000000041ee78 in main (argc=1, argv=<value optimized out>)
> > at gbx.c:356
> > (gdb)
>
> The database could not be opened, and the crash actually occurs while
> releasing an ODBC handle before returning the error.
>
> At the moment, I don't know why releasing the handle crashes: I don't know
> ODBC and didn't write that code.
>
> I need the full project source code: I need to know what database code is
> executed, in order, to see what has been executed because the offended Exec()
> call.
>
> Regards,
>
My contact said me that it is a little big difficult....
The code itself is very simple:
With Connection
.Type = "odbc"
.Host = "odbc connection name"
.User
.Password
End With
Connectio.Exec("my query") '<-- here is the point where the error is
raised'
But using ODBC he should also post a DB (any of the DBs that uses ODBC
driver) and the configuration files (odbc.ini & odbcinst.ini)... and he
said me that it is not so easy...
Does anyone else has tried to connect to a MS-SQL database with Gambas?
If yes, how does he have resolved such problem?
--
Leonardo Miliani
www.leonardomiliani.com
Webmaster e co-fondatore di www.gambas-it.org
Il portale di riferimento per i programmatori Gambas italiani
More information about the User
mailing list