Downloaded unixODBC-2.2.7.tar.gz from the UnixODBC Web site, unpacked, then
./configure
make
make install
worked like a dream yielding the following files of
particular interest:
/usr/local/etc/odbc.ini
/usr/local/etc/odbcinst.ini
/usr/local/lib/...
/usr/local/bin/isql
/usr/local/bin/ODBCConfig
/usr/local/bin/DataManager
/usr/local/bin/DataManagerII
ODBCConfig --- as root for driver; as user for data-source.
DataManagerII: ensure that on the tree to the left,
User Data Sources
-> vardyurs
-> dbo
is highlighted. Clicking on the "plus" next to dbo should yield
a bunch of stuff including the UserURSDetails table. On the right
are "SQL and Results tabs. In SQL type
SELECT * FROM UserURSDetails WHERE LastName = 'Hood' AND FirstName = 'Simon'and click the "run" icon. After a few second the view automatically changes to Results. Select a different View and "run" again. Lovely.
| ...previous | up (conts) | next... |