Dear all,

I am trying to get unixodbc installed on debian without success.

I followed the instruction exactly from
http://www.debian-administration.org/articles/496


When I try to connect, it keeps giving me error:
ser:/usr/local/freeswitch/scripts# isql -v fsdb
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/odbc/
libmyodbc3_r-3.51.11.so' : /usr/lib/odbc/libmyodbc3_r-3.51.11.so: cannot
open shared object file: No such file or directory
[ISQL]ERROR: Could not SQLConnect

It says the driver is missing even after I do "apt-get install libmyodbc".
I tried apt-get remove and apt-get install a few times, no luck as well.

when I do "locate libmyodbc", no result returns. So, I think the driver is
not there, but I don't know how to install the driver.

Please kindly give me some ideas as to what I did wrong?

Thanks alot in advance for your inputs.

Regards,
Pete

Hi Andrei,

Thanks alot. I apt-get purge the libmyodbc and then install it again and it
is working now.

Thanks alot for your .

Regards,
Pete

On Sat, Apr 19, 2008 at 5:20 PM, Andrei Popescu <andreimpopescu@gmail.com>
wrote:

> On Sat, Apr 19, 2008 at 04:49:58PM +0800, Pete Kay wrote:
> > Dear all,
> >
> > I am trying to get unixodbc installed on debian without success.
> >
> > I followed the instruction exactly from
> > http://www.debian-administration.org/articles/496
>
> Did you also read the comments? There is a mention of a similar error.
>
> > When I try to connect, it keeps giving me error:
> > ser:/usr/local/freeswitch/scripts# isql -v fsdb
> > [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/odbc/
> > libmyodbc3_r-3.51.11.so' : /usr/lib/odbc/libmyodbc3_r-3.51.11.so: cannot
> > open shared object file: No such file or directory
> > [ISQL]ERROR: Could not SQLConnect
> >
> > It says the driver is missing even after I do "apt-get install
> libmyodbc".
> > I tried apt-get remove and apt-get install a few times, no luck as well.
> >
> > when I do "locate libmyodbc", no result returns. So, I think the driver
> is
> > not there, but I don't know how to install the driver.
>
> locate uses a database which is recreated usually once per night. Either
> you run 'updatedb' as root or use 'find' for new stuff. If you know the
> exact location 'ls' is much easier. Try this:
>
> ls /usr/lib/odbc/libmyodbc*
>
> 'dpkg -l libmyodbc' will also show you if dpkg *thinks* the package is
> installed correctly (dpkg should also be correct about it unless you
> messed with the package behind its back).
>
> HTH,
> Andrei
> --
> If you can't explain it simply, you don't understand it well enough.
> (Albert Einstein)
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFICblvqJyztHCFm9kRAuwzAJ9EGPP0J3YzuD+upxVO96 BL0ZVOZwCglgyT
> 2vUymrKsx2R1AjjxG+Yuqbs=
> =YuVa
> -----END PGP SIGNATURE-----
>
>

On Sat, Apr 19, 2008 at 04:49:58PM +0800, Pete Kay wrote:
> Dear all,
>
> I am trying to get unixodbc installed on debian without success.
>
> I followed the instruction exactly from
> http://www.debian-administration.org/articles/496

Did you also read the comments? There is a mention of a similar error.

> When I try to connect, it keeps giving me error:
> ser:/usr/local/freeswitch/scripts# isql -v fsdb
> [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/odbc/
> libmyodbc3_r-3.51.11.so' : /usr/lib/odbc/libmyodbc3_r-3.51.11.so: cannot
> open shared object file: No such file or directory
> [ISQL]ERROR: Could not SQLConnect
>
> It says the driver is missing even after I do "apt-get install libmyodbc".
> I tried apt-get remove and apt-get install a few times, no luck as well.
>
> when I do "locate libmyodbc", no result returns. So, I think the driver is
> not there, but I don't know how to install the driver.

locate uses a database which is recreated usually once per night. Either
you run 'updatedb' as root or use 'find' for new stuff. If you know the
exact location 'ls' is much easier. Try this:

ls /usr/lib/odbc/libmyodbc*

'dpkg -l libmyodbc' will also show you if dpkg *thinks* the package is
installed correctly (dpkg should also be correct about it unless you
messed with the package behind its back).

HTH,
Andrei
--
If you can't explain it simply, you don't understand it well enough.
(Albert Einstein)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFICblvqJyztHCFm9kRAuwzAJ9EGPP0J3YzuD+upxVO96 BL0ZVOZwCglgyT
2vUymrKsx2R1AjjxG+Yuqbs=
=YuVa
-----END PGP SIGNATURE-----