Hi, I have some problems using the example of database project with an oracle database trough ODBC. I installed gambas 2.20.2 (the latest stable) on Ubuntu 10.4 Desktop. I installed UnixODBC 2.2.11.21 using the ubuntu software center and installed the oracle 10.2.0.3 ODBC from oracle. I configured it and using isql from terminal, it works. When i try to use the database example, i use odbc connection and it works but when i try to run a simple query that return almost a row, gambas crashes with error #11 with this log:(gdb) runStarting program: /usr/local/bin/gbx2 -p[Thread debugging using libthread_db enabled]Program received signal SIGSEGV, Segmentation fault.0x01227a91 in SQLColAttributeW () from /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1(gdb) bt#0 0x01227a91 in SQLColAttributeW () from /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1#1 0x00feb5a4 in SQLColAttribute () from /usr/lib/libodbc.so.1#2 0x00fdf698 in query_fill (db=0x825bba4, result=0x827ddc8, pos=0, buffer=0x828ec88, next=0) at main.c:1179#3 0x00fd63b7 in load_buffer (_object=0x82fe260, vpos=0) at CResult.c:145#4 0x00fd6d08 in DB_MakeResult (conn=0x825bb98, mode=0, table_temp=0x0, query=0x8299c58 "select * from mytable") at CResult.c:305#5 0x00fd4037 in CCONNECTION_exec (_object=0x825bb98, _param=0x807f878) at CConnection.c:454#6 0x0804e92c in EXEC_call_native (exec=0xfd3fd4 <CCONNECTION_exec>, object=0x825bb98, type=135043168, param=0x807f878) at gbx_exec.c:844#7 0x0804f230 in EXEC_native () at gbx_exec.c:962#8 0x0806bbd8 in EXEC_loop () at gbx_exec_loop.c:1042#9 0x0804f533 in EXEC_function_loop () at gbx_exec.c:703#10 0x0804f809 in EXEC_function_real () at gbx_exec.c:690#11 0x0805d54b in raise_event (observer=0x0, object=<value optimized out>, func_id=<value optimized out>, nparam=0) at gbx_api.c:490#12 0x0805da63 in GB_Raise (object=0x824aaa8, event_id=16, nparam=0) at gbx_api.c:594#13 0x00353e44 in gb_raise_button_Click (sender=0x824aec0) at CButton.cpp:44#14 0x003324aa in gControl::emit (this=0xfdfba9, signal=0x0) at gcontrol.cpp:1482---Type <return> to continue, or q <return> to quit---#15 0x00337950 in bt_click (object=0x820da58, data=0x824aec0) at gbutton.cpp:58#16 0x00a7adcc in g_cclosure_marshal_VOID__VOID () from /usr/lib/libgobject-2.0.so.0#17 0x00a6d252 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0#18 0x00a8199d in ?? () from /usr/lib/libgobject-2.0.so.0#19 0x00a82db4 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0#20 0x00a83256 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0#21 0x003f7c7a in gtk_button_clicked () from /usr/lib/libgtk-x11-2.0.so.0#22 0x003f9238 in ?? () from /usr/lib/libgtk-x11-2.0.so.0#23 0x00a7adcc in g_cclosure_marshal_VOID__VOID () from /usr/lib/libgobject-2.0.so.0#24 0x00a6b8b9 in ?? () from /usr/lib/libgobject-2.0.so.0#25 0x00a6d252 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0#26 0x00a8123a in ?? () from /usr/lib/libgobject-2.0.so.0#27 0x00a82db4 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0#28 0x00a83256 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0#29 0x003f7d1a in gtk_button_released () from /usr/lib/libgtk-x11-2.0.so.0#30 0x003f7d63 in ?? () from /usr/lib/libgtk-x11-2.0.so.0#31 0x004b5424 in ?? () from /usr/lib/libgtk-x11-2.0.so.0#32 0x00a6b8b9 in ?? () from /usr/lib/libgobject-2.0.so.0#33 0x00a6d252 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0#34 0x00a815e6 in ?? () from /usr/lib/libgobject-2.0.so.0#35 0x00a82c33 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0---Type <return> to continue, or q <return> to quit---#36 0x00a83256 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0#37 0x005e2636 in ?? () from /usr/lib/libgtk-x11-2.0.so.0#38 0x004ada5d in gtk_propagate_event () from /usr/lib/libgtk-x11-2.0.so.0#39 0x004aee07 in gtk_main_do_event () from /usr/lib/libgtk-x11-2.0.so.0#40 0x00361b4d in gambas_handle_event (event=0x81236e8) at gapplication.cpp:532#41 0x007a339a in ?? () from /usr/lib/libgdk-x11-2.0.so.0#42 0x00af05e5 in g_main_context_dispatch () from /lib/libglib-2.0.so.0#43 0x00af42d8 in ?? () from /lib/libglib-2.0.so.0#44 0x00af44b8 in g_main_context_iteration () from /lib/libglib-2.0.so.0#45 0x004af1b3 in gtk_main_iteration_do () from /usr/lib/libgtk-x11-2.0.so.0#46 0x0035f6de in do_iteration (do_not_block=false, do_not_sleep=false) at main.cpp:470#47 0x0035fd15 in my_loop () at main.cpp:398#48 0x08061c36 in main (argc=Cannot access memory at address 0x1) at gbx.c:358(gdb) this is my odbc.ini[XXXX]Application Attributes = TAttributes = WBatchAutocommitMode = IfAllSuccessfulBindAsFLOAT = FCloseCursor = FDisableDPM = FDisableMTS = TDriver = Oracle 10g ODBC driverDSN = XXXXEXECSchemaOpt = EXECSyntax = TFailover = TFailoverDelay = 10FailoverRetryCount = 10FetchBufferSize = 64000ForceWCHAR = FLobs = TLongs = TMetadataIdDefault = FQueryTimeout = TResultSets = TServerName = XXXXXXXXXSQLGetData extensions = FTranslation DLL = Translation Option = 0DisableRULEHint = TUserID = and odbcinst: [Oracle 10g ODBC driver]Description = Oracle ODBC driver for Oracle 10gDriver = /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1Setup = FileUsage = CPTimeout = CPReuse = I replaced the database name for privacy but with isql t works: if i run select * from mytable i can see the data.the program crashes during the Exec method:PUBLIC SUB btnRun_Click() DIM rData AS Result DIM hForm AS FRequest rData = $hConn.Exec(txtRequest.Text) Thx in advance for your support and apologize for my bad english. Stefano Balzani
------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
