The DontDlClose was a suggestion to stop the seg faulting on exit.
When I said you can use DSN=emanuel-sbart;UID=*;PWD=*; I did of course mean to
say you need to keep the 'dbi:ODBC' on the front. i.e.
'dbi:ODBC:DSN=emanuel-sbart;UID=*;PWD=*;'
Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development
On 22-Feb-2005 Walter Obermiller wrote:
> Martin, thanks.
>
> I checked. my unixodbc is indeed threaded.
>
> The driver library however, is not:
>
> /usr/local/lib/odbclib.so
> /lib/libNoVersion.so.1 => /lib/libNoVersion.so.1 (0x400a9000)
> linux-gate.so.1 => (0xffffe000)
> libsqlrte.so => /usr/local/lib/libsqlrte.so (0x400ce000)
> libm.so.6 => /lib/tls/libm.so.6 (0x40109000)
> libc.so.6 => /lib/tls/libc.so.6 (0x4012c000)
> /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
>
>
> Even with dontDLClose=1 set, I get the dreaded:
>
> Can't connect to data source DSN=emanuel-sbart;UID=*;PWD=*;, no
> database driver specified and DBI_DSN env var not set at
> odbc-emanuel-test.pl line 17
>
> message. In particular, do you have any idea how I should interpret the
> 'no database driver' specified part of the message; is this the result
> of an earlier failure or does it mean something?
>
>
> -walt
>
>
>
>> Quoting Walter Obermiller <[EMAIL PROTECTED]>:
>>
>>
>>>Martin,
>>>
>>>thanks for your reply.
>>>
>>>as to the version of unixodbc, I use what is part of SuSe 9.2:
>>>
>>> Name : unixODBC Relocations: (not relocatable)
>>> Version : 2.2.9 Vendor: SUSE LINUX AG, Nuernberg, Germany
>>> Release : 4 Build Date: Mo 04 Okt 2004 22:49:44
>>>
>>>Is there a way other than recompiling to check whether threading is
>>>enabled in this build ?
>>
>
>> Try running ldd on libodbc.so and if it mentions pthread library it is
>> probably built with --enable-threads=yes.
>>>Changing the connect string to
>>>
>>> my $dbh = DBI->connect('DSN=emanuel-sbart;UID=***;PWD=***;')
>>>
>>> || die "can't connect to $data_source: $DBI::errstr";
>>>
>>>as you suggested results in the message:
>>>
>>> Can't connect to data source DSN=emanuel-sbart;UID=***;PWD=***;,
>>> no database driver specified and DBI_DSN env var not set at
>>> odbc-emanuel-test.pl line 17
>>>
>>>You asked about the driver I am using:
>>>
>>>-----------/etc/unixODBC/odbcinst.ini--------------
>>>[AdabasD]
>>>Description = AdabasD -Treiber
>>>Driver = /usr/local/lib/odbclib.so
>>>
>>>this .so is from the adabas11-06 distribution.
>>>
>>>-------------/etc/odbc.ini
>>>[emanuel-sbart]
>>>Description = Adabas 11.06 on emanuel
>>>Driver = AdabasD
>>>Server = emanuel
>>>Database = sbart
>>>
>>
>>
>> Try adding DontDLClose=1 to your driver entry in the odbcinst.ini
>> file. It stop unixODBC calling dlclose. Sometimes drivers install atexit
>> handlers and once the driver manager has unloaded the .so they are invalid
>> at exit time.
>>
>> Martin
>>
>>
>>>Martin Evans wrote:
>>>
>>>>I might be wrong - my info is well out of date... but on Linux, Perl built
>>>>multithreaded always segfaulted with unixODBC. I think this happened even
>>>
>>>if
>>>
>>>>unixODBC was built threaded (--enable-threads=yes - the default for
>>>
>>>unixODBC's
>>>
>>>>configure but I'd check your unixODBC was built threaded). I can't remember
>>>
>>>the
>>>
>>>>exact reason I'm afraid. isql is not threaded.
>>>>
>>>>The data source not found message may be related to what DBD::ODBC does.
>>>>It first tries to call SQLDriverConnect with (in your case) emanuel-sbart
>>>
>>>and
>>>
>>>>when that fails calls SQLConnect(emanuel-sbart) - you can see this in your
>>>
>>>log.
>>>
>>>>You can get around this by making the DBI connect string
>>>>"DSN=emanuel-sbart;UID=db_user;PWD=db_pass;". See
>>>>
>>>>http://www.easysoft.com/products/9999/faq_answer.phtml?ID=97&product=2002
>>>>
>>>>but it won't make the segfault go away. I'd rebuild your Perl without
>>>
>>>threads if
>>>
>>>>I were you.
>>>>
>>>>You can also see from your log that the SQLConnect succeeeds.
>>>>
>>>>BTW, you did not mention which driver you were using.
>>>>
>>>>Martin
>>>>
>>>>Quoting Walter Obermiller <[EMAIL PROTECTED]>:
>>>>
>>>>
>>>>
>>>>>Hi, all
>>>>>
>>>>>I am experiencing a puzzling problem while trying to get an DBD::ODBC
>>>>>connection (via unixODBC) working from a client machine A (Suse linux)
>>>>>to a an ADABAS-D-11 database running on a remote machine (B, also Suse
>>>>>linux)
>>>>>
>>>>>
>>>>>-------------------------- Machine A (client)
>>>>> Linux 2.6.8-2
>>>>> Perl : 5.008005 (i586-linux-thread-multi)
>>>>> OS : linux (2.6.8.1)
>>>>> DBI : 1.43
>>>>> DBD::Proxy : install_driver(Proxy) failed: Can't locate
>>>>>RPC/PlClient.pm in @INC
>>>>> DBD::ODBC : 1.06
>>>>>----------------------------------------------
>>>>>
>>>>>
>>>>>Connections using isql (unixODBC) from machine A to machine B run
>>>>>smoothly, hence I reckon, unixodbc and prima facie odbc-configuration
>>>>>blotches are not the problem.
>>>>>
>>>>>
>>>>>When I try to trivially connect with DBD::ODBC to the very same DSN
>>>>>that I could connect to using isql without a problem, I get a
>>>>>segmentation fault.
>>>>>
>>>>>----------trivial-connect----------------------
>>>>>#!/usr/bin/perl
>>>>>use DBI;
>>>>>my $dbh = DBI->connect('dbi:ODBC:emanuel-sbart', '***','***') ||
>>>>> die "can't connect to $data_source: $DBI::errstr";
>>>>>$rc = $dbh->disconnect;
>>>>>exit();
>>>>>--------------------------------
>>>>>
>>>>>and inspection of the sql.log (of unixodbc) reveals the error message:
>>>>>
>>>>>---------------------
>>>>>Message Text = [[unixODBC][Driver Manager]Data source name not found,
>>>>>and no default driver specified]
>>>>>[ODBC][13206][SQLError.c][424]
>>>>>-------------------------------
>>>>>
>>>>>
>>>>>Can anybody give me an idea which direction could be pursued to solve
>>>>>this problem ?
>>>>>
>>>>>What beats me is that isql can connect to my remote database, but an
>>>>>dbd::odbc connection to the same DSN utterly fails.
>>>>>
>>>>>Any hints welcome.
>>>>>
>>>>> -walter
>>>>>
>>>>>
>>>>>
>>>>>--------------sql.log------------------------------------------------------
>>>>>--
>>>>>
>>>>>[ODBC][13206][__handles.c][421]
>>>>> Exit:[SQL_SUCCESS]
>>>>>
>>>>
>>>> Environment = 0x82ce928
>>>>
>>>>
>>>>>[ODBC][13206][SQLSetEnvAttr.c][182]
>>>>> Entry:
>>>>>
>>>>
>>>> Environment = 0x82ce928
>>>>
>>>>
>>>>>
>>>>
>>>> Attribute = SQL_ATTR_ODBC_VERSION
>>>>
>>>>
>>>>>
>>>>
>>>> Value = 0x3
>>>>
>>>>
>>>>>
>>>>
>>>> StrLen = -6
>>>>
>>>>
>>>>>[ODBC][13206][SQLSetEnvAttr.c][349]
>>>>> Exit:[SQL_SUCCESS]
>>>>>[ODBC][13206][SQLAllocHandle.c][346]
>>>>> Entry:
>>>>>
>>>>
>>>> Handle Type = 2
>>>>
>>>>
>>>>>
>>>>
>>>> Input Handle = 0x82ce928
>>>>
>>>>
>>>>>[ODBC][13206][SQLAllocHandle.c][464]
>>>>> Exit:[SQL_SUCCESS]
>>>>>
>>>>
>>>> Output Handle = 0x82ceeb8
>>>>
>>>>
>>>>>[ODBC][13206][SQLDriverConnect.c][666]
>>>>> Entry:
>>>>>
>>>>
>>>> Connection = 0x82ceeb8
>>>>
>>>>
>>>>>
>>>>
>>>> Window Hdl = (nil)
>>>>
>>>>
>>>>>
>>>>
>>>> Str In = [emanuel-sbart][length = 13]
>>>>
>>>>
>>>>>
>>>>
>>>> Str Out = 0xbfffdfc0
>>>>
>>>>
>>>>>
>>>>
>>>> Str Out Max = 2048
>>>>
>>>>
>>>>>
>>>>
>>>> Str Out Ptr = 0xbfffdfbe
>>>>
>>>>
>>>>>
>>>>
>>>> Completion = 0
>>>>
>>>>
>>>>>[ODBC][13206][SQLDriverConnect.c][998]Error: IM002
>>>>>[ODBC][13206][SQLError.c][424]
>>>>> Entry:
>>>>>
>>>>
>>>> Connection = 0x82ceeb8
>>>>
>>>>
>>>>>
>>>>
>>>> SQLState = 0xbfffdf60
>>>>
>>>>
>>>>>
>>>>
>>>> Native = 0xbfffdd58
>>>>
>>>>
>>>>>
>>>>
>>>> Message Text = 0xbfffdd60
>>>>
>>>>
>>>>>
>>>>
>>>> Buffer Length = 511
>>>>
>>>>
>>>>>
>>>>
>>>> Text Len Ptr = 0xbfffdd5e
>>>>
>>>>
>>>>>[ODBC][13206][SQLError.c][461]
>>>>> Exit:[SQL_SUCCESS]
>>>>>
>>>>
>>>> SQLState = IM002
>>>>
>>>>
>>>>>
>>>>
>>>> Native = 0xbfffdd58 -> 0
>>>>
>>>>
>>>>>
>>>>
>>>> Message Text = [[unixODBC][Driver Manager]Data source name not found,
>>>>
>>>>
>>>>>and no default driver specified]
>>>>>[ODBC][13206][SQLError.c][424]
>>>>> Entry:
>>>>>
>>>>
>>>> Connection = 0x82ceeb8
>>>>
>>>>
>>>>>
>>>>
>>>> SQLState = 0xbfffdf60
>>>>
>>>>
>>>>>
>>>>
>>>> Native = 0xbfffdd58
>>>>
>>>>
>>>>>
>>>>
>>>> Message Text = 0xbfffdd60
>>>>
>>>>
>>>>>
>>>>
>>>> Buffer Length = 511
>>>>
>>>>
>>>>>
>>>>
>>>> Text Len Ptr = 0xbfffdd5e
>>>>
>>>>
>>>>>[ODBC][13206][SQLError.c][461]
>>>>> Exit:[SQL_NO_DATA]
>>>>>[ODBC][13206][SQLConnect.c][3495]
>>>>> Entry:
>>>>>
>>>>
>>>> Connection = 0x82ceeb8
>>>>
>>>>
>>>>>
>>>>
>>>> Server Name = [emanuel-sbart][length = 13]
>>>>
>>>>
>>>>>
>>>>
>>>> User Name = [walter][length = 6]
>>>>
>>>>
>>>>>
>>>>
>>>> Authentication = [***][length = 3]
>>>>
>>>>
>>>>> UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
>>>>>
>>>>>[ODBC][13206][SQLConnect.c][4069]
>>>>> Exit:[SQL_SUCCESS]
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>>
