ahh well deduced, and as you say all works (virtuoso isql is much better)! # /usr/local/virtuoso-opensource/bin/isql localhost:1111 dba dba Connected to OpenLink Virtuoso Driver: 06.00.3124 OpenLink Virtuoso ODBC Driver
consider it symlink'd; thanks hugh :) Hugh Williams wrote: > Hi Nathan, > > So you are using the isql program bundled with unixODBC, which is not what > should be used as Virtuoso has its own :-) > > The Virtuoso isql command line program is installed in the "bin" directory of > your Virtuoso installation: > > $ /usr/local/virtuoso-opensource/bin/isql -? > OpenLink Interactive SQL (Virtuoso), version 0.9849b. > > Usage : > isql <HOST>[:<PORT>] <UID> <PWD> file1 file2 ... > > isql -H <server_IP> [-S <server_port>] [-U <UID>] [-P <PWD>] > [-E] [-X <pkcs12_file>] [-K] [-C <num>] [-b <num>] > [-u <name>=<val>]* [-i <param1> <param2>] > isql -? > Connection options: > > -? - This help message > -U username - Specifies the login user ID > -P password - Specifies the login password > -H server_addr - Specifies the Server address (IP) > -S server port - Specifies the TCP port to connect to > -E - Specifies that encryption will be used > -C - Specifies that password will be sent in cleartext > -X pkcs12_file - Specifies that encryption & X509 certificates will > be used > -T server_cert - Specifies that CA certificate file to be used > -b size - Specifies that large command buffer to be used > (in KBytes) > -K - Shuts down the virtuoso on connecting to it > > Parameter passing options: > > -u name1=val1... - Everything after -u is stored to associative array U, > until -i is encountered. If no equal sign then value > is NULL > -i - Ignore everything after the -i option, after which > comes arbitrary input parameter(s) for isql procedure, > which can be referenced with $ARGV[$I] by the > ISQL-commands. > <OPT>=<value> - Sets the ISQL options > > Note that if none of the above matches then the non-options go as > <HOST>[:<PORT>] <UID> <PWD> file1 file2 ... > > Which has many Virtuoso specific options that would not work other programs > of the same name and is what any of our documentation or tutorials etc. > use. Full details on the use of the "Virtuoso" isql program (and its > variants) are available at: > > http://docs.openlinksw.com/virtuoso/isql.html > > I hope this clears things up for all ... > > 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 18:52, Nathan wrote: > >> 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 >>> >>> > > >
