Just did a quick dependency check. isql is provided by unixodbc (not iodbc) on ubuntu
# aptitude show unixodbc Package: unixodbc Depends: libc6 (>= 2.7-1), libltdl3 (>= 1.5.2-2), libreadline5 (>= 5.2), odbcinst1debian1 (>= 2.2.11-3) iodbc itself is not installed by default so needs an apt-get regards :) Hugh Williams wrote: > Hi Nathan, > > Hmmm, that is confusing to me as isql should not have an iODBC dependancy, as > is the case on my Mac OS X and Debian Linux boxes: > > $ ldd isql > linux-gate.so.1 => (0xb7eef000) > libssl.so.0.9.8 => /usr/lib/i686/cmov/libssl.so.0.9.8 (0xb7e96000) > libcrypto.so.0.9.8 => /usr/lib/i686/cmov/libcrypto.so.0.9.8 (0xb7d43000) > libm.so.6 => /lib/libm.so.6 (0xb7d1d000) > libc.so.6 => /lib/libc.so.6 (0xb7bdf000) > libdl.so.2 => /lib/libdl.so.2 (0xb7bdb000) > libz.so.1 => /usr/lib/libz.so.1 (0xb7bc6000) > /lib/ld-linux.so.2 (0xb7ef0000) > > Their is a variant of isql called isql-iodbc which can be built is specified > in Makefile which as the name implies is bound to iODBC and hence can make an > ODBC connection to a Virtuoso or and other ODBC data source a suitable DSN > exists for, and it seems this program has for some reason been built as the > default isql on ubuntu ??? > > Will have to check with development if this is the case for ubuntu ... > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 28 Nov 2009, at 15:50, Nathan wrote: > >> For anybody who can't connect to virtuoso via isql on ubuntu (ie getting >> the following error) >> >> # isql localhost:1111 dba pass >> [ISQL]ERROR: Could not SQLConnect >> >> here's how to sort it.. >> >> >> install iodbc: >> # apt-get install iodbc >> >> >> create a dsn connection: >> # nano /etc/odbc.ini >> >> >> enter the following (where the path to driver is the path to your >> virtodbc.so driver): >> [LocalVirt] >> Driver = /usr/local/virtuoso-opensource/lib/virtodbc.so >> Address = localhost:1111 >> >> >> install the new dsn >> # odbcinst -i -s -l -f /etc/odbc.ini >> >> >> and now you can connect using the dsn >> # isql LocalVirt dba pass >> Connected! >> >> >> [one for the archive] >> >> regards! >> >> ------------------------------------------------------------------------------ >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day >> trial. Simplify your report design, integration and deployment - and focus >> on >> what you do best, core application coding. Discover what's new with >> Crystal Reports now. http://p.sf.net/sfu/bobj-july >> _______________________________________________ >> Virtuoso-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > >
