odbc on linux failing after upgrade to build 26 Jun 2014

[Orvalho Augusto]

Dears!

I have updated my Stata to build 26 Jun 2014. On Linux Xubuntu 12.04 64 bit. Now my ODBC connection does not work (they worked before the upgrade).
When I start Stata does not even know my last set odbmgr. I have to set it again.

. odbc exec("drop table if exists cism.iva_neonat"), dsn(vutisela3308)
The function SQLDataSources could not be found in libodbc.so,
therefore, some ODBC services may be unavailable.

My laptop has unixodbc. So I do:
. set odbcmgr unixodbc
. odbc exec("drop table if exists cism.iva_neonat"), dsn(vutisela3308)
r(680);

I went to Stata 12 (which I still have on the same laptop). The command runs well.

Can someone confirm this as a new bug? Or am I doing something wrong?

Orvalho

[Orvalho Augusto]

Just an update.

I download iodbc and installed with /usr/local prefix. Then I went to /usr/lib created symbolic links to iodbc libraries and dear Stata 13 is talking with ODBC.

Thank you
Orvalho

[wbuchanan]

I had a somewhat similar issue recently on Ubuntu 14.04. All I needed to do to solve things (some of the other software I have installed would be removed if I removed unixODBC) was create the symbolic link:

sudo ln -s /usr/local/bin/unixODBC-2.3.2/DriverManager/.libs/libodbc.so /usr/lib/libodbc.so