> 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 >
Oops, your mail is unreadable without any newline: can you try to post it again differently so that I can read it? -- Benoît ------------------------------------------------------------------------------ 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
