Re: [Iodbc-applications] problems installing ODBC

[Tim H. <th...@op...>]

Kevin Ryan <air...@ya...> writes:

> So there is not a default .odbc.ini template automatically created when I
> "make install" for iodbc?

There's a sample in the FAQ
(<http://www.iodbc.org/index.php?page=docs/faq#iodbc333712082>) for the
copying&pasting thereof, or you could use iodbcadm-gtk if you built it with
GTK/GUI enabled.

> Can you be more specific about exactly what I would do after "make
> install" (which would constitute 'installing an odbc driver')

Suggested batting order:

0) install iodbc;

1) install an ODBC driver for your database from somewhere - openlink - your
   database vendor - any number of third-parties: the recommended
   installation process will vary according to driver but ultimately it all
   boils down to...

2) configure $ODBCINI - either by hand (quick enough) or with the GTK
   administrator: make sure the Driver= is the ODBC driver and the other
   parameters are things it understands to point at a specific instance of
   the database;

3) run `iodbctest DSN=something' to ensure you can connect;

4) install perl's DBI module;

5) grab perl's DBD::ODBC module and build it against the prefix where you
   installed iODBC;

6) set the relevant environment variables and run a `make test';

7) try a test perl script like the one at the bottom of the HOWTO.

HTH,

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