odbc

[Alf-Ivar Holm]

Me - Atlantic <jdangler at atlantic.net> writes:

> Is anyone familiar with setting up odbc dsn's on ubuntu?
> I have a data modelling package for linux that i'd like to try out but
> it requires odbc.  I installed the odbc package from synaptic, 

Which ODBC package?  I have set up unixODBC (http://www.unixodbc.org/)
for both Warty and Dapper and that was quite straightforward.  I have
not tried iODBC, so I can't help you there.

> along with the mysql odbc package, but i can't find it anywhere on
> any of the desktop menu's.  I found the odbc.ini and odbcinst.ini in
> /etc, but they are both empty.  Any input is welcome.

As you have the MyODBC driver and obviously some ODBC package, all you
need is to fill in the rest in the /etc files.  There are descriptions
and examples in the MySQL documentation:

http://dev.mysql.com/doc/refman/5.1/en/myodbc-configuration-dsn-unix.html

If you would rather use a GUI more like the Windows ODBC setup, I
recommend the unixodbc-bin package, which includes tools for just
that, specifically ODBCConfig(1).  Note: installing the unixodbc-bin
package also installs all the needed unixODBC packages.

        Affi