ODBC errors RedHat 6.2 unixodbc to SqlServer 2000 on XP

Eric Aslakson aslakson at hep.caltech.edu
Wed Jun 12 21:26:05 EDT 2002


Hi All,

I would like to use a toolkit called OTL that requires a somewhat full
featured odbc driver to speak to SQLServer.  I am able to connect using
the 0.53 version, but experience problems with positional parameters:

(gdb) run
Starting program: /home/era/root2sql/.libs/lt-ex21_odbc

Program received signal SIGSEGV, Segmentation fault.
lt_dlloader_find (loader_name=0x0) at ltdl.c:3108
3108    {
Current language:  auto; currently c
(gdb) bt
#0  lt_dlloader_find (loader_name=0x0) at ltdl.c:3108
#1  0x4007a700 in __post_internal_error_ex () at ltdl.c:2370
#2  0x4007b20d in __post_internal_error_ex () at ltdl.c:2370
#3  0x4005d7ca in SQLPrepare (statement_handle=0x8061a98,
    statement_text=0x805ebd0 "insert into test_tab values(?         ,?", '
' <re
peats 12 times>, ")", text_length=-3) at SQLPrepare.c:373
#4  0x80531a3 in otl_cur::parse (this=0x8061808,
    stm_text=0x805ebd0 "insert into test_tab values(?         ,?", ' '
<repeats
12 times>, ")") at otlv4.h:8241
#5  0x80507ed in otl_tmpl_cursor<otl_exc, otl_conn, otl_cur, otl_var>::parse (
    this=0x8061800) at otlv4.h:3410
#6  0x804ffdf in
otl_tmpl_inout_stream<otl_exc, otl_conn, otl_cur, otl_var, tagT
IMESTAMP_STRUCT>::otl_tmpl_inout_stream (this=0x8061800, arr_size=50,
    sqlstm=0x8054880 "insert into test_tab values(:f1<float>,:f2<char[31]>)",
    db=@0x8059260, alob_stream_mode=false) at otlv4.h:6353
#7  0x804f89b in otl_stream::open (this=0xbffffae4, arr_size=50,
    sqlstm=0x8054880 "insert into test_tab values(:f1<float>,:f2<char[31]>)",
    db=@0x8059260, implicit_select=0) at otlv4.h:9603
#8  0x804be0f in otl_stream::otl_stream (this=0xbffffae4, arr_size=50,
    sqlstm=0x8054880 "insert into test_tab values(:f1<float>,:f2<char[31]>)",
    db=@0x8059260, implicit_select=0) at otlv4.h:9428
#9  0x80492fd in insert () at ex21_odbc.cc:18
#10 0x804957e in main () at ex21_odbc.cc:79

and also with SqlExecDirec statements:

(gdb) run
Starting program: /home/era/root2sql/.libs/lt-ex21_odbc

Program received signal SIGSEGV, Segmentation fault.
lt_dlloader_find (loader_name=0x0) at ltdl.c:3108
3108    {
Current language:  auto; currently c
(gdb) bt
#0  lt_dlloader_find (loader_name=0x0) at ltdl.c:3108
#1  0x4007a700 in __post_internal_error_ex () at ltdl.c:2370
#2  0x4007b20d in __post_internal_error_ex () at ltdl.c:2370
#3  0x40054739 in SQLExecDirect (statement_handle=0x8060338,
    statement_text=0x805ef50 "drop table test_tab", text_length=-3)
    at SQLExecDirect.c:433
#4  0x804e2ff in otl_cur::parse (this=0xbffffad0,
    stm_text=0x805ef50 "drop table test_tab") at otlv4.h:8195
#5  0x804b17d in otl_tmpl_cursor<otl_exc, otl_conn, otl_cur, otl_var>::parse (
    this=0xbffffac8) at otlv4.h:3410
#6  0x8049974 in otl_tmpl_cursor<otl_exc, otl_conn, otl_cur, otl_var>::parse (
    this=0xbffffac8, sqlstm=0x8054b83 "drop table test_tab") at
otlv4.h:3432
#7  0x80497a6 in otl_tmpl_cursor<otl_exc, otl_conn, otl_cur, otl_var>::direct_ex
ec (connect=@0x80595e0, sqlstm=0x8054b83 "drop table test_tab",
    exception_enabled=0) at otlv4.h:3593
#8  0x804958a in main () at ex21_odbc.cc:71

One question I have is the conformance level of the current driver.  Does
it correspond to a version ODBC v.2, 2.5, or 3 driver?

I'm trying to hear your opinion of how close I might be on this, as I'm on
a very tight schedule.

Thanks all,

Eric



More information about the FreeTDS mailing list