Re: [Iodbc-list] Problem with iODBC

[<iod...@li...>]

iod...@li... writes:

> When I run odbctest I get these results:

odbctest or iodbctest? As of the last couple of versions of iodbc (3.51.x,
I think), it's been called the latter - so which version of iodbc are you
using?

What platform is this on, and is this a prebuilt binary or one you compiled
from source yourself?

> Enter ODBC connect string (? shows list): ?
>
> DSN                              | Driver
> ------------------------------------------------------------------------------
>                                  | MyTest Connection
>                                  | PostgreSQL Driver
>
> Enter ODBC connect string (? shows list): DSN=MyTest

> SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be
> loaded, SQLSTATE=IM003 : cannot open shared object file: No such file or
> directory, SQLSTATE=00000

> Here is my odbc.ini file:
[snip]
> [MyTest]
> Driver		= /usr/lib/psqlodbc.so

As a random guess, can you try that without the tab-characters in there? 

I copied your odbc.ini and exported ODBCINI to point to it, no problems
here with 3.51.2...

> Why would the odbctest program not list the DSN column? and what could
> cause it not to be able to load the driver. I've checked the path and the
> driver is there, and I ran ldd and checked to make sure all of the
> dependencies are also where it's looking.

Ah. I was going to ask about the file's existence and executability. 

I can suggest the following courses of action:

0) if you're not using 3.51.2, how about upgrading?

1) if you're not compiling iodbctest for yourself, how about doing so?

2) strace -o strace.out -f -s 1500 -v iodbctest
   and have a look for references to psqlodbc.so starting from the bottom
   of the logfile backwards - maybe post an extract of the resultant strace
   log somewhere we can have a look.

HTH,

~Tim
-- 
OpenLink Software
Tel: +44 (0) 20 8681 7701
Web: <http://www.openlinksw.com>
Universal Data Access & Data Integration Technology Providers