[unixODBC-support] ODBC Error while connecting

Nick Gorham nick at easysoft.com
Fri Jul 30 14:44:29 BST 2004


Lebogang Masenya wrote:
> Thanks Nick for the previous response. it helped a lot.
>  
> My next question is how do you configure DSN in linux. I keep on getting 
> the error below when trying to connect using SQLConnect.
>  
> [unixODBC][Driver Manager]Data source nane not found, and no default 
> driver specified
>  
>  
> I have edittde the files /etc/odbcinst.ini and /etc/odbc.ini to input 
> the necessary info i found in the www.unixodbc.org 
> <http://www.unixodbc.org> site. what could i be doing wrong.

Check that its using the ini files from that location, try

strace isql -v dsn 2>st.log

and look in st.log to see just what ini files it is using.

-- 
Nick



More information about the unixODBC-support mailing list