logo       
Google Custom Search
    AddThis Social Bookmark Button

Re: ODBC driver configuration: msg#00008

Subject: Re: ODBC driver configuration
--- Barrie Backhurst <barrie.backhurst@xxxxxxxxxxxx> 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


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click


<Prev in Thread] Current Thread [Next in Thread>