Re: [mdb-dev] ODBC driver configuration

[Jeff S. <why...@ya...>]

--- Barrie Backhurst <bar...@nt...> wrote:
> Hi
> 
> I have just installed mdbtools 0.5, along with unixodbc on slackware 9.1
> 
> The tools work fine with a test mdb file, but I am having problems configuring 
> the odbc. I have edited odbc.ini as advised in your post install 
> instructions, but OpenOffice will not connect. I have tried using ODBCConfig, 
> but there does not appear to be a setup library available and when I try to 
> configure the DSN, the folowing error is generated:-
> 
> 	Could not construct a property list for (/usr/local/lib/libmdbodbc.so)

You are correct, there is a driver, but no setup library.  The convention seems
to be that setup libraries end with a capital S (e.g. libodbcmyS.so, libtdsS.so).
I have not seen anything like that from unixODBC or from mdbtools.

I have had problems with having it in the system DSN's (/etc/odbc.ini), so I
put the definitions in the user DSN's instead ($HOME/.odbc.ini).  Try this if
you have not already.

To test, use unixODBC's isql tool.  Run 'isq your_DSN' and try executing a
select statement ('select * from some_table').
 
> I guess I am missing something simple here, but I have been over it several 
> times and cannot find the answer.
> 
> Barrie

Hope some of this helps.

 -- Jeff S

__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster
http://search.yahoo.com