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
