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
>>
>>
>>
>
